Need to know essentials for Planning Analytics

Feb 21. 20192 min read
Scott Wiltshire

Our colleagues from Cubewise CODE have done some great work producing not just 1 but 3, “cheat sheets” which are super densely packed with knowledge. Each sheet is separately targeted at End Users, Developers or Administrators. The sheets have some handy color-coding so you can easily distinguish what should be basic knowledge, advanced knowledge, or “extra reading” for each group. Of course no matter how dense, there’s only so much information that can be packed into a single page. So the sheets are also chock full of useful hyperlinks to primary sources (just click on the “info” icons.)

You can check out the cheat sheets in their original glory and download a copy for yourself from the original post at the CODE website. Print these sheets out and stick them above your desk! Or keep an electronic copy handy for a one-stop resource to access everything you need to know via the dozens of useful hyperlinks!

For End Users

Lots of useful information on PAx versus Perspectives report types, explanation of key TM1 Excel formulas, data spreading shortcuts, tips on trouble-shooting, and of course lots of handy links.

For Developers

About as much information as possible to squeeze onto one page covering rule syntax, MDX, performance tips, security, cube optimization, avoiding locking, feeders and lots more general troubleshooting.

For System Administrators

The best one page reference you will find anywhere with essential information for anyone involved in TM1 DevOps.

Tagged , ,


  • Ian BoltzJanuary 28, 2019 How to reference intersections of hierarchies in rules This is a follow on from the previous article on working with hierarchies in rules. It will deal with how to address the intersection of two (or more) hierarchies in the right hand side of […]
  • Bryan WanJuly 31, 2018 What is the Cubewise EDU TM1 and Planning Analytics Developer Credential? Written by Ben Heinl With growing interest, I keep getting asked “what exactly is the ‘Cubewise EDU TM1 and Planning Analytics Developer Credential’”? The Credential was developed in […]
  • Francisco SantosApril 29, 2016 Anti-virus scanning software and TM1 Or have you ever sought to mitigate or prevent virus-scanner related performance issues by ordering scanning exceptions only to have your windows admin or security team scoff at you and […]