Financial Consolidation and Close Supported Dimensions

Financial Consolidation and Close uses a pre-defined dimensional model. You can add custom dimensions to meet your consolidation and reporting requirements. Below are the Financial Consolidation and Close dimensions and their data requirements.

Note:

In addition to the system predefined dimensions, you can create up to four additional Custom dimensions based on your application needs. Custom dimensions are associated with the Account dimension and provide additional detail for accounts. If the application is enabled with the Multi-GAAP reporting option, you can create three Custom dimensions.

Dimension	Member
Year	All members in the Year dimension The Year member is prefixed with " FY." For example, the Year member 2016 shows as "FY16."
Period	Only base members
View	The View dimension controls the representation of data across time periods. Valid views are "YTD" or "PTD." For periodic data, the member "FCCS_Periodic" is used, and for YTD, "FCCS_YTD_Input" is used.
Currency	Shows the members available under the reporting currency parent using the parent member "Input Currency."
Consolidation	The Consolidation dimension enables the users to report on the details used to perform the various stages of the consolidation process. Members are associated with "FCCS_Entity Input."
Scenario	Scenario contains the following members: Actual Budget (optional) Forecast
Entity	All base members
Intercompany	"FCCS_No Intercompany" or ICP_<ENTITY>. If there is no intercompany value, "FCCS_No Intercompany" is used. Otherwise for an intercompany member, the ICP_<ENTITY> format is used.
Account	All base members
Movement	No Movement All base members under FCCS_Mvmts_Subtotal including: FCCS_No Movement FCCS_No Movement FCCS_Movements FCCS_OpeningBalance FCCS_ClosingBalance
Data Source	FCCS_Managed Data
Multi GAAP	All base members including: IFRS (system) Local GAAP (system) IFRS Adjustments (system) The default is " FCCS_Local GAAP. "
Custom1	All base members that are a valid intersection for the account. This dimension is based on the domain of the custom dimension. If no member, use "No_<Dimension Name>."
Custom2	All base members that are a valid intersection for the account. This dimension is based on the domain of the custom dimension. If no member, use "No_<Dimension Name>."
Custom3	All base members that are a valid intersection for the account. This dimension is based on the domain of the custom dimension. If no member, use" No_<Dimension Name>".
Custom4	All base members that are a valid intersection for the account. This dimension is based on the domain of the custom dimension. If no member, use "No_<Dimension Name>".