About Presentation Hierarchies and Levels

Use presentation hierarchies and presentation levels to provide multidimensional models. Presentation hierarchies and levels display to users as roll-up information in subject areas they use to create visualizations and analyses.

In most cases, you create presentation hierarchies by dragging and dropping logical dimensions from a logical table into a presentation table. If you drag and drop a logical hierarchy containing more than one hierarchy to a presentation table, then Semantic Modeler creates a separate presentation hierarchy for each of the logical hierarchy's hierarchies. See About Adding Logical Hierarchies with Multiple Hierarchies to the Presentation Layer.

You can also manually browse for and add hierarchies to a presentation table. After you've added a logical hierarchy to a presentation level, you can apply fine-grained access control to the presentation hierarchy and its levels.

A presentation hierarchy's members aren't visible in the presentation layer. But when creating visualizations and analyses, users can view hierarchy members in subject areas.

Users can create hierarchy-based queries using objects in presentation hierarchies and levels. Presentation hierarchies expose analytic functionality such as member selection, custom member groups, and asymmetric queries.