Alex Needham, Author at Revelwood Knowledge Center
Alex Needham, Author at Revelwood Knowledge Center

IBM Planning Analytics Tips & Tricks Series Did you know there are some easy approaches to troubleshooting IBM Planning Analytics for Excel (PAx)? Given that PAx is an Excel add-in, sometimes things go wrong. Do you know the basic steps to take when a user says that PAx isn’t working for them? We at Revelwood have often seen two primary issues that appear at our clients: The “IBM Planning Analytics” ribbon doesn’t show up A user can connect in, but … Read More

Did you know IBM Planning Analytics has a new function called “Default Members?” This is different from default subsets. Default members are what is used if you were to simply drag a dimension into a Planning Analytics for Excel (PAx) sheet or a Planning Analytics Workspace (PAW) book. Below is what it looks like when dragged into PAx: The default members isn’t as simple as saving a subset, however. It is maintained in a Planning Analytics control cube called “}HierarchyProperties.” … 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

Did you know you can customize IBM Planning Analytics Workspace directory installation? It’s getting more and more common to have a small C:\ drive for booting and then having a separate drive to store data. This approach makes it easier to have a backup work only with the relevant drive(s). The Docker installation for Planning Analytics Workspace on Windows Server 2016 installs files to the C:\ directory without giving users the option to change the directory. Even if the PAW … Read More