OBIEE 12c: RSUM/RSUM Calculation may Return Incorrect Results (Doc ID 2337194.1)

Last updated on AUGUST 31, 2021

Applies to:

Goal

You are trying to get the result of RSUM/RSUM calculation by checking on [Display as Running Sum] from Edit View -> Layout -> Measures -> More Options... .

For example, using Sample Sales Lite, you add next six columns to Criteria tab, and check on [Display as Running Sum] for the last three columns via Edit View.
---------
"Base Facts"."Target Revenue"
"Base Facts"."Target Revenue"
"Base Facts"."Revenue"/"Base Facts"."Target Revenue"

"Base Facts"."Target Revenue"
"Base Facts"."Target Revenue"
"Base Facts"."Revenue"/"Base Facts"."Target Revenue"
---------

While trying to display the Results tab, there are three rows as detail and one row as [Grand Total].

The last column value should be displayed as
111.3%
110.6%
111.1%
111.1%

However the results displayed as just like next capture.
111.3%
221.4%
333.3%
111.1%

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.