Using TM1 Aliases in Cognos BI

Often we build a TM1 dimension using codes or ID’s from another system.  For example Product ID’s or Customer Codes.  These are not particularly usable to most people, so we then usually create Aliases in TM1 as well.  Those aliases are visible through in Cognos BI.  Therefore when defining a dimension in TM1 when it is likely that it will be used in Cognos BI, also add an alias with a concatenation of the ID or Code with the description or name.

If you like this post, please spread the love…

About John

Managing Director of Infocube. We are a management accounting consultancy that specialises in Business Analytics.

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.