Creating a dimension model

In this lesson, you will create a dimensional model to enable multidimensional analysis of collected data.

1. Click the Dimensional Model tab and expand OrderHandling > Orderhandling Cube.
2. Create a new dimension.
   1. Right-click the Orderhandling Cube and select New > Dimension.
   2. Enter Order Status as the name and click OK.
   3. Right-click Order Status in the navigation, and then select New > Dimension Level.
   4. Enter Order Status as the name and click Browse to find the source metric. Select Order Status. Click OK and then click OK again.
3. You want a multilevel dimension called Location that lets you drill down on the country and then the city within the country. To enable the Location dimension, you need to create metrics for the country and city, and then you can complete the Location dimension to refer to these metrics.
   1. Create a metric called Country by clicking the Monitor Details Model tab, right-clicking the OrderHandling monitoring context, and selecting New > Metric.
   2. Enter Country as the name and leave the type as String, then click OK.
   3. Select A value is required for this metric because a dimension uses this metric and requires a value for dimensional analysis. For the default value, enter an empty string (two single quotation marks).
   4. In Metric Value Expressions, click Add. In the expression cell, use the content assistant to navigate to the OrderHandling > OrderHandlingEXIT event then select Country in the order data under Customer.
      
      The resulting expression is OrderHandling2/OrderHandlingEXIT/Order/Customer/Country.
      
   5. Repeat the necessary steps to create a metric called City. The resulting expression is OrderHandlingReceive/OrderHandlingReceiveEXIT/Order/Customer/City.
4. Update the Location dimension using the Country and City metrics:
   1. Click Dimension Model tab. Navigate to the Order Handling Cube > Location. Notice that there is a dimension level called Location underneath the Location dimension.
   2. Right-click Location underneath the Location dimension and select Delete.
      

   3. Right-click the Location dimension and select New > Dimension Level.
   4. Enter Country as the name, and then click Browse to find the source metric and select OrderHandling > Country. Click OK.
   5. Right-click the Location dimension and select New > Dimension Level.
   6. Enter City for the name, then click Browse to find the source metric and select OrderHandling > City. Click OK. The resulting Location is shown in the following screen capture.
      

   7. Save your work.
5. Select Project > Clean, and then select Clean all projects. Click OK.
   1. Warnings and informational messages might be present and can be ignored. Check for any errors in the Problems view and resolve the errors before continuing.