Oracle Essbase 9 - installation and configuration
The purpose of this topic is the first acquaintance in practice of the habr-community with the product, Oracle Essbase. Here you can read about the architecture of this product .
At the moment (February 2011) the current version is 11.1.2, in which Oracle and Hyperion once again made a big step towards integration and complicated the application infrastructure at times. This version is suitable for those who are already familiar with the system and understand all the architectural features. The process of its installation is described in detail on thematic blogs .
I propose to use the previous version 9.3 for OLAP Oracle Essbase engine, which, in the OLAP kernel, is not much different from its older brother, since the process of setting up additional components in version 11 (which are loaded) can take quite a long time and resources.
')
Accordingly, the installation process can be divided into three stages.
Step one
In order to get Oracle's new “conditionally free” software, I suggest using the EDelivery portal, where you will need to fill out a form and agree with the terms of the Oracle license agreement. By the way, this portal is convenient to use to gain access to the entire range of software from Oracle.
The first thing to do is to select the type of software from the drop-down list - in our case, “Hyperion Performance Management” (if new versions are required, it is called “Oracle Enterprise Performance Management” in connection with the rebranding). Version - 9.3.1, Windows 32 platform
You need to pick up 4 files - Olap Server, its client (for accessing data through Excel), the administrative console (for its work you will need a relational database (Oracle or Ms SQL), and the integration console is a tool for creating multidimensional storefronts (OLAP cubes) from relational sources.
These are the files V14762-01, V14763-01, V14782-01, V14792-01
Step two installation
The installation process is not a complex and meaningful action. "Wizards" adequately cope with the task, there are only three settings (system environment variables) that need to be set and checked after the installation process is completed
% ARBORPATH% = C: \ Hyperion \ AnalyticServices
% ESSLANG% = Russian_Russia.MS1251@Default
% HYPERION_HOME% = c: \ hyperion \
Step Three - Setup
To configure the software, you need to use the configurator program, which is located in the appropriate directory
In which, you need to consistently do the following
The registration point in the single authentication service - Shared Services is deliberately ignored, as it introduces “features”, and for studying OLAP integration with MS AD is an extra step.
Passing this wizard, we consistently answer questions, given that the default login and password in Essbase and EAS is admin / password
We leave the used ports by default
Then we indicate the type of database for the business rules storage in EAS
I use Oracle, but MS SQL 2000 sp4 / 2005 is better for tests.
Leaving the Tomcat Application Java Server
We agree with the proposal and complete the configuration
After the end of configuration, you need to start the EAS service and essbase
To test the functionality, you need to go to the EAS console, (admin / password) and open the Sample.Basic demo application.
Log in as Admin / password
connect essbase server
By the right button we load the data into Sample.Basic.
Calculate the cube
Result - can be viewed in Excel through Essbase SpreadSheet
What's next? - Oracle by Example!
At the moment (February 2011) the current version is 11.1.2, in which Oracle and Hyperion once again made a big step towards integration and complicated the application infrastructure at times. This version is suitable for those who are already familiar with the system and understand all the architectural features. The process of its installation is described in detail on thematic blogs .
I propose to use the previous version 9.3 for OLAP Oracle Essbase engine, which, in the OLAP kernel, is not much different from its older brother, since the process of setting up additional components in version 11 (which are loaded) can take quite a long time and resources.
')
Accordingly, the installation process can be divided into three stages.
- Getting “shareware” software
- Installation
- Customization
Step one
In order to get Oracle's new “conditionally free” software, I suggest using the EDelivery portal, where you will need to fill out a form and agree with the terms of the Oracle license agreement. By the way, this portal is convenient to use to gain access to the entire range of software from Oracle.
The first thing to do is to select the type of software from the drop-down list - in our case, “Hyperion Performance Management” (if new versions are required, it is called “Oracle Enterprise Performance Management” in connection with the rebranding). Version - 9.3.1, Windows 32 platform
You need to pick up 4 files - Olap Server, its client (for accessing data through Excel), the administrative console (for its work you will need a relational database (Oracle or Ms SQL), and the integration console is a tool for creating multidimensional storefronts (OLAP cubes) from relational sources.
These are the files V14762-01, V14763-01, V14782-01, V14792-01
Step two installation
The installation process is not a complex and meaningful action. "Wizards" adequately cope with the task, there are only three settings (system environment variables) that need to be set and checked after the installation process is completed
% ARBORPATH% = C: \ Hyperion \ AnalyticServices
% ESSLANG% = Russian_Russia.MS1251@Default
% HYPERION_HOME% = c: \ hyperion \
Step Three - Setup
To configure the software, you need to use the configurator program, which is located in the appropriate directory
In which, you need to consistently do the following
- Configure a relational source for the Essbase Administration Console
- Continue Tomcat for EAS
- Register Essbase as a Windows service
The registration point in the single authentication service - Shared Services is deliberately ignored, as it introduces “features”, and for studying OLAP integration with MS AD is an extra step.
Passing this wizard, we consistently answer questions, given that the default login and password in Essbase and EAS is admin / password
We leave the used ports by default
Then we indicate the type of database for the business rules storage in EAS
I use Oracle, but MS SQL 2000 sp4 / 2005 is better for tests.
Leaving the Tomcat Application Java Server
We agree with the proposal and complete the configuration
After the end of configuration, you need to start the EAS service and essbase
To test the functionality, you need to go to the EAS console, (admin / password) and open the Sample.Basic demo application.
Log in as Admin / password
connect essbase server
By the right button we load the data into Sample.Basic.
Calculate the cube
Result - can be viewed in Excel through Essbase SpreadSheet
What's next? - Oracle by Example!
Source: https://habr.com/ru/post/113523/
All Articles