How To Perform Auto Calculation Based On Grouped Members In A Financial Reporting (FR) Report
(Doc ID 2747344.1)
Last updated on JULY 27, 2022
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 |