Dinamic query with cde variable
Hello, I'm not English so sorry in advance for the incorrect English (google translator xD).
Well, I am new to pentaho cde and I'm doing some dashboards. My problem is I want to change the select string when selected according to filters that I have. Basically what I want is a dynamic query that can be changed to display the fields and conditions that I want.
After searching I'm trying with pdi spoon. I wonder if this is possible and how. This means that the .ktr pick a parameter that generated the cde and thus modify the query in the spoon With Any spoon component.
Anyone can help me?
Last edited by beldario; 08-01-2012 at 07:05 AM.
Nobody can help me? I've been looking for days and days, and I find nothing clear.
In the spoon it works, but when I try to pass the variable from the pentaho cde to kettle TransformFile shows nothing, as if the variable does not arrive.
Please, I need help.
I think that there are 2 different things.
First of all, if you want to create a report using Pentaho Dashboad, it's better if you post to the other forum.
Here discussion is more about PDI, which is the ETL tool.
Using PDI (Spoon) you can create variables and pass them from a transformation to another one, if they are within the same job.
You should be able to see an example in your data-integration\samples.
Or you can do a search in google and you should find few blogs where there are examples.
If everything fails, you can post your transformation/jobs here with small sample of data and see if someone has time to have a look at it.
I've already solved. I've seen that many other users have made this question and not been given solution.
I have been solved by following the steps on this page: http://www.packtpub.com/article/inte...-pentaho-suite
Im not sure if it has been fixed by modifying the settings.xml with the step "Configuring the Pentaho BI Server for running PDI jobs and transformations" or with the correctly set parameters and variables of the step "Populating with Data to CDF dashboard coming from PDI transformation "