Use the OLAPQuery section to query multidimensional) or OLAP databases. When you connect to a multidimensional database, the document opens an OLAPQuery section.
The user interface is similar to the Pivot section, except the OLAPQuery section displays the multidimensional database components as a hierarchical tree in the Catalog pane. These components include:
Dimensions—categories of information, such as Location, Products, Stores, and Time. Dimensions are for informational use only and cannot be used as query items. (If a dimension contains multiple hierarchies, they will be represented under the dimension.)
Levels—Groups of similar types of members. For example, using the members listed in a Location dimension, Japan, USA, and France belong to the Country level. San Francisco, Paris, Tokyo, and Rome belong to the City level. 35 Main Street belongs to the Address level.
Hybrid (Analysis)—Further dimensional data is present by way of Hybrid Analysis (the lowest levels of an Essbase or DB2 cube that can reside in a relational database, but are not reflected in the cube structure (metadata) that is resident on the Essbase Server itself). If a dimension has Hybrid Analysis data, the Essbase Server, in conjunction with the Essbase Integration Server automatically retrieves the data from the appropriate relational table source and passes it to Interactive Reporting. If a dimension has available hybrid analysis, it is indicated to the right of the level as shown below.
Members—Content values for a dimension. In the Location dimension, they could be: San Francisco, Japan, Paris, 35 Main Street, Tokyo, USA, France, Rome, and so on. These all are values for location.
Members are shown only under the Values (I) icon and can be dragged only into the Top Labels or Side Labels panes in data layout.
Member Property—A descriptive piece of information about a member that can be retrieved and displayed in the OLAPQuery. This information is metadata and does not in itself constitute a distinct member in the dimensional hierarchy. For example, let’s assume the following hierarchy:
The Product Name level might have the following properties defined:
You can drag a property into the data layout with its corresponding level, but you cannot drag it into the Slicer or the Measures pane, or apply a filter to it.
Measures—Numeric values in a database cube that are available for analysis. The measures could be margin, cost of goods sold, unit sales, budget amount, and so on.
Individual measures are shown under the Measures icon and can be dragged only to the Measures pane.