Summary Mission

    Summary mission is a query, with or without aggregates.

    Only the list of dimensions is compulsory to compose. You can also define several aggregates. In this case, the data will be grouped by dimensions. If there are no aggregates it will be a simple query without grouping.

    If you group data, you can analyze any row more thoroughly by creating submissions.

    After retrieving data you can:


    Only summary missions can be used in reports. Nevertheless, you can create a summary submission for any type of parent mission. In practice, if you need to use the details of a detailed mission's item in a report, you may just create a summary submission for this item.

Simple queries without aggregations

    If you need to create a simple table query without grouping, create a summary mission that has a one-table data model. Do not specify an aggregate. You can specify just a filter condition. The program will not group rows in query result.


    You can unite several summary missions. Full compatibility of names, types and column order is not necessary. It is possible to unite retrieval results even from incompatible data sources.

    The Union bar on the right side of the mission structure (or cube update) dialog window is used to create unions. It consists of two arrow-buttons for up and down switching between UNION clauses and buttons with UNION clause numbers used to view a concrete clause. To create a new UNION section click in the bar.

    If current UNION element is the last, the program will create a clear page for a new element. Before that, like when creating a new mission, it will require a data model template or a data source specified.

    If a UNION section is fully compatible with the first section, it will be executed the most fast, because the program will transfer the query with UNION sections to the server. The following conditions are required for sections full compatibility:

    If there is no full compatibility the program will first retrieve data on the client side and add to the first section result then.

Data source compatibility

    Data source compatibility in different UNION sections is not as important, as the query and main mission data source compatibility. The ability of Dataodyssey Express to unite sections of different structure and from heterogeneous data sources is rather unusual and can be very useful in some situations.         Contents