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 MoreWriting C-Level Rules
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 MoreUsing Pop-Up Text in 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 MoreCreate MDX expressions
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 to Create a Rule
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 MoreEditing Business Rules for Planning Analytics Workspace (PAW)
ETL Debugging Tool
QueBIT Webinar – New ETL Debugging Tool 091417 – quebit IBM has released a new tool to help you debug your Turbo Integrator code. This recoring will walk you through utilizing this new tool to help you with your TI code.
Read MoreWrite TM1 Rules like a pro
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