Hi,
I am trying to create a report where the dimensions are dynamically chosen in the prompt page. E.g. you have a drop down with selections of Time, Product, Organisation.
I have sort of been able to do this, only i loose the ability to drill-down in the dimension as would be possible if i used the dimension directly. DMR model of course.
Any thoughts on how to do this?
P..
I vaguely remember doing this.
I had the actual [dimA].[dimA]->?prompt? in the static choices as the use value. Then in the show value i had the name of the dim. I had three dims. So three tree prompts and 1 value prompt with three entries.
In the query the data item had the ?promptMain1? and was dragged into the slicer. The other two were throughout the query.
I did this to achieve a crosstab with a dim1 on the x-axis, dim2 on the y-axis and dim3 as context. Though I needed to give the user the ability to run the report and select which of the three dims they wanted on each of the axis's and context. This way the user could run one report and see any combination of the three dims at any level within the tree. Was pretty cool.
Rather than having 3 reports.
Though the caveat being this was at least 6-7 years ago. So the memory is fading. But yes its possible.