Detailed mission looks like windows explorer. Dataodyssey displays the tree of selected dimensions in its left part. The tree hierarchy depends on selected dimensions order. When you click a tree branch the program displays the details in the right part.

    So, when you create a new mission or a submission, it's necessary to define the number and order of dimensions and details - the fields that are displayed in the right explorer part after selecting a position in the left.

    The tree of dimensions can have several nesting levels. Actually, data is grouped according to an any list of fields with free nesting level.

    After the selection of a tree position the program generates data retrieval condition, related to this tree position. You can select details for any hierarchy level, not necessarily for the deepest one.

    When the details have been selected, you can:

• move columns in the detail grid (click a column title and drag it to the left or right, keeping the left mouse button pressed).
• change any column width (drag a column border to the left or right).
• sort the strings (double click on a column title).
• search for strings, which have substrings or certain first symbols (just select the column and start typing a substring or the first symbols of the required word). The program will search for matches after each symbol entered.

• summarize numeric columns.
• export the components from a table to Excel.
• create an Excel chart.

    After changing the width or order of the column, the program will save the new parameters and apply them for other tree position details.

    If you need to thoroughly analyze data of the current tree position, you can create a summary or a detailed submission which will by default contain a filter condition for the retrieval of the data, related to a parent mission's tree branch only.

    Detailed missions can’t be used in reports. Use summary missions for this purpose.

    Some technique can be useful when you want to see several fields of one table in the tree. For example: you need grouping goods by their codes. Also you want to see names of goods in tree. First way is to add B.CODE and B.NAME into dimensions list. But it won't be good view, because nodes with names will be shown as subnodes of codes. But you'll have got a best speed of selections.

Another way is to create a complex expression for one dimension. In our example we can create an expression which will be universal for all types of data sources. Add B.CODE into dimensions list and click "Edit" button above to call an expression builder. Our expression should be:

Click OK and change a name of the column in next dialog to CODE_NAME_B. Add any other dimensions and our tree will look like

You'll receive a good view and convenient grouping, but the speed of selections will be slower.

www.dataodyssey.com         Table of contents