Data Source

The system stores the different types of input in the Data Source dimension, partly following the FCCS Data Source dimension, and extended with the TRCS Data Sources.

The optional members are created based on the options that you specify during application configuration. You can create additional members in the hierarchy as needed to track input, but you cannot remove any of the system-created members.
Dimension Data Source

The Data Source dimension is used to:

  • Track the source of data under FCCS_TotalData Source:
    • FCCS_Intercompany Eliminations - eliminations of data
    • FCCS_TotalInputAndAdjusted:
      • TRCS_TRCS_Mapped Data
      • FCCS_Managed Data
      • FCCS_Data Input - data that is entered manually, or loaded from the General Ledger.
      • FCCS_Supplemental Data - the detailed supplemental data that is entered using Supplemental Data Management (SDM)

    Tracking the Source Data
  • Track the nature of data:
    • Pre-Tax Input - data that is entered on a Pre-Tax Basis
    • Pre-Tax Calculation - calculated data on a Pre-Tax Basis
    • Apportioned - apportioned data
    • Tax - Data entered, and then calculated after Tax
    • Classification - Asset/Liability classification
    • TARF - Tax Account Roll Forward classification

Tracking the nature of the data

You cannot remove any View dimension members or create new members. You can edit member properties, such as Alias.

By default, the Performance Setting for the Data Source dimension is set to "Sparse". If you need to change this setting, you can alter the performance setting as outlined in Changing Performance Settings for the Data Source Dimension.

To define the Data Source Dimension:

  1. From the Home Page, select Application, then Overview, and then the Dimensions tab.
  2. Click Data Source, and then select the Edit Dimension Properties tab to set the properties.
    Select properties for Data Source dimension.
  3. Optional: Select the appropriate optional properties for your application:
    • Enter a Description for the Data Source dimension.
    • Select an Alias Table, if available.
    • Enter an Alias name for the Data Source dimension.
    • Select Two Pass Calculation.
    • Check to Apply Security.
  4. Select the type of Data Storage to be applied to the dimension:
    • Label Only
    • Never Share
    • Dynamic Calc
    • Dynamic Calc and Store
    • Store
  5. Under Display Option, select whether you want to display the Member Name or Alias in reports.
  6. Select Hierarchy Type, if available.
  7. Under Cube, select which cubes you want to use:
    • Consol
    • Rate
    • CbCR
  8. Under Custom Attributes, click Create to add a new custom attribute. Enter a name for the attribute, and select the Data Type.
  9. Click Done.