Hello Everyone,
I'd like to set up a report parameter selection widget or popup report to not have the list views hardcoded on the report. But I would like to have it dinamic, so that only those parameters are coming up that apply for the selected report.
I solved this with a hyperblock on the parameters with a value filter on a matrix cube, that matches the parameters with the report.
But I thought using a Lookup object in the hyperblock to call the Select Element action, it is much nicer that just having the action in the cell.
The problem is that on the Lookup object the Global List is a hardcoded selection, whereas I would need it dynamic, depending on the parameters listed in the hyperblock.
At the moment after expending the hb, each Lookup object shows the same list (for example: each is on the company dimension, I would need them to show company, year, period etc.)
Any idea how to make it dynamic?
Thanks, Zsolt