The layout of the Query object refers to the layout of dimensions along the edges of the query. This layout is specified as a two-dimensional String array (or an array of String arrays). The layout is described as follows: The outer array maps to the edges (such as column or row) of the query. The inner array maps from slowest to fastest varying dimensions within an edge.
Edges -- Specified by the outer array using the edge constants in oracle.dss.util.DataDirector
(for example, COLUMN_EDGE and ROW_EDGE).
Dimensions in an edge -- Specified by the inner array that maps from slowest to fastest varying dimensions in the edge.
You can use the QueryBuilder to change the layout of a query during design mode and in a Java-client application. In an HTML-client application, you can use the Rotate Tool to change the layout of a query.
The layout of the Query
object can be changed by any of the following methods:
The layout
method of the Query
object.
The initQuery
or initCubeQuery
methods of the Query
object.
The applyLayoutAccess
method of the LayoutContext
interface.
The pivot
methods of the DataDirector
object.
The applyQueryAccess
method of the QueryContext
interface updates selections and causes a change in the layout of a query only if the measure selection changes dimensionality.