1. Administering Tax Reporting
  2. Working with Dimensions
  3. Dimensions Overview
  4. Data Source

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 - The target for CbCR automation
      • FCCS_Managed Data - Data loaded via Data Management
      • FCCS_Data Input - Data that is entered manually, or imported via data import
      • 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 (includes data mapped via tax automation and pre-tax adjustments)
    • 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 (Non-Hybrid mode only).

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.