In Oracle : Oracle Analytic Workspace Manager - Oracle OBIEE tool

Oracle Applications EBS 11i, R12      Oracle Database      Data Warehouse & BI      Oracle Middleware      PL/SQL      Linux ...

Oracle Data Warehouse & BI

In-Oracle.com  -> Oracle Data Warehouse & BI  -> Oracle Business Intelligence (BI)

-> Oracle Analytic Workspace Manager

 

 Oracle Analytic Workspace Manager

 

 

Here is an image showing the interface of the Oracle Analytic Workspace Manager :

 

Analytic Workspace Manager

 

You can use Analytic Workspace Manager for creating measures, dimensions and cubes in the OLAP database if the database was installed with the OLAP option.

Workspace Manager, a feature of Oracle Database, enables application developers and DBAs to manage current, proposed and historical versions of data in the same database.

Applications and DBA operations often work with more than one version of the data. Three common reasons to have multiple data versions are concurrency, auditing and scenario creation. Oracle Workspace Manager provides workspaces as a virtual environment to isolate a collection of changes to production data, keep a history of changes to data and create multiple data scenarios for “what if” analysis. It can save money, time and labor over traditional approaches.

 

Important to know about Analytic Workspace Manager:

 

- you can download it from the Oracle site from here.

- you will download a .zip file which will be unzipped. Here you will see a file named awm.bat . You have to double click on it to open the Analytic Workspace Manager. You don't have to install them.

- when you create a new database connection perhaps you will have to set the TNS_ADMIN variable in your environment to let Analytic Workspace Manager to find the tnsnames.ora file and to understand the database alias. Instead the database alias (taken from the tnsnames.ora) you can use the following : <database server >:<port>:<SID>

 

 

 

In-Oracle.com  -> Oracle Data Warehouse & BI  -> Oracle Business Intelligence (BI)

-> Oracle Analytic Workspace Manager

Oracle Applications EBS 11i, R12      Oracle Database      Data Warehouse & BI      Oracle Middleware      PL/SQL      Linux ...

 

     Copyright (c) 2011-2015  www.in-oracle.com  |  Disclaimer: The views expressed on this web site are my own and do not reflect the views of Oracle Corporation. You may use the information from this site only at your risk.