Analytic Workspace Manager for Oracle OLAP 11.2.0.4.0B


Installation Notes

Analytic Workspace Manager Version 11.2.0.4.0B

System Requirements

This installation contains the client-side files required to run Analytic Workspace Manager 11.2.0.4.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 11.2.0.4.0B, the Oracle Database 11.2.0.4.0 server release must be installed and the Oracle Database must be in 11.2 compatibility mode.


Bug Fixes

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

 

    16423236       Changing AGG operator to 'NONADDITIVE' automatically changes other AGG operators

    12869980       Cube Aggregation Panel edit synchronization bug AGG operator and AGG hierarchy

    16821437       Namespace Checker not working with duplicate dimension names

    12770909       Error Creating measure with datatype VARCHAR2

    14323300       WRONG STATUS WHEN ATRRIBUTE IS MAPPED TO SEVERAL LANGUAGES

    17923436       DETECT DATA TYPE CHKBOX SHOULD BE DISABLED AND UNCHCK FOR END DATE AND TIME SPAN

    18452950       ATTRIBUTE AUTO DETECT DATATYPE CHECK BOX NOT DISPLAYING CORRECT VALUE ON EDIT

 

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


Release Components

The following files are contained in this download:

  • readme_112040B.html
  • awm11.2.0.4.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 11.2.0.4.0B release as a standalone executable jar file, extract the contents of the awm112040B_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 11.2.0.4.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 awm11.2.0.4.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 awm11.2.0.4.0B.jar

 

Upgrading to Analytic Workspace Manager 11.2.0.4.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:
  2. 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.3) from the existing installation directory. Lastly, install the new version of AWM, by copying the awm11.2.0.4.0B.jar file, extracted from the awm112040B_Standalone.zip, to this installation directory.

    Option 2: First, follow the instructions for a new installation of Analytic Workspace Manager 11.2.0.4.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.

     

  3. 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.
  4.  

  5. 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.
  6. Additionally, you may start the awm11.2.0.4.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 awm11.2.0.4.0B.jar

  7. 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:
  8.  

    General – Template directory

    Logging – Session Logging Directory Location

    Plugin – Plugin directory

Linux Environment Install Options:

To install the Analytic Workspace Manager 11.2.0.4.0B release as a standalone executable jar file, extract the contents of the awm112040B_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 11.2.0.4.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 awm11.2.0.4.0B.jar file by running the jar file from a command line as follows:

java –mx1024m -XX:MaxPermSize=128m -jar awm11.2.0.4.0B.jar

 

Upgrading to Analytic Workspace Manager 11.2.0.4.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:
  2. 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.3) from the existing installation directory. Lastly, install the new version of AWM, by copying the awm11.2.0.4.0B.jar file, extracted from the awm112040B_Standalone.zip, to this installation directory.

    Option 2: First, follow the instructions for a new installation of Analytic Workspace Manager 11.2.0.4.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.

     

  3. 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.
  4.  

  5. 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.
  6. Additionally, you may start the awm11.2.0.4.0B.jar file by running the jar file from a command line as follows:

    java –mx1024m -XX:MaxPermSize=128m -jar awm11.2.0.4.0B.jar

  7. 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:
  8.  

    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