IBM
How Can I create an Exploration view in Planning Analytics for Excel (PAx)?
How Can I create an Exploration view in PAx (IBM Planning Analytics)? An Exploration View shows data in rows and columns. An Exploration View also has a context area, which you can use to filter the data in the Exploration View. You create an exploration view by clicking the Exploration icon: …
Read MoreHow can I create a Quick Report in Planning Analytics for Excel?
A Quick Report shows data in rows and columns. A context area above the Quick Report shows the context members. You can create a Quick Report from an IBM Cognos TM1 Exploration View after you finish your analysis and want to present data by using more advanced cell-based features from Microsoft Excel. When you convert…
Read MoreHow Do I Write C-Level Rules in IBM Planning Analytics to Control Consolidation Behavior?
TM1 is great at consolidating data, but what if you want to prevent that from happening? Consider the following example, where we have FTE data for an employee at the Month level that is being incorrectly consolidated at the Quarter level. We can use business rules to pull the last month in the quarter…
Read MoreHow Do I Add Pop-Up Text to Text, Shapes, or Images in Planning Analytics Workspace (PAW)?
Using Pop-Up Text in PAW Space can sometimes be at a premium in Planning Analytics Workspace (PAW) dashboards and reports and using Pop-Up Text is a great way to preserve valuable real estate while still being able to provide users with any additional information or instructions needed to make your user interface as intuitive and…
Read MoreHow Do I Create MDX Expressions in IBM Planning Analytics to Customize Queries and Reports?
How to create MDX expressions According to the dimension and your business need, dimensions may be large. You may want to limit the data shown in the report or input schedule. You can create customized categories or subsets of dimensions for your report or input schedule. Customized subsets are utilized to speed the selection of…
Read MoreUsing Targeted selections (PAW)
How Do I Create a Business Rule in IBM Planning Analytics to Perform Custom Calculations?
IBM Planning Analytics’ Calculation Types IBM Planning Analytics is well known for the speed with which it performs on-the-fly, on-demand aggregations, consolidations and other calculations. The calculation of a specific number in a Planning Analytics cube is not performed until it is requested, for example by a DBR() formula in a spreadsheet, and when it…
Read MoreHow Do I Edit Business Rules in IBM Planning Analytics Workspace (PAW)?
What Is the ETL Debugging Tool in IBM Planning Analytics and How Do I Use It to Fix Data Load Issues?
QueBIT Webinar – New ETL Debugging Tool 091417 – quebit IBM has released a new tool to help you debug your Turbo Integrator code. This recording will walk you through utilizing this new tool to help you with your TI code.
Read MoreHow Do I Write TM1 Rules Like a Pro in IBM Planning Analytics to Improve Calculation Logic and Performance?
QueBIT Webinar – Advanced Topics – Write TM1 Rules like a Pro! If you’re a TM1 user, you know rules are how you work business logic into your model. You probably calculate things like salaries and sales, and you may even have more complex calculations in your model such as exchange rates and allocations. Since…
Read More