How to Find a List of Dimension Component Column in a Mapping Rules (Doc ID 577417.1)

Last updated on DECEMBER 11, 2008

Applies to:

Oracle Enterprise Performance Foundation - Version: 11.5.10.2
Information in this document applies to any platform.
FEM
PFT
Dimension Component

Goal

The following queries are useful when you want to find the dimension column for a dimension component in a mapping rule.

Explanation:
When you use Company Cost Center Org ID and Intercompany ID in a dimension component, you are not able to verify the dimension column associated with the component after you created the dimension component. Both Company_Cost_Center_Org_ID and Intercompany_ID columns share the same Company_Cost_Center_Org_ID dimension. If you create a dimension component using a Intercompany_ID, then using it to filter Company_Cost_Center_Org_ID, the dimension component will be available for selections, but you will not be able to filter the dimension correctly in a Mapping Rule.

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