Traditional web-based reporting with SAS BI tools

Using prompt values from OLAP data in text object

Reply
Contributor
Posts: 53

Using prompt values from OLAP data in text object

I have a report that uses an information map based on an OLAP cube. I have created filters and prompts for certain values in the information map. I want to create 'breadcrumbs' on the report to show the user's selections by using a text object instead of 'Applied Filters'. However, when I insert the prompt value this is how it is displayed:

[TIME].[TERM].[All Terms].[Spring 2012] [FUNDING].[Total] Section Size Report

Campus Location(s): [LOCATION].[All Campus Locations]

College/Department(s): [GROUP].[Total].[CBA].[ACCOUNTING]

What I want to display is:

Spring 2012 Total Section Size Report

Campus Location(s): All Campus Locations

College/Department(s): ACCOUNTING

Is this possible in WRS? Thanks!

Ask a Question
Discussion stats
  • 0 replies
  • 236 views
  • 0 likes
  • 1 in conversation