IBM
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 MoreUsing 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 MoreDesigning 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 MoreConnecting 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 MoreAn 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 MoreUsing 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 More