COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Framework Manager => Topic started by: Greg on 05 Jul 2013 03:18:07 PM

Title: How do I change the caption of the root member in a DMR model?
Post by: Greg on 05 Jul 2013 03:18:07 PM
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.
Title: Re: How do I change the caption of the root member in a DMR model?
Post by: blom0344 on 09 Jul 2013 07:42:55 AM
Add a _memberCaption for the root level of the hierarchy in the dimension definition that uses the proper data-item
Title: Re: How do I change the caption of the root member in a DMR model?
Post by: Greg on 09 Jul 2013 11:59:35 AM
I'm not following you.  There is no data item in the root level of a DMR dimension.
Title: Re: How do I change the caption of the root member in a DMR model?
Post by: blom0344 on 09 Jul 2013 02:57:57 PM
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..
Title: Re: How do I change the caption of the root member in a DMR model?
Post by: Greg on 09 Jul 2013 03:16:59 PM
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.
Title: Re: How do I change the caption of the root member in a DMR model?
Post by: MMcBride on 11 Jul 2013 02:01:45 PM
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.