OBIA 11.1.1.9.2: ROE, ROCE(Pre Interest) Doesn't Match Between Description Tab and Column Source Repository Tab in the Logical Column in the RPD (Doc ID 2079205.1)

Last updated on DECEMBER 02, 2015

Applies to:

Business Intelligence Applications Consumer - Version 11.1.1.9.2 and later
Information in this document applies to any platform.

Goal

Why is the formula for ROCE(Pre Interest) not matching with the Description tab and that of Column source tab in the Logical column in the RPD?

ROCE(Pre Interest):

General Tab Under Description formula used:

Pre-Tax Income / Total Capital Employed * 100; Total Capital Employed = Total Shareholders Funds + Long-Term Debt

Where 

Total Shareholders Funds = 

The IFNULL("Core"."Fact - Fins - GL Balance"."Preferred Stock", 0) +   IFNULL("Core"."Fact - Fins - GL Balance"."Other Equity", 0) for Total Shared Folders is missing in the Formula used for ROCE( Pre Interest) formula under Column Tab

Which formula should be considered for ROCE( Pre Interest)?

Solution

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 hundreds of Community platforms