-
Book Overview & Buying
-
Table Of Contents
IBM Cognos 8 Report Studio Cookbook
By :
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.
Create a new list type of report based on the same GO Sales SSAS Cube package.
From Insertable Objects, locate Organization Code2.

Drag it on the list as a new column.
Now add a new data item to the list. Define it as: roleValue('_businessKey',[Organization Code2]).

Add two more data items and define them as follows:
roleValue('_memberCaption',[Organization Code2])
roleValue('_memberUniqueName',[Organization Code2])Run the report to test it.

When defining a DMR (Dimensionally Modeled Relational) model in Framework Manager, the modeler can define various columns as attributes. This roleValue() function allows you to access these attributes.
This function takes two arguments: Role...
Change the font size
Change margin width
Change background colour