Process Overview

These are the basic steps you need to follow to generate views of data stored in an analytic workspace. They are described more fully throughout this chapter.

1. Explore the analytic workspace and identify the objects that you want to expose in a relational view.
2. For each view, create a text file that defines the mapping between analytic workspace objects and columns in the view.

   If you intend to create OLAP Catalog metadata, then you need to generate views that form a star schema, that is, fact views and dimension views. For more information about OLAP Catalog schema requirements, refer to Chapter 4, "Designing Your Database for OLAP".

3. In PL/SQL, execute the CreateAWAccessStructures_FR procedure for each input text file.

   Tip: Create a script that executes these procedures.

4. Use a text editor to view the resulting scripts and make whatever changes you wish.
5. In PL/SQL, run the scripts.
6. If errors are triggered, do the following:
   1. Identify and fix the problems in the input files.
   2. Delete the script files.

      CreateAWAccessStructures_FR will not overwrite an existing output file. If you created a script to execute this procedure on each of your input files, you may want to begin that script by deleting existing output files.

   3. Regenerate the script files.
7. In PL/SQL, select data from the views to verify that they work properly. Errors at this stage are caused by problems in the definition of the workspace objects.

   If necessary, correct the errors and regenerate the views.

8. When no errors occur, commit the views to the database.
9. Change the access protection of the views with commands such as this:

   GRANT SELECT ON VIEW electro_product_view TO PUBLIC