OBIEE 11G - (Presentation Hierarchy|Hierarchical Column)

Bi Server Architecture With Client

About

With presentation hierarchies, roll-up information is displayed in the Oracle BI Answers navigation pane, providing users with important contextual information.

Obiee11g Presentation Hiearchy Roll Up Info Answers

Holds data values that are organized using both named levels and parent-child relationships. This column is displayed using a tree-like structure. Individual members are shown in an outline manner. Hierarchies allow you to drill deeper into the data, to view more detailed information.

Most importantly, users can create hierarchy-based queries using these objects.

Presentation hierarchies expose analytic functionality such as:

  • member selection Filtering on Hierarchical columns is done through Selection Steps

    ,

  • custom member groups,
  • and asymmetric queries.

As with other Presentation layer objects, you can also:

  • provide localization information
  • and apply fine-grained access control to presentation hierarchies and levels.

Obiee11g Presentation Hiearchy New

When you sort items in a hierarchical column, you always sort within the parent. That is, children are never sorted outside of their parent. The children are displayed below the parent in the proper sort order; the parent is not sorted within its children.

The Offices Total parent is always displayed above its children:

Note

The Drill To Levels and Drill From Levels tabs are reserved for a future release and are not currently used. An additional option called Generate Drill Graph, available as a right-click option for any Presentation layer object, is also reserved for a future release.

Documentation / Reference





Discover More
Obiee Essbase Unbalanced Hierarchy
OBIEE - Essbase

Cube scope: Member attributesunbalanced hierarchies“”“”hierarchy columnattribute column Support...
Obiee 11g Subject Area Bmm Create
OBIEE - Subject Area / Presentation catalog

A subject area in Presentation Service is equivalent to a presentation catalog in BI Server. In 10g, a difference was made between: a subject areas in the Presentation Service a presentation catalog...
Saw Object
OBIEE 10G/11G - Answer/Analytics

(Answers 10g|Analyses 11g) is the base component of BI Presentation Service to create Web report . It provides: ad-hoc query and analysis capabilities. The definition of an answer is principally...
Obiee Column Properties Date Datatype
OBIEE 10G/11G - (Presentation column|Attribute Columns)

An Attribute Column Holds a flat list of values that are also known as members. No hierarchical relationship exists between these members, as is the case for members of a hierarchical column. To...
Obiee Multiple Dimension Hierarchie
OBIEE 10G/11G - Dimension Hierarchy (logical dimensions)

(Dimension hierarchies|Logical Dimensions|Hierarchy) introduce formal hierarchies into a business model. They are created in the Business Model and Mapping layer. Before 11g, end users can't see them...
Obiee 11g Aggregate At
OBIEE 10G/11G - Period to period comparison with the AGO Function

Ago is a time function that calculates the aggregated value from the current time back to a specified time period. This function is useful for comparisons, such as Dollars compared to Dollars a Quarter...
Obiee11g Map View Component
OBIEE 11G - Map View

Map view is a new view in 11g that permit to include a mapviewer map in an answer. When you edit a map view and work with layers, you create formats for those layers. For example: the floor maps of...
Obiee 11g Master Detail Properties
OBIEE 11G - Master Detail

Master-detail linking of views allows you to establish a relationship between two or more views such that one view, called the master view, will drive data changes in one or more other views, called detail...
Obiee11g Architecture Functional Component
OBIEE 11G - New Features and changes 11G

Oracle Business Intelligence Enterprise Edition (OBIEE) 11g is the most significant release of OBIEE since 2006. This article contains the significant changes and new features of OBIEE 11g. Oracle...



Share this page:
Follow us:
Task Runner