Detailed mission looks like an explorer. In the left part Dataodyssey creates the tree of selected dimensions. The tree has hierarchy depending on the order of dimensions you have selected. When you click a tree branch, the program shows its details on the right.

    Thus, when you create a new mission or submission, you must specify the order of dimensions and the order of details – the fields to be displayed on the right.

    The tree of dimensions can have several levels. Practically you group data by a random list of fields with random nesting. After you have selected another branch, the program generates a retrieval condition for the data relating this tree item only. You can retrieve details for any hierarchy level, not necessarily for the innermost. When the details have been retrieved, you can:

• move columns inside the grid of details (drag the caption to transfer the column to the left or right, keeping the left mouse button pressed);

• change the width of any column (drag a column border to the left or right);

• sort rows (click column header twice);

• search for rows that contain a substring or some first symbols (just select the required column and start typing the substring or the first symbols of the word you search for). The program will search for correspondence after each symbol you type;

• sum numeric columns;

• export the details from the table to Excel;

• build Excel charts.

    After you change the column order or width the program will remember these parameters and apply them for the details of another tree item.

    If you need to analyze the current tree branch related data more thoroughly, you can create a summary mission or a detailed submission that will by default contain a filter condition to retrieve the parent tree branch related data only.

    Detailed missions cannot be used in reports. Use summary missions.

www.dataodyssey.com         Contents