The following demo is an abstract from the IBM Cognos TM1: Design and Develop Models (V10.1) five-day training course, available in a classroom or online environment. If you would like to know more about this training course or other training courses, please visit the IBM Training Course Catalog. If your Subscription and Support agreement (S&S) is valid, you are entitled to upgrade to IBM Cognos TM1 v10.1. Not sure if your S&S agreement is valid? Contact firstname.lastname@example.org to find out. Get the most from the BA software investment and learn more about Subscription and Support options.
Here's the scenario
In the Sales_Plan cube, the Quantity has been loaded but you need the Unit Sale Price in order to calculate Gross Revenue. The Unit Sale Price exists in the Price_and_Cost cube so you will use a rule to pull that value into this cube. This way, if the price in the Price_and_Cost cube is updated, the change will automatically be reflected in the Sales_Plan cube.
In order to share the Unit Sale Price in the Price_and_Cost cube with the Sales_Plan cube using a link, you will perform three tasks.
- Task 1. Open views of the Sales_Plan and Price_and_Cost cubes.
Task 2. Create a new link.
Task 3. Review the results of the link in the views.