Procedure: Create SQL Access to the Analytic Workspace

Once you have completed the steps described in Procedure: Create the Analytic Workspace Cube, you can generate the relational views that will allow SQL applications to access the analytic workspace. These views contain calls to the OLAP_TABLE function. OLAP_TABLE, described in Chapter 12, uses object technology to present the contents of the workspace in table format.

Use the following steps to generate the views:

1. Call the AW_DIMENSION_CREATE_ACCESS Procedure to generate views of the cube's dimensions.
2. Call the AW_CUBE_CREATE_ACCESS Procedure to generate views of the cube's measures.

   Note: In the current release, the views generated by AW_DIMENSION_CREATE_ACCESS and AW_CUBE_CREATE_ACCESS are structured in the format required by the OLAP API.