Budgeting Planning & Forecasting Archives – Page 8 of 12 – Revelwood Knowledge Center
Budgeting Planning & Forecasting Archives – Page 8 of 12 – Revelwood Knowledge Center

Did you know that you don’t have to show all of your dimensions during an ad-hoc query in IBM Planning Analytics Workspace (PAW)? TM1 cube views and formulas require a reference to every dimension within the cube. While all of these dimensions have a use within your cube, they are not always needed for your reports, templates and ad-hoc querying. PAW books allow you to hide dimensions during ad-hoc browses. This is done by simply dragging the dimension off the … Read More

This is a guest blog post from Revelwood’s Shane Bethea. Did you know that the IBM Planning Analytics for Excel (PAx) Set Editor has a new, simplified way of selecting dimension elements for a view? As of PAx version 2.0.34, this can be done with a new feature called ‘Replace and Close’. This new feature is available in the newer report types in PAx (Explorations and Quick Reports), as well as in the PAx cube viewer. The following Exploration view … Read More

Did you know that you can bookmark items for quick navigation in IBM Planning Analytics Workspace (PAW)? PAW’s navigation menu allows you to scroll through your entire system which includes cubes, dimensions, views and other aspects of your model. This ability to access your models within a single list is very powerful, but it can also become very large. PAW offers an easy way to quickly navigate to important components of your model that via the use of bookmarks. To … Read More

Did you know IBM Planning Analytics can minimize the amount of feeder data via an approach called a “conditional feeder?”  A conditional feeder is exactly what it sounds like – it only feeds when a certain condition is met. In a previous blog post, I provided an example of how to use an attribute to turn on/off data flow from another cube.  We left off with the following rules: High-Level:   Detailed:   The cube “High-Level” should only pull from … Read More

Did you know that element attributes in TM1 and IBM Planning Analytics can be used for more than just making report aliases? They can be utilized by the system itself to better manage data flow, and to make it easier to trace where your data is coming from without having to use calculation tracer so often. Let’s imagine that we have 2 cubes – detailed and high-level. The detailed cube has the same dimensionality as the high-level cube, but it … Read More

Did you know feeding based on string values can be tricky?  Anyone that has developed in TM1/IBM Planning Analytics before knows full well the importance of a well-written feeder statement. An example of this is when we have a cube with string measures that are dimensions in another cube.  The pull side is quite simple:   The issue, however, is how Planning Analytics registers feeders: Numeric feeders only trigger once…  during the first time the string in the cube “Input” … Read More


« First‹ Previous789Next ›Last »

Never miss another post.

Sign Up for Our Newsletter.