TM1 cubes need to be published to Cognos Connection (with Framework Manager) in order to develop Cognos BI reports from them. In the publish process you have the option to swap item names in each dimension with an attribute of the dimension (if there are any).
This is generally a good option because in TM1 cube development process you use codes in the dimensions as the item names and use actual names as attributes, aliases.
Country dimension in the example below consists of country and region codes, but the country names are defined as attributes. So in the publish process in Framework Manager, country names should be swapped instead of codes.
Country names in BI
Country names in TM1
Tags: Cognos BI, Cognos TM1, TM1 BI integration
Leave a Reply