N Level-MDX for Leaf Level Elements from an Ancestor in TM1
Use MDX to return JUST the children of a parent element in TM1. Simple explanation with worked example. THis MDX can then be used to export just those elements.
Children-MDX for Next Level Only of TM1 Element
Use MDX to return JUST the children of a parent element in TM1. Simple explanation with worked example. THis MDX can then be used to export just those elements.
How To Create the Top 10 Basic Reports Using MDX Expression
Here is a fully worked example of using MDX in a TM1 Dynamic Report to create a Top 10 style report. It includes the dynamic subset, view, dynamic report and MDX.
3 Cardinal Rules of Sustainable TM1 Development
We sometimes get asked what are the three most important things to remember in TM1 development to make a TM1 model work well in the long term. Well, here is our take on what you need to do to make your TM1 models sustainable. Never use Names or Descriptions as Elements. This is because change […]
TM1 Perspectives Excel-based 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: Perspectives Reports This isn’t an exhaustive list, but we believe these are reporting styles TM1 Consultants should at the very least know of when doing Excel reporting with Perspectives.The common methodologies […]