Movement Dimension

The Movement dimension captures the movement details of an account. By default, the system provides the members in the Movement dimension to move data.

Caution:

Oracle recommends that you do NOT make any changes to this dimension.

The Movement dimension is used to perform the following tasks:

  • Move data:
    • Between tax schedules
    • From the Balance Sheet/Income Statement to tax accounts, such as Tax Automation.
    • Calculate opening balances, closing balances, and FX to CTA calculations
  • Store Tax Automation logic
  • Store RTA configuration

When you create an application, the Movement dimension is created by default with pre-seeded members, and optionally adds system members based on the features that you enable. During application creation, the system creates cash flow members and hierarchies for Cash Flow Reporting in the Movement and Account dimensions. The following members are created:

  • FCCS_Movements
  • TRCS_CbCR Movements
  • TRCS_TaxLossCreditTotal
  • TRCS_System Movement

Movement Dimension

Note:

You can create additional user-defined members under the Movement dimension to run consolidation and translations for these members. For instructions, see Customizing the Movement Dimension Hierarchy.

To define the Movement Dimension:

  1. From the Home Page, select Application, then Overview, and then the Dimensions tab.
  2. Click Movement to set the properties.
    Select properties for the Movement dimension.
  3. Optional: Select the appropriate optional properties for your application:
    • Enter a Description for the dimension.
    • Select an Alias Table, if available.
    • Enter an Alias name for the 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 the Hierarchy Type, if available.
  7. Under Cube, select which cubes you want to use. You can enable Consol, Rate or 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.