To create an analytical query, you begin by building a
structure that arranges analytical query transformations in a tree
of nodes.
About this task
By default, when you create an analytical query, the structure
is simple and consists of one transformation, Column Filter.
You can change it to a transformation of another type or expand the
structure by adding transformations that can be both above and under
the default transformation node in the tree. In this case, newly
added transformations can encompass the current transformation or
be child objects to it.
To build an analytical query
structure:
Procedure
- Select .
The New window opens.
- Expand the QMF Objects folder,
select Analytical Query, and click Next.
The Create New Analytical Query wizard
opens.
- Specify a name for the analytical query in the Name field.
- Click Finish.
The Create New Analytical Query wizard
closes and the new analytical query is displayed in the Analytical query structure with the Column Filter as a default
transformation.
- To change the current transformation to another:
- In the Analytical query structure, select the current transformation node.
- Click the Change to…icon.
- From the list, select the transformation type to which you want
to change the current transformation.
The current transformation is changed to the
selected transformation type and the Item editor pane
displays the items of the new transformation.
- If you want to include the current transformation into
another transformation that will be placed above it in the structure
tree:
- In the Analytical query structure, select the transformation node.
- On the toolbar in the Item editor pane,
click the icon of the transformation that you want to add.
The new transformation is placed above the selected transformation
in the analytical query structure and the Item editor pane
displays the items of the new transformation.
- If you want to add another transformation as a child object
to a transformation in the current structure:
- In the Analytical query structure, select a node under the transformation.
- On the toolbar in the Item editor pane,
click the icon of the transformation that you want to add.
The new transformation is placed under the selected transformation
in the analytical query structure and the Item editor pane
displays the items of the new transformation.
- Make sure you have the required analytical query structure to proceed to populating it with data.
Restructuring the analytical query leads to the loss of current transformation settings.