4.7.1 Creating a Hierarchical OLAP Overlay
The Hierarchy tab of the logical model provides an interface to create the OLAP overlay. Entities and attributes are listed in the center pane in a tree structure.

To add dimensions to the overlay, do one of the following:
The order of dimensions within each dimensional hierarchy is significant, as this is the order of the drilling hierarchy.
• Drag an individual attribute from the logical model (center panel) to the 'Dimensions' panel. This adds the attribute as a dimension.
• Drag an entire entity from the logical model (center panel) to the 'Dimensions' panel. This adds all attributes of the entity as a dimensional hierarchy.
To add a measure to the overlay, drag an attribute from the logical model (center panel) into the 'Measures' area.
When you create dimensions, give special attention to Date fields. Breaking a single date field into individual components can drastically increase usability for the end user. Additionally, mapping date components into business attributes can be a powerful usability enhancement, for example, mapping the month of a date field so that June becomes “calendar month 1,” and so on.
To create new date components of this kind, you can define expression attributes in the Model tab. These expression attributes will be available for use in the hierarchical overlay. For example, to create a new 'Month' attribute in which June is “calendar month 1,” you could define a new expression attribute with the formula
Month(DateAdd('m',-5,field['orders.order_date']))
where 'orders.order_date' is the existing date column. The particular formula would need to use SQL syntax and functions that are appropriate to the underlying database. See Defining Expression Attributes for more information.
| << 4.7 OLAP Overlay Multidimensional Analysis | © 1996-2013 InetSoft Technology Corporation (v11.5) | 4.7.2 Editing Dimension and Measure Properties >> |