|Oracle9i OLAP User's Guide
Release 2 (9.2)
Part Number A95295-01
CWM2_OLAP_AW_ACCESS , 3 of 9
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.
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".
CreateAWAccessStructures_FRprocedure for each input file.
Tip: Create a script that executes these procedures.
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 the that script by deleting existing output files.
If necessary, correct the errors and regenerate the views.