Tag Archives: Excel

Creating basic Top 10 reports using MDX expression

One of the most common requests for reports is to generate a list of top 10 for a dimension based on TM1 data. This makes sense considering level of data TM1 works best with; this could cover top 10 consumers, customers or top 30 SKUs at one particular outlet or within a brand. There are several ways to achieve that within TM1, the simplest way to do this within a … Continue Reading

This entry was posted in IBM Cognos TM1, Training Material and tagged Excel, IBM Cognos TM1, MDX, Reporting. Bookmark the permalink. | Tagged Excel, IBM Cognos TM1, MDX, Reporting | 9 Comments

TM1’izing Excel Planning Workbooks

Project Methodology Primarily Applies to: Small to Mid Sized implementations of TM1 (3-8 weeks). It’s a widely established practice when scoping a TM1 project to take the legacy Planning Workbooks (where possible) for prior budgets and planning rounds to use as a starting point for company specific business logic and corporate structures. The advantages of this methodology are obvious: Unless there is a corporate initiative to change the methodology for … Continue Reading

This entry was posted in IBM Cognos TM1 and tagged Cognos TM1, Excel, IBM Cognos TM1, Implementing TM1, Statement of Work, TM1 Consultants. Bookmark the permalink. | Tagged Cognos TM1, Excel, IBM Cognos TM1, Implementing TM1, Statement of Work, TM1 Consultants | Leave a comment