analytiv workspace manager 11g with oracle 12c

When you right-click an object, you get a choice of menu items with appropriate actions for that object. When you select an object in the navigator pane, the display pane to the right provides detailed information about that object. In addition, there are menus, a toolbar, a navigation pane, and a display pane. You can switch between these two views using the View menu. The console, or main window, provides two views: the OLAP Catalog View, and the Object View. It is a Java application that provides a graphical user interface to several PL/SQL packages and to the OLAP DML. The DBMS_AWM package provides greater flexibility in designing your analytic workspace than the graphical methods.įigure 6-1 shows the relationships among the tools used in the build process.Ħ.2 Introduction to Analytic Workspace ManagerĪnalytic Workspace Manager is a primary tool for creating, developing, and managing analytic workspaces. This is a much less tedious and time-consuming method than coding the scripts entirely by hand. You can use the Create Analytic Workspace wizard to generate a basic script, then edit the script to make any changes. For most production systems, this is the preferred practice. The DBMS_AWM package enables you to automate the build process in a script and schedule it to run overnight in a batch window. The wizard generates a SQL script of DBMS_AWM statements, which you can choose to execute immediately or save for execution later.ĭBMS_AWM PL/SQL package. The Create Analytic Workspace wizard is the easiest method of creating an analytic workspace, and the one described in this chapter.

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

Analytiv workspace manager 11g with oracle 12c