Cubewise

Tag: Rules

  • A Solution for Consolidated Forward Weeks of Cover

    This presentation explores a solution used to ascertain a Forward Weeks of Cover calculation at different consolidated levels from source planning data.

  • Cubewise EDU’s August Newsletter

    Cubewise EDU’s August Newsletter

    We are excited to bring back Horizon, the biggest knowledge sharing event dedicated to IBM PA/TM1 that comes around once every year for the community! – As we follow the sun over 24 hours, get a global perspective on the latest developments– Over a hundred live presentations where you can engage with the expert– Customer Case…

  • Advanced Rules Calculations

    Presented by Rashed Rafiq at Horizon, global user conference on IBM Planning Analytics/TM1 in 2020.

  • 7 tips to writing faster IBM TM1 and Planning Analytics rules

    7 tips to writing faster IBM TM1 and Planning Analytics rules

    One of the reasons why IBM TM1/Planning Analytics is so fast at performing complex calculations is because it gives developers many options to optimise the calculation rules.

  • 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 a rule statement and the left-hand side of a feeder statement.

  • How to work with hierarchies in rules

    This article is a little longer than normal, but we do go into quite a bit of detail with some examples of how the hierarchy syntax works in various situations. It’s step-by-step so should be not problem for anyone with an understanding of TM1 rules to follow. All code examples have extra spacing added for…

  • Resolving Circular Reference Calculation

    Resolving Circular Reference Calculation

    One of the main reasons why TM1/Planning Analytics has been so successful over the years is its calculation engine. TM1 can resolves very complex calculations over millions of cells in an instant. However, its only weakness is that it will need a little bit of help to resolve an equation with a circular reference. A circular…