TM1 Tutorials.com

Posts Tagged ‘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 […]

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 […]

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 […]