The following rules apply to the OLAPQuery section data layout:
A dimension can be represented only on one axis. For example, if the level Year is in the Side Labels pane, you cannot drag the level Quarter to the Top Labels pane.
If you move the level of one dimension, Interactive Reporting automatically move all levels of the same dimension.
To pivot data in the OLAPQuery section, move the items in the data layout panes. You cannot use the label handles to pivot data.
Levels from the same dimension must be grouped together in both the Side Labels and Top Labels panes.
For example, you cannot use the following order for side-label levels, since levels from different dimensions are mixed (Year, Quarter, and Month come from the Time dimension, Store Type comes from the Store dimension, and Product Category comes from the Product dimension).
Instead, the data layout requires that you use this order (Year, Quarter, and Month are all from they same dimension so they are grouped together).
The hierarchy of a dimension cannot be broken. For example, Year must come before Quarter, which must come before Month.
“Hybrid Analysis” (Essbase only)—If data is successfully retrieved from the Essbase servers, a “dummy” Level is added to the data layout called "Hybrid1". The new Level of data is shown in the Contents Pane. If data is not retrieved successfully from the Essbase servers (i.e. an error message is returned) the message "No more levels to drill into" message is displayed. If you subsequently drills-down on a returned Hybrid Analysis Level of data, the retrieved Hybrid Analysis Level of data is called "Hybrid2" and so on.
OLE DB only —If you retrieve dimensional level properties from the database, you can drag each property into the data layout after you add its corresponding level.
For example, if the data layout contains Country, Year and you drag Manager, (a property of Country) into the data layout, the Manager property is kept with Country and not added after the Year level. A property cannot be dragged into the Slicer pane, the Measures pane in data layout, or have a filter applied to it.
Note that in order to retrieve dimensional level properties, you must enable the Show Member Properties checkbox when creating the Interactive Reporting database connection file.