My Oracle Support Banner

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

Last updated on DECEMBER 17, 2017

Applies to:

Business Intelligence Suite Enterprise Edition - Version 12.2.1.2.0 and later
Information in this document applies to any platform.

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

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


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