My Oracle Support Banner

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 9.0.0.0.00 and later
Information in this document applies to any platform.

Purpose

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.

Scope

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.

Details

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
Purpose
Scope
Details

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