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 |
---|---|
Slicer | Filters |
Side | Rows |
Top | Columns |
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 supported. |
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 dialog box. |
Shortcut menu enables access to the Filter dialog box and Remove option. | Shortcut menu enables access to Remove option, Member Selection dialog box, Variable option and Filter option |