IBM Cognos 8 Report Studio Cookbook

RoleValue() function

This recipe will show you a useful function which you will often need while working with dimensional and dimensionally-modeled-relational models.

As the purpose of this recipe is only to examine this function, we won't consider any specific business case here.

Getting ready

Create a new list type of report based on the same GO Sales SSAS Cube package.

How to do it...

1. From Insertable Objects, locate Organization Code2.
   
2. Drag it on the list as a new column.
3. Now add a new data item to the list. Define it as: roleValue('_businessKey',[Organization Code2]).
4. Add two more data items and define them as follows:

   roleValue('_memberCaption',[Organization ...