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
The topics covered include:
- Creating different versions of budget information. It has been decided that a Versions dimension is needed. It will have members like Budget Version 1, Budget Version 2. People may wish to add other members later. In addition, you will need to create a dimension to store unit sales information for price vs. cost analysis. There is no source data supplied for these dimensions so they will be created manually.
- Creating a time dimension called Months displaying MMM YYYY at the lowest level rolling up to QQ YYYY and YYYY at the highest level. It should be based on a calendar year and include January 1, 2012 to December 31, 2013. You will create a new time dimension and use the Time Dimension tool to build the specifics and hierarchy.
- Building a Product dimension containing the individual products at the lowest level and roll up to the Product Line. The Product line will roll up to a Total of Product element for a grand total. Rather than type all the product names and manually arrange the hierarchy use the import function to read the file and import the data to the dimension.