Hitachi Vantara Pentaho Community Forums

Search Forums:

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

Page 1 of 6 1 2 3 4

Search Forums: Search took 0.03 seconds.

  1. cda compund queries does not preserve orginal sort

    Hi,
    I have two mdx queries in cda and try to join them in a compound query. I expect that the left side join column sorting is preserved in the compound. Instead, a new alphabetical order for the...
  2. As a possible workaround I have extended the...

    As a possible workaround I have extended the chart object with a custom option in postfetch where I store the values that will be later dropped by the dataWhere filter.

    Then I rewrite the tooltip...
  3. prevent data from drawing but showing them in tooltip

    Hi,
    I have a cda resultset in crosstab format, kind of CAT | MEA1 | MEA2 | MEA3 and trying to draw a heatgrid.
    I would like to use one of these measures as an additional info in the tooltip,...
  4. How to avoid error in case of not existing member

    Hi,
    I'm facing this error

    mondrian.olap.MondrianException: Mondrian Error:MDX object '<membername>' not found in cube '<MyCube>'

    Actually it is a dimension member that does not exist but for...
  5. Replying to myself for whoever may need the same...

    Replying to myself for whoever may need the same info: you should edit the marketplace.site property in data-integration/system/karaf/etc/pentaho.marketplace.di.cfg file, and have it points to your...
  6. how to test a marketplace entry for a step plugin

    Hi,
    in the markeplace-metadata project is indicated a way to test a step plugin entry before submitting a pull request to marketplace. Apparently it doesn't work anymore from pdi version 6.0, and I...
  7. Error in lambda expressions when developing plugins (javassist)

    Hi,
    I came across this issue during a step plugin development: the version of javassist currently distributed with pdi seems not fully compliant with java8. In fact it cannot parse the symbol used...
  8. Replies
    0
    Views
    400

    Named parameters and UnknowParamException

    Hi,
    when a client consumes the API to execute a job with parameters, it must deal with an UnknowParamException. However looking at the only implementation of NamedParams interface, the ...
  9. Replies
    2
    Views
    599

    Hi, hard to say from here. It could be either an...

    Hi,
    hard to say from here. It could be either an issue with sorting or with network latency if your data are not local.
    Just as general advice, set an higher value for size in sort rows step. Also...
  10. Replies
    9
    Views
    1,308

    Hi, couple of options: 1) use a variable in a...

    Hi,
    couple of options:
    1) use a variable in a bash (or batch if windows) script that call the kitchen launcher
    2) write a wrapper java class that run the job via api

    Here a trivial example...
  11. Replies
    2
    Views
    2,379

    Hi, yes it is possible, but I would find quite...

    Hi,
    yes it is possible, but I would find quite repetitive writing 5 transformations with hard-coded parameter values. You would probably benefit from pdi ability to execute "something" for each...
  12. Hi, Use a filter rows to split the stream on...

    Hi,
    Use a filter rows to split the stream on qty >0 and then use two "set field value to a constant" on the true and false hops coming from the filter step.

    HTH
  13. Replies
    1
    Views
    441

    Hi, I see you are comfortable with regex. Then...

    Hi,
    I see you are comfortable with regex. Then try the Regex Evaluation step and enable capture groups. For instance, the following

    ^ownerdetails__apm(za001)_2015-05.csv$ applied to...
  14. Replies
    4
    Views
    642

    String comparison should work fine using equals()...

    String comparison should work fine using equals() method.
    I think your issue is related with type mismatch: your datetime_pg is supposed to be a String in order to host a "val_null" value. As a...
  15. Replies
    4
    Views
    840

    What about using a cartesian join...

    What about using a cartesian join step? You can feed it with all the different field you need using multiple datagrid steps.
    For low-cardinality dummy attributes this would be suitable, I think.
    ...
  16. Replies
    3
    Views
    1,369

    Thanks for your reply. Yes, I already saw your...

    Thanks for your reply.
    Yes, I already saw your message in the mailing list and hoped that in the meanwhile the issue were addressed.

    At the end, I fix at etl level with kind of workaround you...
  17. Replies
    3
    Views
    1,369

    Coarser granularity measure in mondrian 4

    Hi,
    I have two fact tables with different granularity. According to Mondrian in Action book, this scenario in Mondrian 4 can be dealt with using different measure groups, linking fact tables to the...
  18. Replies
    1
    Views
    1,028

    BA 5.2 - building issue: missing dependencies

    Hi,
    I'm trying to build the BA from source, as always did with previous versions.

    I have checkout the git repository at 5.2.0.0-R tag. Project revision build property is set at 5.2.0.0-209, the...
  19. Thread: Pentaho in Italia

    by Ato
    Replies
    54
    Views
    48,362

    Sales: http://www.pentaho.com/contact ...

    Sales: http://www.pentaho.com/contact

    Contatori downloads da sourceforge : http://sourceforge.net/projects/pentaho/files/?source=navbar (clicca sul numero di downloads e nella pagina successiva...
  20. Thread: Pentaho in Italia

    by Ato
    Replies
    54
    Views
    48,362

    Ciao Andrea, come detto in altro post ti...

    Ciao Andrea,
    come detto in altro post ti conviene interpellare il Sales per avere un'idea dei prezzi e anche dei possibili bundles. E' in ogni caso assai probabile che le varie componenti siano...
  21. Thread: Pentaho in Italia

    by Ato
    Replies
    54
    Views
    48,362

    Va bene

    Va bene
  22. Thread: Pentaho in Italia

    by Ato
    Replies
    54
    Views
    48,362

    Si, sono interessato. Proviamo a organizzare uno...

    Si, sono interessato. Proviamo a organizzare uno scambio di idee via chat (irc, skype, hangout o quello che preferisci).

    Io venerdì mattina 1/8 ho possibilità, altrimenti dimmi tu.

    Skype:...
  23. Thread: Pentaho in Italia

    by Ato
    Replies
    54
    Views
    48,362

    Ciao Bruno, so che in passato sono stati fatti...

    Ciao Bruno,
    so che in passato sono stati fatti tentativi infruttuosi, ma io la trovo una buona idea. Tu hai in mente uno spazio web? Oppure un canale irc dedicato (o entrambi, magari)?
  24. Thread: Pentaho in Italia

    by Ato
    Replies
    54
    Views
    48,362

    Ciao Andrea, per quanto riguarda i prezzi, ti...

    Ciao Andrea,

    per quanto riguarda i prezzi, ti consiglio di contattare il loro Sales. Ricordo, un paio di anni fa, qualcosa come 10k $/anno per il server (ma prendila davvero con le molle)....
  25. Hi, kettle has a logging architecture based on a...

    Hi,
    kettle has a logging architecture based on a central store and different channels for jobs/trans you are executing. You can easily attach an appender and retrieve the buffer you need.
    Btw,...
  26. Replies
    5
    Views
    1,853

    You cannot say in advance I think. It depends on...

    You cannot say in advance I think. It depends on some other factors. For instance if you sort in the db on an indexed column (and we should also consider what type of index you have) generally...
  27. Replies
    2
    Views
    3,202

    Looking at the source, I'm afraid you can't...

    Looking at the source, I'm afraid you can't passing a variable as a command line argument to pan, but consider that Pan.bat is just a wrapper around the class org.pentaho.di.pan.Pan. Probably, it...
  28. Sort step does not filter any row, so it is not...

    Sort step does not filter any row, so it is not eating in your stream. I see from your message that you are sorting after the merge step. Probably this comes from your business logic, but be aware...
  29. Do all the files have the same metadata...

    Do all the files have the same metadata structure, i.e. same fields in the same order?
  30. Thread: CSV custom parser

    by Ato
    Replies
    7
    Views
    1,348

    Not clear for me. What is the desidered output?

    Not clear for me. What is the desidered output?
  31. Using CE 5.0.1 stable, here. The feature is not...

    Using CE 5.0.1 stable, here. The feature is not implemented. It must be only for EE.
  32. Hi, the log you posted does not show issues with...

    Hi,
    the log you posted does not show issues with the browser. You should open the dev console in chrome and see what happens there (ctrl+shift+i).

    Anyway the issue may be related to some...
  33. Simply put both field in a sort row before...

    Simply put both field in a sort row before entering the merge one. The stream will be sorted by the first field, and then by the second. Also consider having the stream already sorted before kettle...
  34. It seems a problem of sort order. Would you mind...

    It seems a problem of sort order. Would you mind doubling check both the type and the order of the two streams entering the merge step?
  35. Replies
    8
    Views
    864

    Well, accessing excel files is not a problem: you...

    Well, accessing excel files is not a problem: you have steps able to connect and extract data (excel input, csv input).

    For the word file, docx files have an xml core you can access. I am...
  36. Replies
    5
    Views
    909

    Hard to help, without knowing what you are doing...

    Hard to help, without knowing what you are doing in your transformation.
    Anyway, you may want to give a look ar the Dimension lookup/update step. It can handle key generation.
  37. Replies
    9
    Views
    1,642

    The Put SFTP entry...

    The Put SFTP entry allows you to get files (and file names) from previous result. Is it bad for you?
  38. Replies
    6
    Views
    1,550

    What about using Carte...

    What about using Carte on the Windows machine? Within a job you may have a final transformation that runs on a slave server.
  39. Use a group by step, You will find a "Concatenate...

    Use a group by step, You will find a "Concatenate strings separated by ," in the aggregate type column.
    Probably you can easily get the same result at database level. Mysql, for instance, has a...
  40. Replies
    1
    Views
    1,934

    I suggest using the Microsoft access input step...

    I suggest using the Microsoft access input step and pass the mdb file to it, instead of setting the connection via odbc-jdbc bridge using the Ms Access db connection. This one is probably failing...
  41. Replies
    6
    Views
    1,580

    Well, there are a number of options: submit a...

    Well, there are a number of options:

    submit a jira with a feature request. In the end, the project grows thanks to our feedback.
    rewrite your solution avoiding splitting the stream: if you need...
  42. Replies
    6
    Views
    1,580

    This is not a big gap in functionality. This is a...

    This is not a big gap in functionality. This is a big boost on performance because it comes from the multithreading nature of pdi. You can easily work around this problem (apart from reorganize your...
  43. Replies
    3
    Views
    622

    Use either Row flattener or Row denormalizer....

    Use either Row flattener or Row denormalizer. They are under transformation folder in Spoon design tab)
  44. Replies
    7
    Views
    805

    I think your transformation runs near the memory...

    I think your transformation runs near the memory ceiling most of time. Add a few overhead (a parent job's objects) and you hit the heap limit.

    First, tune your logic. For instance, you would...
  45. Replies
    7
    Views
    805

    I would argue about setting a deeper logging at a...

    I would argue about setting a deeper logging at a parent job level. Usually, things may go wrong in a transformation (db connection unavailable, any kind of business logic bugs, etc.), so you should...
  46. Replies
    3
    Views
    1,247

    From the stack you posted I think you did not...

    From the stack you posted I think you did not trigger the SubFolder step.
    Your transformation probably starts from the constant step. This step does not generate any rows; it only adds fields to...
  47. Replies
    7
    Views
    805

    Too few info. Basically the stuff that eats...

    Too few info.

    Basically the stuff that eats memory happens at transformation level, though a parent job adds to overhead. Try and set a minimal logging level for the parent job execution and see...
  48. Replies
    6
    Views
    875

    Null if, as per marabu's hint, works fine....

    Null if, as per marabu's hint, works fine. Alternatively, the right regex pattern is simply ^\+31$.

    This one matches exactly '+31', i.e. there must be no trailing spaces for the match to be...
  49. Replies
    3
    Views
    884

    No, you don't need metadata injection for this. A...

    No, you don't need metadata injection for this. A set variable job entry is enough.

    Create a job, drop the set variable entry, pass a property file to it (or add variables directly in the bottom...
  50. Darrell is right. To get your output from that...

    Darrell is right. To get your output from that input you just need a "concat field" step followed by a "split field to rows" step. Maybe you can elaborate a bit more.
Results 1 to 50 of 272
Page 1 of 6 1 2 3 4
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

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