Hitachi Vantara Pentaho Community Forums

Search Forums:

Type: Posts; User: dibe0015; Keyword(s):

Page 1 of 4 1 2 3 4

Search Forums: Search took 0.02 seconds.

  1. I thought so too but the datatype datetime does...

    I thought so too but the datatype datetime does not contain time zone information as far as I know. Also the shift only happens in the Database join step. If I query for the same data with a table...
  2. Selecting the date from a datetime column in SQL Server - bug?

    Hi,

    I built a ETL process a little while ago against an Oracle database and it all worked fine. I now converted the database to use SQL server instead and I started to run into the issue that when...
  3. Replies
    8
    Views
    3,201

    Sorry it took so long to respond. I had to work...

    Sorry it took so long to respond. I had to work on other project but now I'm back trying to solve this problem.
    I turned on row level logging and found the following in the log files:

    ...
  4. Replies
    8
    Views
    3,201

    Hello Matt, thanks for your quick reply. I am...

    Hello Matt,

    thanks for your quick reply. I am comparing strings, source and target is both an Oracle DB.

    I created a Google Document with screenshots from the transformation, SQL for the...
  5. Replies
    8
    Views
    3,201

    Dimension lookup / update

    Hi,

    I'm trying to use the Dimension lookup / update step to populate a dimension table and I realized that the step always inserts a new version into the dimension table even if the none of the...
  6. Replies
    3
    Views
    1,718

    Same issue

    Hi,

    I have the same issue with PDI 4.1 stable. I get the following stack trace. I use a database repository:

    java.lang.NullPointerException
    at...
  7. Replies
    2
    Views
    1,466

    Hi Kent, that sounds like it would work. I'll...

    Hi Kent,

    that sounds like it would work. I'll try it out the next days. I think I was trying to make it more complicated as it actually is.

    Thanks,
    Benjamin
  8. Replies
    2
    Views
    1,466

    Compare rows in data set

    Hi,

    I work on a data migration process and I want to make sure that I all the data has been moved correct. At the end I only want to see the rows that are not matching.

    I'm able to bring the...
  9. Replies
    1
    Views
    1,147

    Source code for 3.5.2

    Hi,

    I'm looking for the source code for version 3.5.2. I checked the repository and there is a tag 3.5.2 stable and 3.5.2GA. The commits for the stable tag are newer than the one for GA. I guessed...
  10. Solved

    Hi,

    thanks for your answers!

    Deleting the beans in the file /pentaho-solutions/system/sessionStartupActions.xml solved the problem for me.

    Benjamin
  11. session-region-list.xaction - ERROR-007 during login

    Hi,

    I installed Pentaho BI Server 3.5 CE and I deleted the folders in the solutions folder so I can setup my own solutions.

    Whenever I start the server and sign in, I get the following error...
  12. Replies
    7
    Views
    2,299

    Hi, ok I tried it again. The patches are...

    Hi,

    ok I tried it again.
    The patches are copied to project-client\solution, I thought they would be copied to target-dist\solutions, because thats where the script creates a solutions folder by...
  13. Replies
    7
    Views
    2,299

    Hi, I should of added the screenshot, here it...

    Hi,

    I should of added the screenshot, here it is, it is the same structure as in the screenshot in the Pentaho Wiki.

    I'll test it again.

    Benjamin
  14. Replies
    7
    Views
    2,299

    Hi, I'm running into another issue with CBF,...

    Hi,

    I'm running into another issue with CBF, it doesn't copy the changed files into the solutions folder anymore. I have my folders setup as you can see in the attached screenshot.

    Any idea...
  15. Replies
    7
    Views
    2,299

    Thanks for the feedback. It seems to be working...

    Thanks for the feedback. It seems to be working now.

    I thought I tried it once with 1.6 before but I guess one of my system variables (Windows Vista) was still set to 1.5.

    Maybe you want to add...
  16. Replies
    7
    Views
    2,299

    Building with CBF fails

    Hi,

    I downloaded the latest version of CBF, Ant 1.7.1 and xmltask library and I'm using Java 1.5.0.9.

    I setup CBF and when I try to run it, it copies the data into target-build but fails in the...
  17. Replies
    3
    Views
    4,729

    Hi, I just had the issue again that I had to...

    Hi,

    I just had the issue again that I had to created CSV files from weird data.

    Did you ever try to load data in Kettle with the enclosure ""? It seems like Kettle only reads the first ", the...
  18. Replies
    0
    Views
    1,160

    Parent/Child & Average Calculation

    Hi,

    I'm trying to create cube where one dimension is modeled in a parent child hierarchy. when I try to use AVG for the aggregation only the main parent node gets calculated. All other...
  19. Replies
    4
    Views
    1,956

    Hi, I tried it out and i think I got it to...

    Hi,

    I tried it out and i think I got it to work. I first tried the Merge Diff step but the way you described it you'll only have the new/changed row without knowing what the original value was....
  20. Replies
    4
    Views
    1,956

    Hi, thanks for your answer. I'll give that a...

    Hi,

    thanks for your answer. I'll give that a try this week.

    Benjamin
  21. Replies
    4
    Views
    1,956

    Table Insert/Update only when field is NULL

    Hi,

    I'm trying to create a transformation to update a table. But every single field should only be update when the current value is NULL so I don't loose existing data.

    Here is an example:
    ...
  22. Replies
    5
    Views
    10,160

    Hi, yes Mondrian supports it. Once you...

    Hi,

    yes Mondrian supports it.

    Once you have your dimension containing the dates setup as a time dimension you can create queries using the MDX functions YTD(), PeriodsToDate() etc. You might...
  23. Replies
    8
    Views
    5,752

    Hi, I also have the pleasure to work with PDI...

    Hi,

    I also have the pleasure to work with PDI and Postgres and asked Matt already a couple times "Why doesn't it work as it is supposed to?"

    My experience from my project with Postgres & PDI:...
  24. Hmm.. I tried at around 11, around 12 and...

    Hmm..

    I tried at around 11, around 12 and later on again (Toronto time), it always said that it hasn't started and I couldn't sign in. Oh well, maybe another time.

    Thanks for the slides.
    ...
  25. Hi, is it still happening? Am I'm in the wrong...

    Hi,

    is it still happening? Am I'm in the wrong time zone?

    Thanks,
    Benjamin
  26. Replies
    0
    Views
    1,921

    HowTo: Delta Generation with Kettle

    Hi,

    I just wanted to share my little how to on creating a delta file with Kettle. It's nothing very difficult to do so my explanation isn't too long. Feel free if you any more questions.

    Here...
  27. Related JIRA entry:...

    Related JIRA entry: http://jira.pentaho.com/browse/PDI-2733
  28. Replies
    5
    Views
    1,460

    Hi, in this blog it shows an example for a...

    Hi,

    in this blog it shows an example for a calculated member http://www.nicholasgoodman.com/bt/blog/2006/06/08/mondrian-power-of-olapmdx-at-your-fingertips/ (starting step 10)

    Sorry I don't...
  29. Table Output - Postgres using Batch wrong commit size

    Hi,

    I have a table output to save 10000 rows to a table. One column is a timestamp with the default value LOCALTIMESTAMP, my commit size is 1000.
    When I select the data after the insert and group...
  30. Replies
    5
    Views
    1,460

    Hi, have you ever tried to set up 2 dimensions...

    Hi,

    have you ever tried to set up 2 dimensions - rooms and bathrooms? You could then select rooms and bathrooms and try to add a calculated member for "Others" (All minus everything you want to...
  31. Replies
    3
    Views
    4,729

    I tried not using enclosures during the write and...

    I tried not using enclosures during the write and also during the read of the CSV files and it works . But isn't it possible that a delimiter could be in a field?
  32. Replies
    3
    Views
    4,729

    Problem with CSV files and enclosures

    Hi,

    I have a transformation that create a delta file for 2 text files and writes the delta into a table. The text files are generated in a previous step where I force to have enclosures (is that...
  33. Replies
    2
    Views
    1,590

    Hi Christoph, there are many different clients...

    Hi Christoph,

    there are many different clients available, you can search on Sourceforge for xmla : http://sourceforge.net/search/?type_of_search=soft&words=xmla and it will show you quiet a few....
  34. Hi diddy, thanks for your feedback. Both tools...

    Hi diddy,

    thanks for your feedback. Both tools don't implement all OLAP features yet but the development team is working hard on it. I have been following your blog for a bit by the way :-)
    ...
  35. Small HowTo - Creating a Star Schema for Mondrian

    Hi,

    I created a small HowTo on creating Star Schemas for Mondrian. It is for users who know already about Mondrian, Cubes, etc but have problems creating schemas.

    Here are the links, comments...
  36. Replies
    20
    Views
    19,093

    3.2.1

    Hi,

    is there any way to download 3.2.1 / 3.2.2 without downloading the source first?

    Thanks,
    Benjamin
  37. Hi, you have to disable lazy conversion for...

    Hi,

    you have to disable lazy conversion for your input.
  38. I finally got to try the bulk loader for...

    I finally got to try the bulk loader for Postgres. It took me a little bit to figure it out but now it works. On my local machine it was over 4x faster than the normal table input step (read a text...
  39. Replies
    1
    Views
    1,275

    Hi, I'm running into the same problem. I...

    Hi,

    I'm running into the same problem. I create a Schema and one Level contains a CaptionColumn which works fine. But I need to display the value of 2 different columns so I tried the...
  40. Replies
    10
    Views
    11,852

    Yes thats true, but it is only optional. You can...

    Yes thats true, but it is only optional. You can create a query just drag&drop and a few clicks for joins, conditions etc.
  41. Hi Matt, thanks for your answer. The more I...

    Hi Matt,

    thanks for your answer. The more I work with Postgres, the more I "love" it.
    Is it a big difference in performance to not have the batch insert mode?

    Benjamin
  42. Batch insert mode disabled because of database limitations on Postgres

    Hi,

    I'm building an ETL transformation with Kettle 3.2 against a Postgres database (8.2 / 8.3) In my table output steps I have the option "Use batch update for inserts" activated but whenever I...
  43. Replies
    10
    Views
    11,852

    Hi Yannick, thank you for your feedback. ...

    Hi Yannick,

    thank you for your feedback.
    What do you think makes it hard for non-IT guys to work with Wabit? We want to make our tool as easy to use for business users with no or little IT...
  44. Replies
    10
    Views
    11,852

    New Wabit release

    Hi Yannick,

    as mentioned earlier, the newest release from this weekend (version 0.97) now supports Mondrian and XML/A. You can either use the built-in Mondrian server or connect to a XML/A server....
  45. I found a solution after looking trough different...

    I found a solution after looking trough different examples, I have to use <MeasureExpression>
  46. MDX: How to sum up depend on a another value

    Hi, I have the following fact table:

    date|customer|amount|var
    2009-01-02|1|10|0
    2009-01-02|2|12|1
    2009-01-02|3|42|1
    2009-01-02|4|11|0

    I have 2 calculated members, one should sum up the...
  47. Replies
    29
    Views
    10,757

    Hi Tom, the hint (right click) was helpful for...

    Hi Tom,

    the hint (right click) was helpful for me too ;)
  48. Replies
    29
    Views
    10,757

    Hi Tom, so far I don't have any further plans...

    Hi Tom,

    so far I don't have any further plans with it. I just gave it a quick try, uploading a schema, using a xmla source (from Pentaho BI Server) and thats it. I could see the cubes and add...
  49. Replies
    29
    Views
    10,757

    Hi, the PAT standalone version wouldn't run...

    Hi,

    the PAT standalone version wouldn't run again this time (on my Vista machine). This time I spent more time on the problem and it works if you change one value in the file...
  50. Hi Frank, did you try to write the same xquery...

    Hi Frank,

    did you try to write the same xquery twice for the part where you get only a 1? In the result you'll have something like admin=1, admin_1 = <real_value>.
Results 1 to 50 of 168
Page 1 of 4 1 2 3 4
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.