Hitachi Vantara Pentaho Community Forums

Search Forums:

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

Page 1 of 2 1 2

Search Forums: Search took 0.02 seconds.

  1. Hello, you could use the Rule Engine step...

    Hello,

    you could use the Rule Engine step (JaRE, available in the marketplace) to define your rules externally to your transformation. So if the rules change, you won't have to change your code.
    ...
  2. Replies
    1
    Views
    837

    Plugin Help button

    Hi everyone,

    I have developed a plugin step for PDI - (Rule Engine plugin).

    The plugins in PDI have a Help button. This points to the Pentaho wiki with documentation on the plugins. But the...
  3. Replies
    0
    Views
    504

    Groovy script and user id

    hello,

    I have a few groovy scripts, that I use inside the BI Server. That works fine. But now I need to be able to find out which user is logged in and make decisions based on that.

    Would...
  4. Replies
    1
    Views
    565

    I was not explicit enough. I do get a list of...

    I was not explicit enough. I do get a list of steps. But when I then try to get a list of previous fields, I get the exception. Obviously it is because the parameter in the sql is not being replaced...
  5. Replies
    1
    Views
    565

    PDI API and Parameters

    I have a simple transformation which reads a database table. The where clause has a parameter like:

    ... where id > ${parameter1}


    Now I have a Java program that uses this transformation. I do...
  6. ah. ok. disregard my input then. rgds, uwe

    ah. ok. disregard my input then.

    rgds,

    uwe
  7. Replies
    2
    Views
    585

    drag a message field on the report where you want...

    drag a message field on the report where you want to display the info and fill in something like:

    City: $(param_city)

    where "param_city" is the name of your parameter.

    uwe
  8. hello pdi friends, btw: I have meanwhile...

    hello pdi friends,

    btw: I have meanwhile create a web application to write the rules for the rule engine and to group them together. one may also define actions which do something based on the...
  9. Replies
    0
    Views
    606

    Report Designer Template

    hello,

    I have looked online for examples and tutorials about how to create report templates, but all I find is info about creating reports as such.

    I have created a template and published it to...
  10. Replies
    11
    Views
    1,378

    hello PDI friends, I will have a look at the...

    hello PDI friends,

    I will have a look at the requests in the next days.

    Just to be clear: I do not want to interfere with the PDI developers nor do I want to modify existing steps. I just...
  11. Pra Deep, do you have the "lock output format"...

    Pra Deep,

    do you have the "lock output format" set to "on"? I think I had the same problem too - quite a while ago.

    rgds,

    uwe
  12. Replies
    11
    Views
    1,378

    thanks for the reply Mick. Do you have a good...

    thanks for the reply Mick. Do you have a good link for me explaining UK postcodes? If not, I will have a look myself. Or maybe you can send me a few samples? What is "Postcode Formatted"?

    I assume...
  13. Replies
    11
    Views
    1,378

    Missing Steps

    hello PDI friends,

    I would like to strengthen my skills and work on creating more PDI steps - at least I will try. this helps me learn and at the same time creates something for the community.
    ...
  14. we had a similar issue. it turned out, that it...

    we had a similar issue. it turned out, that it was a connection problem: the BI server needed the fully qualified hostname (xxx.testcompany.com) and not only the hostname of the database (in this...
  15. in the BI server you can link pages. we have...

    in the BI server you can link pages. we have created a mechanism where a page from a different server is displayed with the job name and the parameters it requires and the user can then run it from...
  16. I have written my own engine already a while ago....

    I have written my own engine already a while ago. it is lightweight and works very well. it is called Jare - Java Rule Engine.
  17. Sadakar, of course it all depends on how much...

    Sadakar,

    of course it all depends on how much data you have. but for the beginning you could do it like this:

    - use pentaho PDI to read the excel file and output the data to a database -...
  18. Replies
    2
    Views
    798

    Bertignac, JUnit is Java so yes, you can...

    Bertignac,

    JUnit is Java so yes, you can integrate it with PDI. if you put the required jar files in the lib folder, then PDI will pick them up.

    Then, you can either write a UDJC in spoon or...
  19. Replies
    8
    Views
    1,495

    one more thing maybe: I have also implemented...

    one more thing maybe:

    I have also implemented a socket server, running the rule engine. you could run it on a server. I have also done some tests running it in docker containers.

    you send the...
  20. Replies
    8
    Views
    1,495

    Walter, I have written a ruleengine in Java...

    Walter,

    I have written a ruleengine in Java and a step for PDI, which allows you to check data or even update data based on rules. rules can be combined to complex scenarios. there is also a web...
  21. Ruleengine Step: Keep your logic outside the transformations

    hello pentaho users,

    a while ago, I created a plugin step for PDI, so that one can run rules against the data. the advantage is that one does not have to hardcode the logic in the transformation....
  22. Replies
    0
    Views
    8,315

    Ruleengine step

    hello everybody,

    some time ago I implemented a ruleengine step to be able to check the data against rules defined in external files. This helps to keep the logic out of the transformations.

    The...
  23. Replies
    1
    Views
    1,366

    There is a csvjdbc driver I read about recently....

    There is a csvjdbc driver I read about recently. Or you could try to use the MySQL load Data infile Syntax but of course that is Used Outsider kettle. You could Split your file in multiple logical...
  24. Replies
    9
    Views
    2,097

    If somebody Interessed, i have cremtest a rule...

    If somebody Interessed, i have cremtest a rule Engine step which can be Used to Run Transformations ägainst external rules in XML Files.

    Its in Marktplace

    Uwe
  25. I had somerhing similar. I found Out that ist was...

    I had somerhing similar. I found Out that ist was a Slow query causing this behavior. So I changed the query to make better use of Indexes and that was the Solution.

    The error is misleading. Spent...
  26. plugin step: multiple step copies problem

    I have written a plugin step for PDI. it runs well, but when I add a second copy of the same step to the transformation, then some of the output fields of the step are not correctly propagated.
    ...
  27. hello, I have extensively tested the rule...

    hello,

    I have extensively tested the rule engine plug step now. it works well but is not yet optimal:
    - as I have a one-to-many relationship of rows and rules, I can end up with many, many...
  28. Replies
    1
    Views
    1,165

    Palo in PDI 5.0 EE

    I am trying to get the Palo Plugins in Pentaho Data Integration (PDI) 5.0 EE running. I get a connection to the Palo server and get a list of cubes and dimensions, but I can't get the data....
  29. I thought I would find some more people to do...

    I thought I would find some more people to do some testing. but anyway.

    Lal: if you find some time, please go ahead and download the zip file from

    http://datamelt.com/downloads_en.html

    it...
  30. normally you would call ant likethis: ant...

    normally you would call ant likethis:

    ant -DtempFilename=<fillename> -DoutputFilename=<filename> -f <ant file>

    you should be able to do that with a shell command. or you could use uuser defined...
  31. here is the link for anybody interested: ...

    here is the link for anybody interested:

    http://datamelt.com/downloads_en.html

    the download is available on that page. o directly from:
    ...
  32. oh that was quick... thanks for participating. ...

    oh that was quick... thanks for participating.

    uwe
  33. PDI Plugin Step: Business Rule Engine - testing

    hello everybody,

    I am looking for people who want to test a step I have programmed for PDI.

    I sometimes need to test data against given rules, to check if the data is correct and consistent. In...
  34. Replies
    1
    Views
    1,764

    hello, yes. you should organize your date...

    hello,

    yes. you should organize your date data, so that it is split into year, month, day, week of year, weekday, day of year,... what ever you need. then you will be able to efficiently use these...
  35. Replies
    8
    Views
    1,004

    you could maybe filter/fork the rows based on a...

    you could maybe filter/fork the rows based on a counter and then write to the same file but different sheets. but I have not tested that.

    but the newer versions of PDI allow you to write an xlsx...
  36. Replies
    3
    Views
    1,007

    thank you for your reply. but the question was in...

    thank you for your reply. but the question was in the direction of developing steps for PDI. I need to know how I convert the values programmatically.

    greetings,

    uwe
  37. Replies
    3
    Views
    1,007

    PDI Step development: lazy conversion

    doing some tests with the step I developed, I found out, that if e.g. the input comes from a csv input step and "lazy conversion" is enabled, then the values of the single fields don't come out...
  38. hi, for every job we run we have a little...

    hi,

    for every job we run we have a little shell script. inside this script there is a call to run kitchen.

    in this script we do some preparation work; e.g. calculate the current date, set some...
  39. PDI Step development: input from two different steps

    hello everyone,

    I continue to enhance the step I have written, which implements a rule engine to check data. But then of course a lot of questions come up...

    some steps allow the input from two...
  40. Thanks Matt. But I maybe did not express myself...

    Thanks Matt. But I maybe did not express myself correctly: When a user defines a parameter for running the job, then I would like to pick it up in my step - of course not the parameter, but the real...
  41. Plugin step: getting transformation parameters

    hi everybody,

    I managed to write my first plugin for PDI, which is for a business rule engine - this way you can do complex validations based on external rule files (xml).

    to complete the...
  42. Replies
    1
    Views
    898

    ok. I found the solution - sometimes a good night...

    ok. I found the solution - sometimes a good night sleep changes everything...

    now I am capturing the size of the input row and then updating the outputrow accordingly:

    outputRow[inputSize] =...
  43. Replies
    1
    Views
    898

    Plugin: processRow question

    Hello,

    I have started learning a bit how to write a plugin. so far I have understood the basics.

    My problem is the following: In the plugin metadata class I have added two fields A (long) and B...
  44. Replies
    4
    Views
    1,116

    I went ahead and did it this way: I prepared the...

    I went ahead and did it this way: I prepared the BI server to allow the processing of groovy scripts. for the user it looks like any report in the bi server. so the user selects this page. it allows...
  45. Replies
    1
    Views
    1,582

    Shashank, I think your question is not clear...

    Shashank,

    I think your question is not clear enough. Are you saying that you use java to execute reports and now you look for a way to do it via php?

    rgds,

    uwe
  46. Replies
    4
    Views
    1,116

    running jobs on user request

    hello everybody,

    I have the situation that we have have an etl that needs to run on user request. meaning when the user is ready there needs to be a way to extract the latest data. as I don't know...
  47. Replies
    0
    Views
    830

    User personal folder

    hello,

    we had the idea of creating a "Personal folder" for the users, so they have a single location to store their files and we have have an easy way to find out how many personal reports or...
  48. Replies
    2
    Views
    1,093

    Biserver and symlinks

    hello,

    we had the idea to store all our pentaho related files in a specific location and then use symlinks in the pentaho-solutions folder to link to them.

    does naybody know if there are any...
  49. Replies
    3
    Views
    1,148

    I have one problem though. the layout is more...

    I have one problem though. the layout is more difficult. actually I have 4 subreports, two on top - one left one right, two below them - one left one right. now the problem is, that when doing a...
  50. Replies
    3
    Views
    1,148

    difficult report layout

    I would need some help and advice for the following problem.

    we have a department that needs a report. but the final output must be excel, because users need to manually add information in the...
Results 1 to 50 of 82
Page 1 of 2 1 2
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

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