If you are unable to create a new account, please email support@bspsoftware.com

 

Dynamically choose a dimension based on prompt selection

Started by Pstone, 09 Mar 2017 06:34:26 PM

Previous topic - Next topic

Pstone

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..

TomCognos

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.