Traditional web-based reporting with SAS BI tools

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

Reply
Occasional Contributor
Posts: 9

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,124

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

Occasional Contributor
Posts: 9

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: 36

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

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
  • 301 views
  • 0 likes
  • 3 in conversation