n addition to dimension member names, locations, and relationships, Essbase stores
characteristics, called attributes, about members. For example, the Product dimension indicates
that in Women's Apparel, Shirts and Blouses, there is a cotton T-shirt; an attribute indicates that
the cotton T-shirt is red, cyan, lime, or pink. Essbase does not store data for attribute dimensions
as part of the multidimensional database but instead dynamically calculates it upon request.
Attribute dimensions are displayed in dimension hierarchies, in the same manner as other
dimensions, despite their data being stored differently.
The Catalog List displays one or all dimensions in a tree model. The tree can be expanded to
display additional members, but generations are not included in the hierarchy. For cubes with
many members in a dimension, paging facilitates navigation. The number of members that can
be displayed in the Catalog and Member Selection is defined in the Number of members to
display option in Query Options. The default is 50.
To display the Catalog in single-dimension mode, select a dimension from the Dimension
To expand the tree to display additional members in the dimension hierarchy, next to the
dimension, click + .
To display the Catalog in all dimension, click
OLAPQuery and CubeQuery Data Layout Differences
OLAPQuery is the pre release 9.3 section used to query a multidimensional database. The data
layout tool in OLAPQuery and CubeQuery have these differences:
OLAPQuery Data Layout
CubeQuery Data Layout
Filters from multiple members may be selected and
applied from a single hierarchy.
One filter member can be selected per dimension. Filters
for multiple members within the same dimension are not
Measures are treated as distinct dimensions and can be
placed only in the Facts pane of the data layout.
Measures can be placed in the Row, Column, and Filter
panes of the data layout.
Member selection in the data layout is unavailable.
Member selections in the Row, Column and Filter panes
of the data layout can be edited in the Member Selection
CubeQuery Section n 275