Hitachi Vantara Pentaho Community Forums

Search Forums:

Type: Posts; User: Peter Schmidt; Keyword(s):

Page 1 of 3 1 2 3

Search Forums: Search took 0.02 seconds.

  1. Replies
    7
    Views
    8,628

    I came across this blog post from a different...

    I came across this blog post from a different forum posting that may answer your question and more. :)

    http://www.prashantraju.com/2010/02/customising-the-pentaho-user-console-part-1/
  2. Replies
    7
    Views
    1,662

    Mary, Just an FYI: ...

    Mary,
    Just an FYI: http://jira.pentaho.com/browse/MONDRIAN-711
    Peter
  3. Can you post your mdx?

    Can you post your mdx?
  4. Replies
    8
    Views
    1,821

    Good to hear!

    Good to hear!
  5. Replies
    8
    Views
    1,821

    Interesting. I had taken your original...

    Interesting. I had taken your original transformation made very slight modifications to get it to run in my environment (obviously since I didn't have the pullings tables, etcetera). When I ran it,...
  6. Replies
    8
    Views
    1,821

    Francisco, On your Update pulling status step,...

    Francisco,
    On your Update pulling status step, check 'Execute for Each Row' and that should do the trick.
    Otherwise this step gets initialized from the get go.
    Peter
  7. Replies
    8
    Views
    1,821

    Francisco, How many rows are being returned in...

    Francisco,
    How many rows are being returned in your "Read Pulling Status" Table Input Step?
    If it is more than one, it is possible that one row is going down the Abort path and another row is going...
  8. The way that we solved this was to set up a JNDI...

    The way that we solved this was to set up a JNDI connection, lets say:

    dataWarehouse
    sourceDB

    Then it is just a matter of rotating out and/or configuring the appropriate...
  9. Matt, Is the intent to have a Script step that...

    Matt,
    Is the intent to have a Script step that supports JRuby in 4.0 GA, that could be used as an Input Step?
    Just wanted to confirm/deny as our main data source is a JRuby app, and being able to...
  10. Replies
    12
    Views
    1,868

    Mr Burn, Although I have not run this myself, I...

    Mr Burn,
    Although I have not run this myself, I think that this may help you tremendously
    http://wiki.pentaho.com/display/DATAMINING/Using+the+ARFF+Output+Plugin
    Peter
  11. Thanks!

    Thanks!
  12. Replies
    19
    Views
    3,583

    Kayla, Word of advice from a hiring manager. I...

    Kayla,
    Word of advice from a hiring manager. I agree with mgie wholeheartedly, download 3.5 and kick the tires before the interview.
    I was hiring for a position, and we obviously use Pentaho where...
  13. Zulu, I have this same requirement, if it is not...

    Zulu,
    I have this same requirement, if it is not too much trouble, could you post your solution xactions?
    Most appreciated,
    Peter
  14. Sticky: I will probably be re-iterating what has already...

    I will probably be re-iterating what has already been stated below. As an EE customer, it is obvious that the functionality in analyzer is presently leaps and bounds ahead of the other mondrian...
  15. Replies
    5
    Views
    6,141

    To be honest, we gave up using schema workbench...

    To be honest, we gave up using schema workbench and edit the xmls file directly.
    Can you try that, and see if you are successful?
  16. Replies
    5
    Views
    6,141

    Here is another example that is working for us: ...

    Here is another example that is working for us:

    <CalculatedMemberProperty
    name="FORMAT_STRING"
    expression="CASE WHEN [Measures].[Margin] &gt;= 0.20 THEN '|##.##%|style=green'...
  17. Replies
    2
    Views
    1,557

    If you are using mdx, take a look at the TopCount...

    If you are using mdx, take a look at the TopCount function.
  18. Replies
    4
    Views
    1,767

    Does anyone have an example of this?

    Does anyone have an example of this?
  19. Good morning, I also have the same concern. ...

    Good morning,
    I also have the same concern. When you say unpack the prpt, what command are you actually running to do that?
    Thanks,
    Peter
  20. Replies
    6
    Views
    3,024

    Steve, let me know the JIRA #, I'd like to...

    Steve, let me know the JIRA #, I'd like to watch/vote for this.
  21. Replies
    1
    Views
    1,017

    To my knowledge, for Mondrian to use aggregate...

    To my knowledge, for Mondrian to use aggregate tables, the fact_count column is required.

    Have a look at this post from the last couple days as well,...
  22. Replies
    2
    Views
    2,676

    When using an aggregate table, mondrian expects...

    When using an aggregate table, mondrian expects that there is a column called fact_count on the aggregate table. It basically contains the count of the number of records contained in the aggregate...
  23. Tom, Thanks. I think it is a great position as...

    Tom,
    Thanks. I think it is a great position as well, although, I'm a little biased :)
    Peter
  24. We still have a Senior BI Developer position open...

    We still have a Senior BI Developer position open in Chicago, contact me if you are interested.
  25. Replies
    8
    Views
    5,808

    TheFrog, I've also been experimenting with the...

    TheFrog,

    I've also been experimenting with the experimenter step and have come across the following, in case you weren't aware of them:

    http://jira.pentaho.com/browse/PDI-1901 ...
  26. Replies
    3
    Views
    1,300

    Have you tried using the Dimension Insert/Update...

    Have you tried using the Dimension Insert/Update step?
  27. What versions of are you running?

    What versions of are you running?
  28. Replies
    4
    Views
    2,132

    What is fusion chart, can you post an example?

    What is fusion chart, can you post an example?
  29. Replies
    10
    Views
    13,435

    If it helps, we've just been running the...

    If it helps, we've just been running the following at our company to see who's been doing what...

    select S.user_id, I.content_id as "xaction", count(*) as "count"
    from INSTANCES I , SESSIONS S...
  30. Replies
    9
    Views
    1,891

    Your welcome! Regarding your other question, I...

    Your welcome!

    Regarding your other question, I am sure that what you are asking is possible, but to my knowledge it isn't possible using the Dimension Insert/Update step.

    You could come back...
  31. Replies
    9
    Views
    1,891

    The column needs to be added to the table. If...

    The column needs to be added to the table. If you click on the SQL button it will give you the DML statement. In my current testing of this functionality (and we also use postgres), the column is...
  32. Replies
    9
    Views
    1,891

    Gonzalo, I am not sure how you are...

    Gonzalo,



    I am not sure how you are modeling things, but NO these columns are not added to the fact.
    They are added to the dimension for which you wish to track history.

    Peter
  33. Replies
    9
    Views
    1,891

    Gonzalo, Which version of PDI are you using? In...

    Gonzalo,
    Which version of PDI are you using? In version 3.2, there is the ability for it to track the most current version for you in the Dimension lookup/update step, then in your cube definition...
  34. Replies
    4
    Views
    8,468

    Take a look at http://demo.pentaho.com It is the...

    Take a look at http://demo.pentaho.com
    It is the latest edition.
  35. Business Intelligence Developer (Open Position)

    Looking for a candidate that is passionate about their craft, excited about open source software, loves to immerse themselves in data and is
    up to the challenge to provide solutions that increase...
  36. Chong, Would you mind posting your .ktr that...

    Chong,
    Would you mind posting your .ktr that worked?
    Thanks,
    Peter
  37. Is the postgreSQL bulk loader expecting the input...

    Is the postgreSQL bulk loader expecting the input rows to be in a certain format?
    When I tried to run this, I got the following error:

    2009/08/17 15:45:46 - PostgreSQL Bulk Loader.0 - ERROR...
  38. Replies
    1
    Views
    1,255

    This is more of an idea, that we've implemented...

    This is more of an idea, that we've implemented here, that works just fine in mondrian. I am assuming you are aggregating a daily table to a monthly table. Rather then use YYYY-MM as the key in the...
  39. Replies
    29
    Views
    11,021

    Here is what I saw: When running Pentaho...

    Here is what I saw:

    When running Pentaho Aggregation Designer, I could configure the db connection, choose a mondrian schema file, click apply and in < 4 sec, I am able to select cubes from the...
  40. Replies
    29
    Views
    11,021

    postgres 8.3.7 38 tables We don't...

    postgres 8.3.7



    38 tables



    We don't use schema workbench when editing the mondrian schema file. We've found it is faster by hand and then you are also not limited to only the...
  41. Replies
    6
    Views
    5,157

    If you are an enterprise edition customer, you...

    If you are an enterprise edition customer, you can set up a schedule in the enterprise console.

    We schedule the run of the clear_mondrian_schema_cache.xaction that sits under...
  42. Replies
    29
    Views
    11,021

    Tom, Thanks for the quick replies. ...

    Tom,
    Thanks for the quick replies.





    Just an FYI, we don't have any aggr tables in the schema file.

    Peter
  43. Replies
    29
    Views
    11,021

    Just some quick feedback off the top off my head...

    Just some quick feedback off the top off my head then....

    a. when I upload my mondrian schema and then connect, it takes awhile (30 sec) until I get available cubes
    b. when I drag two dimensions...
  44. Replies
    29
    Views
    11,021

    Thanks, the right-click did the trick. You are...

    Thanks, the right-click did the trick.
    You are right not very intuitive.
  45. Replies
    29
    Views
    11,021

    Perhaps I didn't use the right connection then, ...

    Perhaps I didn't use the right connection then,
    I first uploaded my modrian schema and then used the following:
    jdbc: postgresql://localhost:5432/dw_development
    Was this not correct?
    Thanks, ...
  46. Replies
    29
    Views
    11,021

    I tried running PAT, was able to connect to my...

    I tried running PAT, was able to connect to my test db using our current olap schema, but when I added a dimension and a fact, it never displayed any data. Any ideas?
  47. Replies
    15
    Views
    4,991

    This may just be personal preference. We have a...

    This may just be personal preference. We have a small team as well. I started out using the repository, but once we started getting serious and using source control, I found that it was easier to...
  48. Replies
    2
    Views
    1,329

    Mick, If you are in a job, there is a folder...

    Mick,
    If you are in a job, there is a folder called File Transfer that contains the step you are looking for.
    Peter
  49. Replies
    3
    Views
    1,179

    ...

    <Dimension name="Calendar" type="TimeDimension">
    <Hierarchy hasAll="true" allMemberName="All Calendar Dates" primaryKey="date_dim_key">
    <Table name="date_dim" alias="calendar_date_dim"/>...
  50. Replies
    8
    Views
    3,456

    Good meeting, quite informative, looking forward...

    Good meeting, quite informative, looking forward to more on other areas of the product suite.
Results 1 to 50 of 101
Page 1 of 3 1 2 3
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

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