Data Source
The Data Source dimension provides an audit trail for the different sources of your data. You can view data manually entered, data loaded through Data Integration, data posted from Supplemental Data Manager forms, data posted from journals, and elimination data created by business rules, such as Intercompany Eliminations.
The different types of data input are stored in the Data Source dimension. It includes journals input to provide a better audit trail when entity data is consolidated in the consolidation path. You can view the separate data input journals input in both the Proportion and Elimination members of the Consolidation dimension.
Watch this video to learn more about the Data Source dimension.
Data Source Members
By default, the system creates these Data Source members:
- FCCS_Total Data Source—A dynamic calculation member that is the parent of No Data Source, Total Input and Adjusted and Total Eliminations
- FCCS_NoDataSource—Stores system values such as currency rate, in addition to custom values
- FCCS_Total Eliminations—A dynamic calculation member that is the parent of two system created data source inputs (Intercompany Eliminations and Partner Eliminations). If you want to track other sources of data, you can manually create additional members under this parent member) to create more detailed tracking of consolidation adjustment and elimination entries.
- FCCS_Intercompany Eliminations—Stores system intercompany elimination entries
and can also be used to store data written by configurable consolidation rules.
(Optional - Only created if tracking intercompany eliminations is selected
during application creation). Stores the default intercompany eliminations to
track elimination by entity. This member also stores System Adjustments and
Eliminations (Acquisitions, Disposals, Entity Elimination Adjustments, Entity
Proportion Adjustments) for versions prior to 23.04 and in version 23.04 and
later (temporarily) when the substitution variable
EnableNewAcqDisp
is False. - FCCS_Partner Eliminations—Stores partner entries written by configurable consolidation rules. (Optional - Only created if tracking intercompany eliminations and Partner Eliminations are selected during application creation).
- FCCS_TotalInputAndAdjusted—A dynamic calculation member that is the parent of various data source inputs (Data Input, Acquisitions/Disposals, Supplemental Data, Other Data, Journal Input). If you want to track other sources of data, you can manually create additional members under this parent member.
- FCCS_Data Input—Stores all manual data entry or ASCII data load values
- FCCS_Managed Data—Stores data loaded from Data Integration
- FCCS_Other Data—Stores data loaded from other data integration tools
- FCCS_Supplemental Data—Stores all Supplemental detail data entered and posted through Supplemental Data Manager. (Optional - Only created if selected during application creation).
- FCCS_Journal Input—Stores data entered by Journal Entry. (Optional – Only created if Journal Entry is enabled during application creation)
- FCCS_EPU—Stores system-created data for the Equity Pick-up process. (Optional – Only created if Equity Pick-up is enabled during application creation
- FCCS_AcquisitionsDisposals—Stores all System Ownership Adjustments and
Eliminations (Acquisitions, Disposals, Entity Elimination Adjustments, Entity
Proportion Adjustments) when substitution variable
EnableNewAcqDisp
is set to True.Note:
The
FCCS_AcquisitionsDisposals
member is reserved for seeded calculations. You can't use this member as a destination member in Configurable Calculation (Insertion Point) rules, On Demand rules, Translation Override rules, Data Copy rules, Data Load, Journal Input, and Configurable Consolidation rules. - FCCS_SystemTypes—Parent member of FCCS_RateOverride, FCCS_AmountOverride, FCCS_PCON and FCCS_Driver Source system members used for internal calculations only
The optional members are created based on the options that you specify during application configuration. To specify input members during application creation, see Creating an Application.
Note:
The Currency dimension must be created prior to new members being added to the Data Source dimension. See Setting Up Currencies.You cannot remove any of the system-created members, or change the attributes for seeded members under FCCS_TotalInputandAdjusted.
Data Source Member Attributes
When you add new members to the Data Source dimension, two attributes are available for each level 0 member under the FCCS_TotalInputandAdjusted member. The attributes are "Source Data Type" and "Source Currency Type."
Note:
When you create a new member under FCCS_TotalInputandAdjusted, you must assign these attributes to the member.The "Source Data Type" has three valid selections:
-
Data Entry
-
Journal
-
Supplemental Data
The "Source Currency Type" is only applicable for multi-currency applications. This attribute has two valid selections:
-
Entity Currency
-
Any Input Currency (Each new member is restricted to a single input currency)
The seeded Data Source dimension members have the following attributes assigned, and cannot be modified.
Table 12-1 Data Source Seeded Dimension Member Attributes
Member | Source Data Type | Source Currency Type |
---|---|---|
FCCS_Data Input | Data Entry | Entity Currency |
FCCS_Managed Data | Data Entry | Entity Currency |
FCCS_Other Data | Data Entry | Entity Currency |
FCCS_Supplemental Data | Supplemental Data | Entity Currency |
FCCS_Journal Input | Journal | Entity Currency |
If there is no data or journal associated with the new member, then the attribute selections can be modified. However, if data has been entered anywhere to a member, or a journal has been created using a member, the attribute selections are read only. If data is cleared from the application for that member or journals are deleted, then the attributes can be modified.
Adding Data Source Parent Members
You can create additional parent members under FCCS_TotalInputandAdjusted as needed. You can add multi-level parent members, and there is no restriction on either the Source Data Type or Source Currency Type within a parent. Parent members will not have a Source Data Type or Source Currency Type assigned. They have a storage type of Dynamic Calc.
Adding Data Source Member Hierarchies
You can add Data Source member hierarchies as siblings to Total Data Source.
Note these guidelines for adding hierarchies:
-
In new hierarchies, parent-level members can only be of the type "Label" or "Dynamic Calc".
-
Base/Leaf-level members can be either "Dynamic Calc" or "Never Share".
-
You can only enter data to leaf-level "Never Share" members.
-
Leaf-level "Never Share" members that are outside of the Total Data Source hierarchy are not considered for aggregation to Total Data Source or Total Input and Adjusted. They are also not considered for Intercompany Elimination.
-
Only Translation and Movement calculations are performed on the leaf-level "Never Share" members that are outside of the Total Data Source hierarchy.
-
Dynamic-calc leaf-level members are not considered in the consolidation or reporting translation process.
-
If you create an alternate hierarchy in the Data Source dimension as a sibling to Total Data Source and use that hierarchy to load data to Balance Sheet accounts, this data will also be considered for the Opening Balance Ownership Change eliminations when an Ownership change occurs, and eliminations will be posted to the FCCS_Intercompany eliminations member in Total Data Source.