Defining a custom dimension

  1. Add a dimension. For Shape, select Hierarchical. For Usage, select Financial & Exchange data. For example:
    • Name: Trade Currency
    • Contains/Type: Other
    • Shape: Hierarchical
    • Usage: Financial & Exchange Data
  2. In the Members in Hierarchy page, select the Trade Currency dimension. Add a member for each currency required for the application.
  3. In the Members in Hierarchy page, select the Currency dimension. Add a Default Currency member and members for every currency used in the application. Typically, these would match those defined for the Trade Currency dimension. Select D (Divide) as the translation type.
  4. In the Members in Hierarchy page, select the Unit dimension. Set each unit's Currency attribute to Default Currency.