Reporting

Asymmetrical Views in Planning Analytics Workspace

Unlock the power of asymmetrical views in Planning Analytics Workspace (PAW) and transform your reporting! While traditional views offer symmetry, asymmetrical views allow you to tailor your data presentation, showcasing only the most relevant information for decision-making. Discover how to build these views using point-and-click methods or MDX code, and explore practical use cases like phased reporting and budget comparisons. Dive into this guide to elevate your analytics game and provide your users with precisely the data they need, enhancing clarity and insight in your planning processes. Don’t miss out on this opportunity to innovate your reporting!

Read More »
TM1 content personalisation
Planning Analytics Workspace
Max Haynes

Personalise the PAW User Experience

Enhance the Planning Analytics Workspace user experience by personalising it to remember previous selections. Learn how to create a User Parameters cube for a customised experience.

Read More »
Reporting
Max Haynes

Universal Report Ranges

The hidden rows of a Universal Report reveal a vast amount of text and named ranges. It can be overwhelming, but if you take the time to understand the purpose

Read More »
Reporting
Max Haynes

Universal Reports Prerequisites

A Universal Report is a new type of dynamic report that is hierarchy aware. It utilises TM1SET formulas and named ranges to achieve this. The Prerequisites vary depending on your

Read More »
Reporting
Gautam Narula

How to Calculate SUMIF in TM1

IBM does not provide a native function to calculate SUMIF in TM1. How do I calculate SUMIF in TM1 and perform a sum of values based on a user input?

Read More »
Excel Functions
Rehmat Walia

TM1USER TM1 Excel Syntax and Use

TM1User function, when used in Planning Analytics for Excel, returns the user logged in the current server. TM1USER SYNTAX The syntax is as following: Where: Example and Usage To provide

Read More »
Excel Functions
Rehmat Walia

DBSW TM1 Excel Syntax and Use

The DBSW function in TM1 sends a numeric value to a TM1 cube.  Syntax The syntax for using DBSW function is: Where: The arguments e1 through en are sequence sensitive,

Read More »
Excel Functions
Rehmat Walia

DBS TM1 Excel Syntax and Use

DBS is an Excel based function, used to send numeric values to a TM1 cube’s cell. Example To illustrate the usage of DBS, let’s consider a Sales Analysis cube with

Read More »

Log In