Dataodyssey Express Home Data Mining Data Map and Logon Data Sources User Name and Password in Connection Strings Data Models Data Model Templates Models in Missions and Cubes Retrieve from: Tables Subqueries from Saved Mission Plans  Subqueries in a Model Relations Compatibility Rules Missions New Mission from Gattaca New Mission Properties Data Model Using Templates Simple Query from One or Several Tables Detailed and Summary Mission Creating Dimensions Simple Dimensions Compound Dimensions Names and Characteristics of Dimension Properties Syntax Peculiarities of Different Data Sources Dimension Subqueries Using the Expression Builder for dimensions Dimension Order Keys Retrieving Details for a Detailed Mission Creating Aggregates for a Summary Mission Aggregate Functions Simple Aggregates Complex Aggregates Using the Expression Builder for Aggregates Column Order Filter Condition Main and Subquery Filters Basic Conditions for Individual Fields OR Enumeration Report Dates Combining Fields Complex Expressions Simple Conditions in Complex Expressions Comparing Fields EXISTS Subqueries Parent Mission Conditions Editing an Active Mission Detailed Mission Summary Mission Simple Queries without Aggregates Summary Mission Unions Compatibility Rules Creating Submissions Sorting Mission Results and Context Search Summarizing Result Columns Exporting to Excel Filling Excel Worksheet Ranges Excel Charts Exporting Onscreen Data Gattaca Navigation Mission Plans Saving Mission Plans Destinations of Plans, Cubes and Reports Local and remote Plans Editing Mission Plans Creating Missions from Plans Editing Created Missions Removing Plans Cubes Cube List Creating Cubes Reversible and Irreversible Cubes Cube as a Replication Editing Cube Properties Creating an Update Updating by Keys Updating by Keys and Layer Dates Modification Dates Updating without Keys and Layer Dates Keyless Updating by Layer Dates Specifying Layer Dates Using Replications to Copy Tables Editing Updates Executing an Update (Layer Creation) Update Log Undoing a Layer in Reversible Cubes Reindexing Deleting an Update Deleting a Cube Using Cubes in Missions Batch Updating of Cubes and Replications Command Line Updating Reports Local and Remote Reports Combining Missions in Reports Mission Relations in Reports Main Report Form Visual FoxPro Report Forms Excel Report Forms Multitable Forms Form Instances Executing a Report Administrator and User Privileges Information for Developers and Administrators Data Sources and Access technologies Microsoft SQL Server database and ODBC access Microsoft SQL Server database and IIS access with HTTP + XML ORACLE and ODBC access MySQL and ODBC access Visual FoxPro DBF Tables and File-Server Access Visual FoxPro DBC Database and File-Server Access Microsoft Access database and file-server access Dataodyssey Server Access Using RPC and XML Dataodyssey Server Access Using IIS, XML and HTTP Settings Additional JOIN clause in Model properties Additional WHERE clause in Model properties Event Handling BEFORE LOAD Mission or Cube Update Event AFTER LOAD Mission or Cube Update Event BEFORE DATA SELECT Mission or Cube Update Event AFTER DATA SELECT Mission or Cube Update Event BEFORE DETAILS SELECT Detailed Mission Event AFTER DETAILS SELECT Detail Mission Event BEFORE DIALOG Report Event BEFORE SELECT Report Event AFTER SELECT Report Event MAIN FORM BEFORE REPORT Report Event MAIN FORM AFTER REPORT Report Event BEFORE Report Form Event AFTER Report Form Event Creating Visual FoxPro Components (functions, procedures, classes, forms, reports, etc.) Mission Technology and SQL Conventions SELECT Statement FROM Clause WHERE Clause SELECT Subqueries FROM Subqueries WHERE Subqueries UNION Construction Query syntax support for several platforms Dataodyssey Express Cubes and the OLAP classic technology Analyzing SQL Query Code COM Interface Batch updating of Cubes and Replications Limitations Tools Browsing Tables Exploring Tables Copying Tables ZIP-Archiving Tables Packaging DBF Tables Repairing the most common DBF failure

(c) Andrey Evsikov 2008