Integrating TM1 9.5 and Cognos BI Part 1
IBM Cognos 10 greatly improves the performance of Integrating TM1 9.5 and Cognos BI, but many clients aren’t leveraging the integration in their Cognos environment. Below are Lodestar guidelines:
You must assign a measures dimension in TM1 for the cube you will be using in BI.
- Right click on cube to publish in TM1 selecting Properties
a. In the measures dimension box, click the measures dimension
b. Assign the Time Dimension
c. TM1 Server must be running so you can connect to it as a datasource IBM Cognos TM1
a. Multiple cubes may negatively impact performance because meta data for all cubes in a package will be loaded
b. Multiple cubes in a package allow you to build a report that displays data from different cubes
c. You can’t combine data from multiple cubes into a crosstab, list or chart
a. After Adding/Removing dimensions
b. Changes to TM1 Security
c. Specify or change Level Names
a. After Adding/Removing/Moving members to a dimensions
b. Data changes
You can now read Part 2 of our Integrating TM1 9.5 and Cognos BI by clicking HERE.