My Oracle Support Banner

How To Perform Auto Calculation Based On Grouped Members In A Financial Reporting (FR) Report (Doc ID 2747344.1)

Last updated on JANUARY 29, 2021

Applies to:

Oracle Planning and Budgeting Cloud Service - Version 18.01.42 to 21.01.28 [Release 18.0 to 21.0]
Hyperion BI+ - Version 11.1.2.1.000 to 11.2.3.0.000 [Release 11.1 to 11.2]
Oracle Financial Consolidation and Close Cloud Service - Version 18.01.42 to 21.01.28 [Release 18.0 to 21.0]
Information in this document applies to any platform.

Goal

A report, for example, has the following advance member selection functions for dimensions Department and Account in a single row.

The report needs to display auto calculation for group members under Department. For example, an auto calculation (sub total) for members grouped under Department 100, 200, 300, etc as shown below.

Example output:

101          25

102          30

Sub total   55

201          30

202          30

Sub total   60

301          10

302          09

Sub total  19 

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!


In this Document
Goal
Solution


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