PDA

View Full Version : How to pass parameters and make drill down reports



Anna90
03-26-2015, 07:55 AM
Hello all,

I made a transformation in Kettle and I am supposed to use it in report designer. I have three important fields: Location, User, Avg_Time.
I loaded ktr file and made a chart that shows average time per site. I am supposed to show a new report after clicking on a bar for a Location that shows users for that location and their avg_time.
i managed to do everything about data, that is fine, but I cant figure out how to pass parameter for Location to pdi transformation and from main report to detailed report. I only found that the parameters are passed as variables in where clause and that looks ok, but I am using ktr file as a data source, not sql query.
Is anyone able to give me exact steps to do this?

Thank you in advance!