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
Cognos BI on TM1-Cube -> Member Unique Name
-
- 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
Do you have an example?
-
- 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
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.
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.
- 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
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
Go Build a PC
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7