Cognos BI on TM1-Cube -> Member Unique Name

Post Reply
Toto
Posts: 71
Joined: Mon Jul 20, 2009 8:52 am
OLAP Product: TM1
Version: 9.5 Build 9.5.00100.2380
Excel Version: 2003

Cognos BI on TM1-Cube -> Member Unique Name

Post by Toto »

Hello,

we are testing Cognos TM1 10 and Cognos BI 10.1.
We have a TM1 Cube and try to report on this cube. In Cognos BI a Member Unique Name identifies a member. Sometimes the Member Unique Name has a "^" in it, although the element in TM1 does not have it in the element name.

Do you have an idea why and when this "^" is appended to the MUN?

Thanks a lot,

Toto
sander
Posts: 52
Joined: Thu Dec 09, 2010 9:23 pm
OLAP Product: tm1
Version: 10.2
Excel Version: 2013

Re: Cognos BI on TM1-Cube -> Member Unique Name

Post by sander »

Do you have an example?
abhikiwi
Posts: 2
Joined: Wed May 11, 2011 4:04 pm
OLAP Product: SSAS 2005
Version: TM1 9.5.1
Excel Version: Excel 2003

Re: Cognos BI on TM1-Cube -> Member Unique Name

Post by abhikiwi »

Cognos will add parent name with a cap character (^) before the element name in MUN, if same element is present elsewhere in the same dimension i.e. in alternate hiearchy.
For example, we you have one hiearchy as WORLD > EMEA > London and alternative hiearchy in same dimension as GLOBAL > Europe > London, then if you pull London on report, Cognos will add either EMEA or Europe in the MUN to resolve.
User avatar
jim wood
Site Admin
Posts: 3961
Joined: Wed May 14, 2008 1:51 pm
OLAP Product: TM1
Version: PA 2.0.7
Excel Version: Office 365
Location: 37 East 18th Street New York
Contact:

Re: Cognos BI on TM1-Cube -> Member Unique Name

Post by jim wood »

You TM1 version 10, which one? 10.1 or 10.2?
Struggling through the quagmire of life to reach the other side of who knows where.
Go Build a PC
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
Post Reply