Tag Archives: MDX

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

3 Cardinal Rules of Sustainable TM1 Development

Never use Names or Descriptions as Elements. This is because change is inevitable, one day that account name will change, and with how TM1 stores data against elements the chances are that a new account will be added with the new name and your data will change paths, starting in the old account name and swapping into the new account from its addition date forward. The alternative is to store … Continue Reading

This entry was posted in IBM Cognos TM1 and tagged IBM Cognos TM1, MDX, Measures Dimension, Scenario Dimension, TI Process, TM1, TM1Tutorials. Bookmark the permalink. | Tagged IBM Cognos TM1, MDX, Measures Dimension, Scenario Dimension, TI Process, TM1, TM1Tutorials | 1 Comment

TM1 Perspectives (for Excel) Report Methods

Here is another minor extract from TM1 Tutorials.com training material. We talk through the common sustainable reporting methodologies within TM1 Perspectives for Microsoft Excel. These being: Static/Standard Reporting Active Form Reports Filter Reporting MDX Reporting VUSLICE Reporting This isn’t an exhaustive list, but we believe these are reporting styles TM1 Consultants should at the very lease know of. The common methodologies for reporting from TM1 Servers within Microsoft Excel: Name Description Usage … Continue Reading

This entry was posted in IBM Cognos TM1 and tagged Active Form, dynamic reporting, ELCOMP, IBM Cognos TM1, MDX, MDX Report, SUBNM, TM1 Reference Guide, TM1 Server, TM1RebuildCurrentSheet, VUSLICE. Bookmark the permalink. | Tagged Active Form, dynamic reporting, ELCOMP, IBM Cognos TM1, MDX, MDX Report, SUBNM, TM1 Reference Guide, TM1 Server, TM1RebuildCurrentSheet, VUSLICE | 4 Comments

MDX Primer Tutorial

Hi Here’s a  link to my preferred MDX source on the web: www.bihints.com Wim Gielis

This entry was posted in Cognos Express, IBM Cognos TM1 and tagged BIHints, MDX. Bookmark the permalink. | Tagged BIHints, MDX | Leave a comment