Automate the creation of standard subsets in IBM Planning Analytics

Whether you are building a new model, adding objects to an existing application, or simply maintaining a Planning Analytics solution, there is opportunity to automate the creation of standard subsets. This can be done via TI process and be applied to all the Dimensions within the model. This ensures that subsets are configured consistently across…

Read More

Using Command Line to Search for Planning Analytics Objects

I have often found myself rewriting the same command line scripts to parse through the Planning Analytics data directory.  Here are a few common use cases for doing so: 1) Checking dependencies of objects a. Ex. Without opening all the chores, how can I confirm which chore runs the process “Cube – Finance – Load…

Read More

Designing Highly Customized Dashboards in IBM Planning Analytics

There are several design considerations when building dashboards, such as presenting information in a clear and concise manner, ease of navigation, and usability.  Additionally, adding customizations to match your company profile and brand will help to embed analytics within your organization and provide a seamless transition from other applications with a matching look and feel.…

Read More

Connecting Snowflake to IBM Planning Analytics (Cloud)

Snowflake is a data warehouse, and it has gained a lot of popularity in recent years. Organizations choose to store and process their data in Snowflake which is a great data platform. Most organizations also need an analytics platform to build their forecast, perform ad-hoc analysis, and create dashboards. IBM Planning Analytics (Cloud) is an…

Read More

An Allocation Model in Planning Analytics

An allocation model is commonly used in a planning and budgeting process. A simple allocation model distributes an amount, such as expenses, to different segments of a business. The segments can be cost centers, departments, sales teams, etc. An example of a simple allocation model is an IT allocation model which allocates the total IT…

Read More

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 More

Hiding 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 More

Using 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 More

Using 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 More

FEEDSTRINGS 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 More