Building analytical query structures

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

  1. Select File > New > Other.
    The New window opens.
  2. Expand the QMF Objects folder, select Analytical Query, and click Next.
    The Create New Analytical Query wizard opens.
  3. Specify a name for the analytical query in the Name field.
  4. 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.
  5. To change the current transformation to another:
    1. In the Analytical query structure, select the current transformation node.
    2. Click the Change to…icon.
    3. 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.
  6. If you want to include the current transformation into another transformation that will be placed above it in the structure tree:
    1. In the Analytical query structure, select the transformation node.
    2. 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.
  7. If you want to add another transformation as a child object to a transformation in the current structure:
    1. In the Analytical query structure, select a node under the transformation.
    2. 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.
  8. 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.