Calculation Contexts – A Scenario Walkthrough
A Webi report basically contains the business data as dimensions and their associated measures.
For eg : A report could display Quantity sold(measure) in a Year(dimension).
Basically, Measures depend on the combination of other rows or columns with which it is associated in a report.
They change dynamically based on the contexts they are placed. We can change these default context by using
calculation contexts and thereby control a measure.
Calculation contexts can be leveraged extensively to display the exact data with help of the aggregate functions
along with context operators.
A Scenario Walkthrough:
In one of my projects, I faced a scenario to display the measures Cpu_Utilization and Memory_Utilisation only
for their respective Date Code in the detail levels as shown in the below Table 1.
From Table 1 we can understand that each date code has multiple hour codes which in turn has two Sbc items
under it which gives the detail values of both the measures, But in the output we don’t need to display Hour_code
and Sbc columns.
By removing both those Hour_code and Sbc columns I got the below output in an aggregated manner,
So, to attain both those measures in the detail manner with respect to date code without displaying hour_code
and Sbc columns,I have contexed the measures for each hour_code and Sbc in every date code.
=Average ([MEMORY_UTILISATION] For Each ([HOUR_CODE]; [SBC])) In ([DATE_CODE])
=Average ([CPU_UTILISATION] For Each ([HOUR_CODE]; [SBC])) In ([DATE_CODE])
Below is the desired output table achieved after using the above contexts,