Creating a shared dimension for cubesIf designing multiple cubes that contain the same dimension, create a shared dimension. For example, if one cube contains sales data by country, state, and city, and another cube contains budget data by country, state, and city, you can create a shared multi-level dimension that provides country, state, and city data. By using a shared dimension, you define and maintain dimension data in one place, and reuse the dimension in multiple cubes. Reusing a dimension also speeds up data processing.This procedure assumes that you have already created a data object, as well as, the data set that provides the data for the dimension.
If creating a multi-level dimension, drag and drop additional columns. Figure 3-6 shows an example of a multi-level dimension that contains country, state, and city data.Choose OK. The shared dimension appears under Shared Dimensions in Data Explorer and in the data object design.
2 In Data Explorer, expand the cube that contains the dimension to convert to a shared dimension, then right-click the dimension and choose Convert to Shared Dimension, as shown in Figure 3-7.
Figure 3-7 The converted dimension appears under Shared Dimensions in Data Explorer and in the data object design, as shown in Figure 3-8. BIRT also replaces the original cube dimension with the shared dimension.
|
|
Copyright Actuate Corporation 2012 |