Assigning Dimensions

  To finish generating dimensional measures:

  1. Optional: To use results and targets in another data source, such as an Essbase database, perform these tasks:

    • Select the data source from External Datasource.

    • Expand the dimensional outline that is displayed and select the member with the value to use.

  2. To perform calculations such as finding the highest score using all data, select a function from Roll-up Function. To use the resulting formula for targets, select Apply to target formulas.

  3. In Dimensions, select the members for which to gather data. Your selections are added to Candidates. For example this template would enable you to determine the number of sales made in Australia, China, Japan, South Korea, and Taiwan.

    The file SampleMeasureTemplateSetup displays how to generate a Sales dimensional measure that will provide sales data for Australia, China, Japan, South Korea, and Taiwan.

  4. Click Save.

Click Reset to undo your selections and return to the original settings.