To support the analysis of Facts by dates other than base dimension that plays different role in the context of Fact, role playing dimension has been created. For example, Payable Invoice Fact has Invoice date, Invoice Distribution Accounting Date, and SLA Distribution Accounting Date as dimensions.
To analyze by Invoice date, Fiscal Calendar Time Dimension is used. However, to analyze by either Invoice Distribution Accounting Date or SLA Distribution Accounting Date, the following role-playing dimensions are used, respectively.
AP Accounting Date
GL Accounting Date
The role-playing dimensions follow a standard naming convention to end with the base dimensions Name.
For example, Dim-GL Accounting Date Fiscal Calendar is a role-playing dimension of the base dimension Dim-Date Fiscal Calendar Dimension.
Note: | For instructions on setting role playing segment dimensions for accounting segments based on both trees and value sets, see the detailed instructions "Oracle Fusion Financials OTBI - Accounting Role Playing Dimensions Setup" on My Oracle Support. |