Properly Setting Up Formula Definitions in Financial Reporting--Avoiding Cross-Axis References
(Doc ID 1103717.1)
Last updated on AUGUST 31, 2021
Applies to:Hyperion BI+ - Version 188.8.131.52.00 and later
Information in this document applies to any platform.
This article is intended to provide some information on setting up formulas in Financial Reporting. Specifically, formulas that reference other rows and columns should be defined so as to avoid the use of cross-axis references. A cross-axis reference occurs when a formula row includes a general column reference (or vice-versa - when a formula column includes a general row reference) as opposed to a specific cell reference.
A reference such as [B] refers to an entire column of a report -- Column B. If a formula is defined such that it refers to [B], then the entire column is being addressed, instead of an individual cell within Column B (e.g., [B,3]). This can lead to undesired and/or erroneous results.
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