Oracle9i OLAP User's Guide Release 2 (9.2.0.2) Part Number A95295-02 |
|
|
View PDF |
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_FR
procedure for each input text 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 that script by deleting existing output files.
If necessary, correct the errors and regenerate the views.
GRANT SELECT ON VIEW electro_product_view TO PUBLIC