Cognos: Using the “Solve Order” feature in Report Studio

When performing calculations in a cross-tab, sometimes Cognos Report Studio will not calculate correctly when an intersection in a cross-tab contains a value that is derived from multiple calculations.

A classic example of this is an aggregation of Gross Margin %, which is calculated as Gross Margin/Revenue. The aggregation of this calculation in a cross-tab simply adds each of the individual Gross Margin %’s for each row to get a total Gross Margin %. Clearly this is the incorrect result.

Solve Order 1

We want report studio to calculate the GM% after totalling the Revenue and GM columns. Defining the Solve Order on the Cross Tab Node Member allows us to calculate the GM% correctly. The Solve Order is defined via the properties pane after selecting the Cross Tab Node Member (see below)

Solve Order 2

By default, the Solve Order is set to NULL for both column and row items.
In the case of NULL, or when both have the same value, the column items are calculated first, and row items second. This is the current behaviour of our report and the current settings are returning the wrong value for total GM%.

The data item with the highest solver order is calculated last. Therefore, in order to get GM% to calculate correctly, we need to edit the solve order for the ‘GM%’ Cross Tab Node Member (Column) to be higher than the ‘Total’ Cross Tab Node Member (Row). In this case, we change the ‘GM%’ solve order to 1, and leave the ‘Total’ as NULL.

Solve Order 3

This will provide the desired result when running the report.

Solve Order 4

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