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

 

using category codes as display values when using a cube in Report Studio

Started by damzI, 16 Nov 2016 09:49:45 AM

Previous topic - Next topic

damzI

Hi All,
So I have this column that toggles on the levels of a dimension based on a Prompt selection.

eg Region, State, City levels

So that column is being populated using the prompt for that selection. And so automatically picks up the caption value. How can I use the category code instead on the caption ? Is there a function to pick the category code - like we have to pick the 'caption' ?

Thanks, D