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

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

Did you know you can create a temporary VIEW or SUBSET Turbo Integrator function in IBM Planning Analytics? Here’s why you may need to, and how to do so. IBM has gone to great lengths to ensure that the transition to Planning Analytics is a seamless process and has added some new functionality to help make your system more efficient. Two commonly used TurboIntegrator (TI) functions are SUBSETCREATE and VIEWCREATE.  These processes are used to create a new component in … Read More

I started my career in the automotive industry. I started off as an intern and worked my way up to FP&A coordinator / assistant manager over five years. During this time, I realized how much time our Financial team wasted on horrifically inefficient planning and reporting processes. I knew there had to be a better reporting solution than nesting IF/VLOOKUP statements and a better planning solution than spending weeks rebuilding dozens of Excel workbooks every year. Luckily, I was selected … Read More

Never miss another post.

Sign Up for Our Newsletter.