Methods of Creating a Workspace - OLAP

With OLAP Catalog metadata defined for your data source, you can choose from these methods for creating an analytic workspace:

  • Analytic Workspace Manager. The Create Analytic Workspace wizard is the easiest method of creating an analytic workspace, and the one described in this chapter. The wizard generates a SQL script of DBMS_AWM statements, which you can choose to execute immediately or save for execution later.
  • DBMS_AWM PL/SQL package. The DBMS_AWM package enables you to automate the build process in a script and schedule it to run overnight in a batch window. For most production systems, this is the preferred practice. You can use the Create Analytic Workspace wizard to generate a basic script, then edit the script to make any changes. This is a much less tedious and time-consuming method than coding the scripts entirely by hand. The DBMS_AWM package provides greater flexibility in designing your analytic workspace than the graphical methods. Figure shows the relationships among the tools used in the build process.

Components Used With the OLAP Catalog to Build an Analytic Workspace

Components Used With the OLAP Catalog to Build an Analytic Workspace


All rights reserved © 2018 Wisdom IT Services India Pvt. Ltd DMCA.com Protection Status

OLAP Topics