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.
roleValue('_businessKey',[Organization Code2])
.roleValue('_memberCaption',[Organization Code2]) roleValue('_memberUniqueName',[Organization Code2])
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 and Member/Set.
In case of MSAS cube, we can't define custom attributes in FM. However, we can still use this function to access intrinsic roles: _businessKey
, _memberCaption
, _memberDescription
, _memberUniqueName
. In this recipe, we checked some of these intrinsic roles.