2.1 Adding Dimensions

Use this configuration to add the required business dimensions from production to the STSA workspace. These dimensions are consumed from the Advanced Analytical Infrastructure (AAI) and must contain at least one associated hierarchy to be visible in the list. The added dimensions are used in lower-level configurations such as Portfolio and Variable definitions.

This metadata is exported while creating the sandbox.

Prerequisites

• Ensure that you configure other OFSAA products on the same information domain (or workspace).
• Ensure that you have replicated and migrated the hierarchy metadata from production to sandbox. For more information, see the Creating Sandbox section in the Oracle Financial Service Stress Testing and Scenario Analytics User Guide.

1. Login to STSA.
   The Workspace Summary page is displayed.
2. In the Workspace Summary, Sandbox tab, launch the required workspace.
3. Click the Context Menu representing the user name and then click Configuration Manager.
4. Click Configure in the Dimension Configuration section.
   The Dimension Configuration Summary page is displayed.
5. Click Create New.
6. Select the required dimensions and click Save.
   You can search for any dimension or hierarchy level using the search option.

   The Dimension Configuration section shows how many dimensions are selected in STSA out of the total number of dimensions available from production schema.

   Download the mapping template provided in the UI. Fill in logical glossary terms and map them to the corresponding physical table and column names. Upload this completed template under Glossary > Mapping.