Analytic Workspace Manager for Oracle OLAP 12.1.0.1.0B


Installation Notes

Analytic Workspace Manager Version 12.1.0.1.0B

System Requirements

This installation contains the client-side files required to run Analytic Workspace Manager 12.1.0.1.0B. This release is intended for Windows Vista, XP, 2000, Server 2003, Windows 7 and Linux.  It requires, at a minimum, a connection to Oracle OLAP 11.1.0.6.0 production software or later. In addition, the Oracle Database must be in 11.1 compatibility mode or later. To take advantage of all the new capabilities and bug fixes found in Analytic Workspace Manager 12.1.0.1.0B, the Oracle Database 12.1.0.1.0 server release must be installed and the Oracle Database must be in 12.1 compatibility mode.


Bug Fixes

Analytic Workspace Manager Release 12.1.0.1.0B addresses the following bugs found in Analytic Workspace Manager Release 12.1.0.1.0:

 

    17959361       Conditions based on Attribute cannot be selected in AwM

    17477998       Calc with OLAP expression syntax can't be saved

    16086757       Data Security error expanding a cube in an 11.2.0.4 database

    18616303       Error dropping Analytic Workspace for 12.1 of AWM connecting to 11.2.0.4 RDBMS

 

Please refer to the Oracle OLAP User's Guide 12g Release 1 (E10627-01) and Analytic Workspace Manager Help for further details.


Release Components

The following files are contained in this download:

  • readme_121010B.html
  • awm12.1.0.1.0B.jar
  • awm.bat
  • awmd.bat
  • awmrun.sh
  • awm.properties
  • awm.ico
  • datavplugin.jar
  • obieeplugin.jar
  • E18648_01 - OBIEE Plug-in for Analytic Workspace Manager Users's Guide for OBIEE 10g.pdf
  • E20237_01 - OBIEE Plug-in for Analytic Workspace Manager Users's Guide for OBIEE 11g.pdf
  • E18663_01 - Data Validation Plug-in for Analytic Workspace Manager Users's Guide.pdf
  • Create_sample_tables.sql
  • Reset_tables.sql
  • Dim_validation.xml
  • Review Guide for Data Validation Plug-in.pdf

Analytic Workspace Manager application Plug-ins

This release of Analytic Workspace Manager includes two application plug-ins:

  • The Oracle Business Intelligence Enterprise Edition (OBIEE) Plug-in for Analytic Workspace Manager (obieeplugin.jar) lets you quickly create an OBIEE 10g or 11g repository that enables the OBIEE Server (and therefore any OBIEE client, including Dashboards, Answers, Delivers, and the MS Office Plug-in) to query Oracle Database 11g OLAP cubes.
  • The Data Validation Plug-in for Analytic Workspace Manager (datavplugin.jar) provides tests to quickly find conditions in dimension table data that might cause errors when maintaining an OLAP dimension or cause problems when querying a cube using business intelligence tools. The data validation plug-in also includes methods that can quickly fix many different types of data errors in dimension tables. Please refer to the Review Guide for Data Validation Plug-in.pdf for a tutorial on the use of the Data Validation Plug-in.

Please refer to the documentation of each application plug-in for a description of each tool and the Oracle support policy for these plug-ins.

How To Install

Windows Environment Install Options:

To install the Analytic Workspace Manager 12.1.0.1.0B release as a standalone executable jar file, extract the contents of the awm121010B_Standalone.zip file and then follow the instructions for a either a new installation of Analytic Workspace Manager or the instructions for upgrading Analytic Workspace Manager from a previous release.

New installation of Analytic Workspace Manager 12.1.0.1.0B

  1. If you are installing Analytic Workspace Manager for the first time, copy the extracted files into a new directory.
  2. Make sure your environment has at least JRE version 1.5 (Java Runtime Environment) installed.  JRE version 1.6 is also supported. This is required to be able to run Analytic Workspace Manager as a single jar file.
  3. Update the awm.bat file included in the kit with the directory path of the version of the Java Runtime Environment installed in your environment and then execute this file to start Analytic Workspace Manager.

Additionally, you may start the awm12.1.0.1.0B.jar file by executing the jar file or by running the jar file from a command line as follows:

start javaw –mx1024m -XX:MaxPermSize=128m -jar awm12.1.0.1.0B.jar

 

