Traditional web-based reporting with SAS BI tools

Create a prompt to select which measure is displayed in the columns

Reply
Occasional Contributor
Posts: 13

Create a prompt to select which measure is displayed in the columns

I am having olap cube as my data source for Report in WRS. however my report have 50 measure and i want to create a prompt which can let user select measure they want to see on report. How can I achieve this?

 

Respected Advisor
Posts: 3,156

Re: Create a prompt to select which measure is displayed in the columns

Posted in reply to mrg1212005
Occasional Contributor
Posts: 13

Re: Create a prompt to select which measure is displayed in the columns

Yhanks Haiku.  but this works for relational data source not for OLAP cube. What i am looking for is how to create variable prompt in WRS?

 

Contributor
Posts: 39

Re: Create a prompt to select which measure is displayed in the columns

Posted in reply to mrg1212005

I believe that's not possible within WRS.

 

When the source is a cube (without an informationmap) a prompt kan not be made/triggerd.

If you do have an informationmap, it's still not possible. A prompted filter is only possible for a category, not measures.

Ask a Question
Discussion stats
  • 3 replies
  • 306 views
  • 0 likes
  • 3 in conversation