Use SQL Views

OLAP Exchange^® works with SQL Views, which are user-defined "virtual tables" in your underlying database. OLAP Exchange references these SQL views in the same way it references tables, provided the Allow View Tables feature has been enabled.

The Allow View Tables feature appears in the Cube section of the Create Cube from Relational Source dialog box (see following detail figure). By checking the box, you can use SQL Views for Dimension creation in the same manner that you use existing tables in the database. (SQL Views are created and maintained in your RDBMS—they are not created via OLAP Exchange^®)

Notes


If you do Allow View Tables, you cannot use the Incremental Updating feature of OLAP Exchange^®—SQL Views do not support triggers.