Upgrading to Analytic Workspace Manager 12.1.0.1.0B from a previous release

  1. If you are upgrading to Analytic Workspace Manager from a prior release, choose one of the following two options for handling the upgrade:

    Option 1: First, create a backup copy of the installation directory for your previous release of AwM. Copy the location of the directory and all subdirectories of the installed version of AWM to a backup directory. Second, delete the prior version of AWM by removing the awm11.x.x.x.x.jar file (where x.x.x.x. is the release, e.g. 11.2.0.4) from the existing installation directory. Lastly, install the new version of AWM, by copying the awm12.1.0.1.0B.jar file, extracted from the awm121010B_Standalone.zip, to this installation directory.

    Option 2: First, follow the instructions for a new installation of Analytic Workspace Manager 12.1.0.1.0B, as documented above. Secondly, you will need to copy any user-written plugins or XML templates from the previous version of AWM to the new directories where you have installed the new version of AWM. Third, you should copy from the previous version of AWM, the awm.properties file which stores the AWM preferences settings and the awmdb.properties file which stores database connection settings, to the directories where you have installed the new version of AWM. This will ensure that any previous configuration settings will be migrated to the new installation of AWM.

     

  2. Make sure your environment has at least JRE version 1.5 (Java Runtime Environment) installed.  JRE version 1.6 is also supported. This is required to be able to run Analytic Workspace Manager as a single jar file.

     

  3. Update the awm.bat file included in the kit with the directory path of the version of the Java Runtime Environment installed in your environment and then execute this file to start Analytic Workspace Manager.

    Additionally, you may start the awm12.1.0.1.0B.jar file by executing the jar file or by running the jar file from a command line as follows:

    start javaw –mx1024m -XX:MaxPermSize=128m -jar awm12.1.0.1.0B.jar

  4. After starting AWM for the first time, you should verify that the preference settings for directories in the AWM configuration are set properly for the new version of AWM. Select the Configuration option item from the Tools menu in AWM to adjust these settings. The preference settings to check are:

     

    General – Template directory

    Logging – Session Logging Directory Location

    Plugin – Plugin directory

Linux Environment Install Options:

To install the Analytic Workspace Manager 12.1.0.1.0B release as a standalone executable jar file, extract the contents of the awm121010B_Standalone.zip file and then follow the instructions for a either a new installation of Analytic Workspace Manager or the instructions for upgrading Analytic Workspace Manager from a previous release.

New installation of Analytic Workspace Manager 12.1.0.1.0B

  1. If you are installing Analytic Workspace Manager for the first time, copy the extracted files into a new directory.
  2. Make sure your environment has at least JRE version 1.5 (Java Runtime Environment) installed.  JRE version 1.6 is also supported. This is required to be able to run Analytic Workspace Manager as a single jar file.
  3. Update the awmrun.sh file included in the kit with the directory path of the version of the Java Runtime Environment installed in your environment and then execute this file to start Analytic Workspace Manager.

Additionally, you may start the awm12.1.0.1.0B.jar file by running the jar file from a command line as follows:

java –mx1024m -XX:MaxPermSize=128m -jar awm12.1.0.1.0B.jar

 

Upgrading to Analytic Workspace Manager 12.1.0.1.0B from a previous release

  1. If you are upgrading to Analytic Workspace Manager from a prior release, choose one of the following two options for handling the upgrade:

    Option 1: First, create a backup copy of the installation directory for your previous release of AwM. Copy the location of the directory and all subdirectories of the installed version of AWM to a backup directory. Second, delete the prior version of AWM by removing the awm11.x.x.x.x.jar file (where x.x.x.x. is the release, e.g. 11.2.0.4) from the existing installation directory. Lastly, install the new version of AWM, by copying the awm12.1.0.1.0B.jar file, extracted from the awm121010B_Standalone.zip, to this installation directory.

    Option 2: First, follow the instructions for a new installation of Analytic Workspace Manager 12.1.0.1.0B, as documented above. Secondly, you will need to copy any user-written plugins or XML templates from the previous version of AWM to the new directories where you have installed the new version of AWM. Third, you should copy from the previous version of AWM, the awm.properties file which stores the AWM preferences settings and the awmdb.properties file which stores database connection settings, to the directories where you have installed the new version of AWM. This will ensure that any previous configuration settings will be migrated to the new installation of AWM.

     

  2. Make sure your environment has at least JRE version 1.5 (Java Runtime Environment) installed.  JRE version 1.6 is also supported. This is required to be able to run Analytic Workspace Manager as a single jar file.

     

  3. Update the awmrun.sh file included in the kit with the directory path of the version of the Java Runtime Environment installed in your environment and then execute this file to start Analytic Workspace Manager.

    Additionally, you may start the awm12.1.0.1.0B.jar file by running the jar file from a command line as follows:

    java –mx1024m -XX:MaxPermSize=128m -jar awm12.1.0.1.0B.jar

  4. After starting AWM for the first time, you should verify that the preference settings for directories in the AWM configuration are set properly for the new version of AWM. Select the Configuration option item from the Tools menu in AWM to adjust these settings. The preference settings to check are:

     

    General – Template directory

    Logging – Session Logging Directory Location

    Plugin – Plugin directory


Copyright © Oracle Corporation 2014.  Oracle is a registered trademark of Oracle Corporation and/or its affiliates.  Other names may be trademarks of their respective owners.



In-Memory Replay Banner