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...
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.
How it works...
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...
