COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: damzI on 16 Nov 2016 09:49:45 AM

Title: using category codes as display values when using a cube in Report Studio
Post by: damzI on 16 Nov 2016 09:49:45 AM
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