Posts by agoddard
How do I use 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 MoreHow do I hide 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 MoreHow Do I Use Multiple Architect Sessions in IBM Planning Analytics 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 MoreHow Do I Use the Intent Bar in Planning Analytics Workspace to Filter and Refine Data Views?
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 MoreWhen and How Do I Use the FeedStrings Rule Function in IBM Planning Analytics to Feed Data Efficiently?
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 MoreHow Do I Set Up Basic Drill-Through Functionality in IBM Planning Analytics to Navigate From a Cube to a Detail Report?
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 MoreWhat Are Best Practices for Configuring and Scheduling Chores in IBM Planning Analytics?
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 Do I Use the WHILE Loop in a TurboIntegrator (TI) Process to Control Iterations in IBM Planning Analytics?
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 MoreWhat Are IBM Planning Analytics Control Objects and How Do I 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 MoreWhen and How Do I Use the DIMIX Function in IBM Planning Analytics to Mix Dimension Members?
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