<< Click to Display Table of Contents >> Current:  Data Mart > MPP > Using the Data in the Data Mart  ROLAP Support

Dimension size is different, following the sequence of country, province and city from large to small. The range size is known as hierarchy. Create a hierarchical directory under the dimension node and drag the dimensions with different size into the hierarchy by dragging. The larger dimension is above and the smaller one is below. The order of dimensions determines the order of drilling. If drill-up is required, the last dimension mostly close to current dimension will be detected (namely the larger scope of dimension) If drill-down is required, the next dimension mostly close to current dimension will be detected (namely the smaller scope of dimension)

 

➢For example

Certain SQL data set has yearly, quarterly and monthly filed. The three fields are different in size. Year is greater than quarter and quarter is greater than month as shown in the figure below.

The user right clicks the  metadata area to choose create hierarchy, as shown in the image below. 

Input the hierarchy name in the pop-up dialog, click the confirm button to produce hierarchy folder at metadata area. 

The user can drag hierarchical fields into a hierarchical folder as shown in the figure below.

The position of the fields dragged to the hierarchical folder can be adjusted by dragging the mouse. The scope of the upper fields is larger as shown in the figure below.  

 

When the user binds the field in the folder of this hierarchy in the dashboard editor, a plus sign will be generated at the lower right corner of data segment in the larger scope. When the user clicks this plus sign, the data segment that is one hierarchy smaller than the current data segment will be automatically binding, at the same time, the plus sign will become minus sign.