This section details the steps to be performed by the user for developing a new cube. Make sure that the existing cubes do not provide the required analytics / reporting coverage before deciding to define a new cube. In case user would like to see measures against a new dimension that is not part of the existing seeded metadata, then suggest including the new dimension as part of the existing cubes instead of creating a new cube. As a prerequisite, user should have defined datasets, measures, hierarchies and dimensions before defining a cube.
Procedures to develop a new cube involves the following steps:
Step 1 - Add Cube: From Unified Metadata Manager, select Business Metadata Management, then select Cube. Specify the MDB details that will be created in ESSBASE.
Step 2 - Include Dimensions: Include dimensions that are part of the cube definition. Users mandatorily need to include TIME and MEASURE dimensions.
Step 3 - Specify Variations: Specify variations between each of the measures to the respective dimensions. All the measures that are part of the cube need not vary against all of the dimensions. Depending on business needs, variations can be specified to control the rollup of measures against a set of dimensions.
Step 4 - Specify Dataset: Specify dataset corresponding to the selected dimensions and measures. Data set will supply required data to the cube.
Step 5 - Specify Node Level Formula: If node level formula's are required to be specified for the nodes within the hierarchy, then they can be specified in this UI.
Step 6 - Save and Build: Save the cube. Define and execute batch in ICC to build the cubes.
For more information on Cubes, see Cubes under Unified Metadata Manager chapter in Oracle Financial Services Analytical Applications Infrastructure User Guide.