Hitachi Vantara Pentaho Community Forums

Search Forums:

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

Search Forums: Search took 0.02 seconds.

  1. Does this solve this issue, or just a remark how...

    Does this solve this issue, or just a remark how to improve the query?
  2. Hi, I have a similar problem. Only it is for me...

    Hi, I have a similar problem. Only it is for me with the xls export :-) The default seems to do a %.2f for numeric data and I want to change that for some fields. Did you solve your issue?
    It's...
  3. yep, you are right!!! Thanks

    yep, you are right!!!
    Thanks
  4. CDE Dashboard using mdx and parameterized cube

    is it possible to use a cube name set via a parameter, like
    SELECT
    something ON COLUMNS,
    something_else ON ROWS
    FROM [{S{param_cube}}]

    I've tried it, but it is not working yet, maybe some...
  5. Which version of pentaho are you using. It looks...

    Which version of pentaho are you using. It looks like the backup functionality is added in pentaho 6?
  6. Hierarchygrant with not existent member exposes all data?

    I hope I make some error. But if I grant some role to a non existent member the user gets access to all data.
    dimension definition:

    <Dimension type="StandardDimension" visible="true"...
  7. Strangely the...

    Strangely the Dashboards.getParameterValue('param_name') doesn't work ('undefined'), but `var datasource = ${p:datasource};` does....
    It was also needed to set a datasource in the component...
  8. Thanks I'll give it another shot.

    Thanks I'll give it another shot.
  9. Datasource as parameter (or via pre-execution or...)

    I want to widgetize my dashboards to be able to use for example a stackedbarchart widget. The widget could be usefull with different (MDX) datasources. Of course you can parametrize (strange word)...
  10. Great solution, however with no data, it returns...

    Great solution, however with no data, it returns an "Error processing component", caused by this.chartDefinition.colHeaders=[]. So I think a check if data is available should be added, but how to...
  11. Replies
    7
    Views
    1,652

    If you want the fuzzy match step extended, please...

    If you want the fuzzy match step extended, please vote here (http://jira.pentaho.com/browse/PDI-13265)
  12. Replies
    7
    Views
    1,652

    in stead of javascript value step, you can also...

    in stead of javascript value step, you can also use the calculator step. Divers distance measures are available.
  13. Replies
    0
    Views
    567

    xml join with elements in sequence

    I need to create a xml file where the elements has a particular order.
    And some of the elements only needs a single element.


    <root>
    <sub1a/>
    <sub1b>


    <sub2a>Some String</sub2a>
  14. Replies
    2
    Views
    904

    see my possible solution at...

    see my possible solution at http://forums.pentaho.com/showthread.php?177254-Fuzzy-Match-design-pattern&p=394616#post394616
  15. Replies
    7
    Views
    1,652

    Possible solution: javascript value step

    rule engine step does not seem the solution (it is a filter step, not a join step).

    I've used another solution:
    *merge join the two data streams.
    *use javascript value step to calculate the...
  16. Replies
    7
    Views
    1,652

    tweets from uwe: @jaapandre...

    tweets from uwe:

    @jaapandre right now it can use regular expressions and soundex. but it's open to extend it.
    @jaapandre I had a quick look. it's not so complicated . so I could implement...
  17. Replies
    7
    Views
    1,652

    Hmmm same use case as mine (different thread,...

    Hmmm same use case as mine (different thread, sorry).... Maybe the Pentaho Business Rule Engine ETL step from Uwe Geercken is usefull. I've asked it as comment on his youtube video:...
  18. Replies
    2
    Views
    904

    Hmmm this sound like a duplicate of (sorry):...

    Hmmm this sound like a duplicate of (sorry): http://forums.pentaho.com/showthread.php?177254-Fuzzy-Match-design-pattern
  19. Replies
    2
    Views
    904

    fuzzy and exact match combined?

    I've two lists (one from mysql database), both has country code and a string field (say organisation). I want to match 'same' organisations. An organisation is the same if: country code is the same...
  20. Hi, Have you already solved this problem? I've...

    Hi,

    Have you already solved this problem? I've a similair one.
  21. Replies
    6
    Views
    1,063

    No, you don't need to reply about the 'bad query'...

    No, you don't need to reply about the 'bad query' from my previous post.

    Just for the record, when performing the etl, I added a lookup table for the iati-identifier and added a integer key in the...
  22. Replies
    6
    Views
    1,063

    hmmm i only followed your like to '=' change. Now...

    hmmm i only followed your like to '=' change. Now I'm trying the solution without the temp table, but still the join on the iati-identifier varchar is needed... It would be nice to perform a query...
  23. Replies
    6
    Views
    1,063

    I've followed your suggestion (and made sure, the...

    I've followed your suggestion (and made sure, the iati-identifier has indexes). But after two hours of running, the query is still sending data. :-( So need to find a better approach
  24. Replies
    6
    Views
    1,063

    store aggregated field in (mysql) database

    I'm importing 500k 'activities' from a round 2000 xml files in my warehouse.
    Each activity has an identifier which is a varchar(255).
    It should be unique, but it is not.
    I want to add a field...
  25. Replies
    4
    Views
    2,043

    Yesterday I tried to compile the...

    Yesterday I tried to compile the pentaho-platform, but didn't succeed, my steps in eclipse Juno on 64 bit ubuntu:
    * instal ivyDE plugin
    * clone pentaho-platform from github (automatically import...
Results 1 to 25 of 25
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

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