If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

How do I change the caption of the root member in a DMR model?

Started by Greg, 05 Jul 2013 03:18:07 PM

Previous topic - Next topic

Greg

I've changed the name of the All level to National but the root member caption is still based on the hierarchy name it seems.  I can see how to change to business key for the root member but not the caption.  I've attached a screenshot from RS showing the root member details.

blom0344

Add a _memberCaption for the root level of the hierarchy in the dimension definition that uses the proper data-item

Greg

I'm not following you.  There is no data item in the root level of a DMR dimension.

blom0344

Perhaps it's semantics, but with any hierarchy I can define one or more levels. Each level will have a _businesskey and _memberCaption defined. The key will normally be an identifier from the relational layer, the caption will be some attribute or even a logical expression (We use language variable to make the caption language sensitive)  In both cases a query item (sorry, not data item as I mentioned) is used from the relational layer as definition..

Greg

Right, but the root level has no items.  If I have a Customer hierarchy, the root level might be called Customers (All).  It has no items and it has only one member, the [all] member.  My question is how do I define the caption for this member.

MMcBride

For the (All) level there is no way to define a Caption that I am aware of...

However you can just rename it in either the Dimension Window (Probably not the right name...) by right clicking and selecting rename - or in the Hierarchy Properties box right click the (All) level and select Rename there.

How to feed a Caption to that so it is dynamic with the data like you would a member in the heirarchy - I don't think this is possible because you cannot assign any roles to this level.