Cognos: Running Totals on multi-dimensional data sources

Some functions are hidden by report studio dependant on the data source that is being used (relational or multi-dimensional).

An example is the function ‘running-total’. This function does not display when building reports from cubes (see below).

Cognos: Running Totals on multi-dimensional data sources | qmx_admin

 

It is not necessary to do a complicated work-around to perform a running total on cubes.

The function can still be used by simply typing the function name into the data item expression window.

Cognos: Running Totals on multi-dimensional data sources | qmx_admin

 

The function still validates and performs as expected to achieve the desired result.

Cognos: Running Totals on multi-dimensional data sources | qmx_admin

 

Related Articles

QMetrix is ISO/IEC 27001 certified: Information Security Management System

QMetrix is pleased to announce we are now ISO/IEC 27001 certified, demonstrating our commitment to information and data security. Highlighted by various data breaches in recent times, cyber threats and criminal activities are on the rise. It is paramount for organisations to uphold high security standards and manage cyber-risks even before they occur in order

QMetrix is named 2024 APJ Workday Adaptive Planning Partner of the Year

QMetrix is named Winner of the 2024 Adaptive Planning Partner of the Year Award – APJ at the annual Workday Sales Kickoff. QMetrix announced it was named a winner of the 2024 Adaptive Planning Partner  of the Year Award – APJ by Workday, Inc. (NASDAQ: WDAY), a leading provider of solutions to help organisations manage

Stay in touch

Get the latest insights from QMetrix straight in you inbox.

Scroll to Top

This website uses cookies to ensure you get the best experience on our website. More Information

Skip to content