Each dimension is seeded with members to allow for flexible application configuration. Seeded members are created with the prefix
FCCS, for example,
The system also includes built-in calculations. See Built-in Calculations.
Guidelines for Seeded Members
There are specific properties that you cannot change or remove:
You cannot remove seeded members.
You cannot rename seeded members.
You cannot change the member property.
You cannot change the built-in member formula.
You can modify these properties:
You can modify the member Alias.
You can modify the Account Type for seeded members of the Account dimension to customize them as needed.
You can modify the Exchange Rate type on accounts.
Adding Children to Seeded Base Members
Within the Account, Data Source, Movement, and MultiGAAP (if used) dimensions, there are FCCS_seeded members.
If these members have a Data Storage property of Dynamic, you can add children to them.
If the Data Storage property is Store or Never Share, you cannot add children to them.
Moving Seeded Members in Dimensions
If you do not want to use all of the seeded members, then you need to create user-specific members where appropriate. If you want to create additional parents for seeded members, you can create alternate hierarchies. You can move seeded members to the new parent members.
You can reorder seeded members under a parent member. For example, this is the default order for FCCS_Operating Income with only seeded members:
If you want to add an
Other Operating Income account, you can place it between the two seeded members.
Rearranging Seeded Account Members
Financial Consolidation and Close has a seeded Balance Sheet and Income Statement structure consisting of about 60 accounts (both parents and base). It is possible to change the structure of the seeded hierarchy and add additional parent and base members to suit your requirements.
The following guidelines apply:
The member names of the seeded accounts cannot be changed, but the aliases can. An additional alias table can be added for a separate account description. Data can be loaded, viewed and searched (in a member selector) by alias as well as by member name.
Multiple alternative hierarchies can be created for differing reporting needs. These alternative hierarchies should include all base members in the primary hierarchy, but can otherwise be organized differently.
Be aware that various system and seeded calculations will be lost if the seeded account hierarchy is ignored. Many calculations have been incorporated into the system that rely on the account structure. As a minimum, the following calculations rely on, and are applied to the seeded account members:
Year-end transfer of prior period Retained Earnings Closing Balance to Retained Earnings Prior Opening Balance
Period end transfer of P&L Closing Balance to FCCS_REC OBFXCTA Opening Balance
Period end transfer of Other Comprehensive Income (Revenue / Expense) to FCCS_OR_OBFXCICTA
Balance the Balance Sheet (can be disabled)
Foreign Exchange (FX) transfer to Cumulative Translation Adjustment (CTA) or Comprehensive Income Cumulative Translation Adjustment (CICTA)
Seeded consolidation rules (can be un-deployed / disabled)
You should ensure that all base accounts are included in the seeded account structure, whether that structure is used for reporting or not.
If you know that changing the account structures of dimensions with dynamic calc parents will result in unwanted changes to the historical data, then you should not change the structures. If however, you want to change the aggregation/calculation to reflect the new hierarchies, then you should unlock the entities, reconsolidate, and re-lock. If you want history to remain as it is, but use new aggregation/calculations for future data, then you should create alternative hierarchies to provide for both variations, change their rules if necessary (to make them time-specific) and reconsolidate wherever applicable.
Watch the following tutorial for more information about modifying attributes for seeded accounts.
Restoring the Metadata Outline
When you make changes to the order of dimension members, you may need to correct the order of some members. For example, you might have moved a child member under a member that does not allow additional child members. You can restore the outline by using the Restore functionality.
To restore the Metadata outline:
- On the Home page, navigate to Application, then select Configuration.
- Click Actions, then select Review Modified Artifacts.
- Click Filter and select Dimension in the drop-down, then click Apply.
From the Dimensions drop-down list, select the dimension you want to change.
Select the member or members that you want to move.
Check the Property check box on the right for related dimension members.
Click the Restore button.
Verify that the members are moved as expected.
- Run the Database Refresh process.
Basic Required Balance Sheet Members
If you are creating an Extended Dimension application, during application creation, you can select the Basic Accounts Reporting option. This option provides a simplified hierarchy of the minimum required set of Account and Movement dimension members based on the enabled features and a minimum set of seeded forms.
Initial Required Balance Sheet Account Members
Balance Sheet Account Members with Multi-Currency Enabled
If you enable the Multi-Currency option, the system adds these currency related hierarchies.
Balance Sheet Accounts with Cumulative Translation Adjustment (CTA) Enabled
Accounts with Comprehensive Income Cumulative Translation Adjustment (CICTA) Enabled
Balance Sheet Accounts with Ratios Enabled
If you enable the Ratios option, the system adds the Ratio hierarchies and related source accounts depending on which Ratio options are selected.
Balance Sheet Accounts with Intercompany Data with Tracking and Ownership Management Enabled
If you enable the Intercompany Data with Tracking option, additional options such as Ownership Management are then available. If you enable Ownership Management, the system adds the Ownership Management accounts and adds the CTA/CICTA accounts if not already added, then adds the Driver accounts.
Basic Account Reporting - Indirect Cashflow Option
For the Basic Accounts Reporting option, if you enable the Indirect Cashflow option, the system adds the Cash Flow accounts and additional Cash Flow hierarchy.
Initial Required Movement Members
Note that two base (level 0) movements are created in addition to the Opening Balance hierarchy. You can add any additional base movements as required.
Movement Members with Multi-Currency Enabled
If you enable the Multi-Currency option, the system adds the foreign exchange related members.
Movement Members with Intercompany Data with Tracking and Ownership Management EnabledIf you enable the Intercompany Data with Tracking option, additional options such as Ownership Management are then available. Enabling Ownership Management enables the "Opening Balance Ownership Change" system rule which requires additional members (FCCS_Mvmts_Acquisitions, FCCS_Mvmts_Disposals). The enablement of Ownership Management also seeds the standard configurable consolidation rules which use FCCS_Mvmts_Acquisitions_Input and FCCS_Mvmts_Disposals_Input.
Movement Members with Indirect Cash Flow EnabledFor the Basic Accounts Reporting option, if you enable the Indirect Cashflow option, the system adds the Indirect Cash Flow hierarchies into the Closing Balance hierarchy.
Closing Balance Input Hierarchy
The seeded Closing Balance Input hierarchy enables you to load or enter Closing Balance data and compare it to the derived Closing Balance.
Closing Balance data can be loaded to the FCCS_ClosingBalance_Input member of the Movement dimension. The purpose of loading data to this Movement member is to identify any discrepancy between the aggregation of the Opening Balance plus periodic movements to the parent Closing Balance member and the required closing balance amount at entity currency. Closing Balance Input is not translated or consolidated. This member can, however, be used at a data entry level in a data entry form to compare with the aggregated Closing Balance member, and can also be used in Configurable Calculation rules to populate a default Movement member with the difference between the current and required closing balance (for example, <default movement> = Closing Balance Input - Closing Balance + <default movement). Closing Balance Input can be loaded to either FCCS_Periodic or FCCS_YTD_Input, but will ultimately be stored in FCCS_Periodic, from which any calculations should be sourced. FCCS_ClosingBalance_Input is a point in time balance member, meaning that whatever value is stored in FCCS_Periodic is the same that will be retrieved from FCCS_QTD, FCCS_HYTD and FCCS_YTD. If you need data to aggregate over time, then this Movement member should not be used.
FCCS_ClosingBalance_Variance is a parent member. The children of FCCS_ClosingBalance_Variance are FCCS_ClosingBalance_Input and FCCS_ClosingBalance(Shared).
Note that FCCS_ClosingBalance_Input is not valid to validate the system-calculated data and source data for Profit and Loss accounts.
CTA and CICTA Accounts
Cumulative Translation Adjustment (CTA )Account
By default, the system allows you to capture Foreign Exchange (FX) information in a separate CTA account for all of the historical accounts. This CTA member represents the total CTA adjustments. Calculation logic is included in the consolidation script for the re-direction of the FX from the source historical accounts to the CTA account. With one CTA account, all FX-CTA calculation results are accumulated to the single CTA account. The CTA account is part of Owner's Equity on the Balance Sheet for US-GAAP reporting purposes.
Comprehensive Income Cumulative Translation Adjustment (CICTA) Account
You can select to capture CTA adjustments in a single Comprehensive Income CTA account (CICTA) as part of the Statement for Comprehensive Income for IFRS reporting purposes. This account aggregates to the balance sheet Other Reserves account.
You may want to report historical FX adjustments in a different account and in a different section of the financial statements. This could be an account that is presented as part of the Income Statement, and aggregates to Net Income and then to Retained Earnings - Current. The seeded FCCS_CICTA account includes an optional CICTA Redirection Account setting. By default, if CICTA is the selected method, then the FX calculation from historical accounts is written to the FCCS_CICTA account. If you select a different destination account by entering this account in the CICTA Redirection Account attribute of FCCS_CICTA, then the destination for the FX to CICTA rule will be the specified account. See Setting Account Attribute Values.
During application creation, both the FCCS_CTA and FCCS_CICTA accounts are created. When you enable application features, you must specify which account to use.
Note:By default, the CTA (Balance Sheet) option is selected. If you change this option to Comprehensive Income, you must run consolidation to move the data to the CICTA account.
Foreign Exchange (FX) Calculations in Net Income Hierarchy
The seeded Net Income hierarchy in the Account dimension includes a base member named FCCS_REC OBFXCTA, Retained Earnings Current - Opening Balance - FX - CTA. It is a sibling of Net Income and a child of Retained Earnings Current.
This member is populated with the sum of the Opening Balance of the Income Statement accounts, and a single FX and single FX-to-CTA entry is made to this account based on a calculation of the values for the total Income Statement.
If you want the Income Statement FX to be transferred to CTA, then FCCS_REC OBFXCTA should be set as a Historical account. If not, then it should be set as "No Rate".
The FCCS_REC OBFXCTA account consists of Opening Balance Carry Forward (OBCF) for all level 0 accounts that are descendants of any siblings of OBFXCTA (for example, the Income Statement). The system calculates the FX Variance, but this account is a "Historical" account, so after calculating the FX Variance on the OBFXCTA account, the FX Variance is transferred to the CTA (or CICTA) account.
The system applies the Opening Balance Carry Forward to all Level 0 accounts with a time balance property of Flow, with these exceptions:
All accounts that are Level 0 of Retained Earnings Total: OB Carry Forward are re-directed to Retained Earnings Prior in the first period of the year only.
All accounts that are Level 0 of the siblings of FCCS_REC OBFXCTA: OB Carry Forward are re-directed to FCCS_REC OBFXCTA in all periods except the first period of the year.
Revenue and Expense type accounts that are Level 0 siblings or Level 0 descendants of the siblings of FCCS_OR_OBFXCTA: OB Carry Forward are re-directed to FCCS_OR_OBFXCICTA in all periods.
For FX Variance calculations (FX Opening, FX Movements), the system applies the Opening Balance Carry Forward to all Level 0 Flow type accounts, except Saved Assumption accounts which are not translated.
For CTA calculations:
Transferring FX Variance out of the individual accounts: OBCF is applied to all Historical, Historical Amount Override and Historical Rate Override accounts.
Transferring FX Variance into CTA or CICTA accounts: OBCF is applied to all Historical, Historical Amount Override and Historical Rate Override accounts within the balanced Balance Sheet hierarchy (that is, within Total Balance Sheet-Traditional, Total Balance Sheet-Net Assets or the Basic version).
Foreign Exchange (FX) Calculations in Other Comprehensive Income Hierarchy
The seeded Other Comprehensive Income hierarchy in the Account dimension includes a base member named FCCS_OR_OBFXCICTA, Other Comprehensive Income - Opening Balance - FX - CICTA. It is a sibling of Total Other Comprehensive Income and a child of Other Reserves.
This member is populated with the sum of the Opening Balance of the Other Comprehensive Income accounts, and a single FX and single FX-to-CICTA entry is made to this account based on a calculation of the values for the Total Other Comprehensive Income statement.
If you want the Income Statement FX to be transferred to CICTA, then FCCS_REC OBFXCICTA should be set as a Historical account. If not, then it should be set as "No Rate".
Setting Up Cash Flow for Negative Cash Accounts
You may want Cash accounts for negative cash items such as Bank Overdrafts, to reduce cash in the Cash Flow Statement, but include in the Liabilities section of the Balance sheet. To do this, you can modify the accounts in the FCCS_Total Non Cash section of the seeded Balance Sheet hierarchy.
Watch this video for details about setting up cash flow.