Posts by agoddard
Using a Selector in Planning Analytics Workspace
Using a Selector in Planning Analytics Workspace A “selector” in IBM Planning Analytics Workspace (PAW) is a “widget” that lets you pick members, sets, or levels for a corresponding view of data. When a selector is synchronized with a view, what you pick (in the selector) is automatically applied to that view. For example, suppose…
Read MoreHiding Components in Planning Analytics Workspace
One of the most common mistakes when designing a report, a view or a visualization of data is to include too much information. Too much information can make it difficult for consumers to formulate “takeaways” and gain insights. IBM Planning Analytics Workspace (PAW) provides an interface rich in options for presenting your data so it’s easy…
Read MoreUsing Multiple Architect Sessions for Development and Testing
Did you know that the Planning Analytics Architect desktop client allows for multiple instances to run simultaneously? This feature can be used to greatly improve efficiency during development, testing, and even day to day use. When to use multiple architect sessions? Long running processes can lock an Architect or Perspectives session until the process finishes.…
Read MoreUsing the Intent Bar in Planning Analytics Workspace
IBM Planning Analytics Workspace (PAW) is a web-based interface for IBM Planning Analytics. It delivers an intuitive interface to the data residing in Planning Analytics (TM1), providing ways to plan, create, and analyze your content by providing features such as conditional formatting and calculations. One interesting feature available in PAW, is the ability to perform searches entered in…
Read MoreFEEDSTRINGS Rule Function – When and how to use it
You’ve created some basic rules and feeders against one of your Planning Analytics cubes and have used the SKIPCHECK and FEEDERS declarations (best practice). But what does FEEDSTRINGS do and do you need it? The FEEDSTRINGS declaration makes sure any STRING cells in a cube that need to be calculated by a rule are fed.…
Read MoreIBM Planning Analytics – Setting up Basic DRILL THROUGH Functionality
Did you know you can use Planning Analytics’ drill-through feature to access detailed data in another Planning Analytics cube or a configured relational table? This feature can allow for a user to quickly find detailed information underlying a data point which is either in the model in a more detailed cube, or not in Planning…
Read MoreBest Practices for configuring CHORES
Did you know that Planning Analytics has a build in scheduling functionality call Chores? Chores can be used in two distinct ways; you can schedule one or more TurboIntegrator processes to execute at defined intervals or you can setup a sequence of TurboIntegrator process to be execute by a user. These two concepts can be…
Read MoreHow to use the WHILE Loop in a Turbo Integrator Process
While is a Turbo Integrator (TI) function that is widely used to “loop” through data repeatedly, without wrapping multiple processes together to accomplish the same goal. Below is the syntax: Define loop iteration element WHILE ( logical expression ); Statements; loop iteration; END; Let’s illustrate it by using a simple WHILE loop example: We want…
Read MoreIBM Planning Analytics: Control Objects – what are they and how to view them
Control objects are system-generated objects in Planning Analytics that can help perform tasks such as administer security, record attributes, and record performance statistics (if performance monitor is on). These will include cubes, processes, and dimensions that are all prefixed with the symbol }. Types of Control Objects Security Control Cubes There are several security control…
Read MoreIBM Planning Analytics: DIMIX Function – When and how to use it
The DIMIX function is a helpful function that can be used in TurboIntegrator (TI) processes and TM1 rules. Simply put, the function will return the index number of an element within a dimension. If the element does not exist in the dimension, the function will return with a 0. The first argument in…
Read More