12th September, 2018
Hyperion Essbase architecture Hyperion Essbase follows 3-tier architecture. It contists of 3 layers.Hyperion Essbase Architecture
Database Tier : (Analytic Server) One or more Analytical servers that store and process multi dimensional DB information. Client Tier : (Essbase Administration services console, EAS console) A Java-based client console that provides user interface to manage the analytic service environment. Middle Tier (EAS Server) : One or more Analytic Servers store and process multi dimensional database information. Analytic Servers are installed separately from Administration Services. A version EAS server, Essbase server and EAS Console and in version 9.3,all these are called AAS server, analytical server AAS console AAS server Analytical Server And AAS console can be on single machine or they can be on separate machine .AAS server or ESSBASE server can also be installed on windows/AIX platform. Apart from these Hyperion shared services server and Hyperion licensing server were also there in version, but we need not install these servers in version 7. In version seven we can use either licensing file or licensing sever. APPLICTION AND DATABASES:- An applications is a folder structure that contain one are more analytic services databases and related files. Analytic services applications and databases usually reside on the Analytical server . the server computer can store multiple applications. To create application, log on to Essbase server using AAS console through AAS server
When an application is created, a folder get appeared on the server under the following path. ARBORPATH/app/ ARBORPATH:- when Essbase software is installed on the Essbase server, Essbase path gets created. This path is called ARBORPATH. To seethe ARBORPATH, Right click on the Essbase server And click Edi properties, click environment tab ARBORPATH will be seen. EX:c:/Hyperion/analytic services DATABASE: A database is a folder that contains objects such as outline, rules files, calculation script, report scripts and multi dimensional data. To create Database: Double click on the applications and right click on database . Enter the database name can take a maximum of 8 characters for non-uni-code applications. If it is uni-code application the name of the database can take maximum of 30 characters. The database can be created in the following calendar. ARBORPATH/APP/app-name/ OUTLINE:- As soon as Database is created. Double click on the outline and click add children to add dimensions. Outline consist of hierarchies. A Dimension consist of members . A Hierarchy is nothing but structural relationship among members. It gives parent child relation ship among members. The out line will also gives consolidation operators. The file is stored with OTL extension under the following path. ARBORPATH/APP? app-name/database name/databasename.otl The name of the outline can be changed only by re-naming the database the name of the outline can not be changed directly.
RULES FILES:- Rules files are used to build the dimensions and to load data into Essbase database. rules files are stored with .RUL extension on the server in the following path . ARBORPATH/APP/app-name/*.RUL
Building dimensions using rules files:- We can create the hierarchies in the outline manually or using rules files. there 3 ways to build rules files.
Generation reference method(using notepad or excel as data source) Make sure the source is ready. A sample file to build geography dimension is as below. The fields are separated By TAB (delimiter). The delimiter can be changed to any other value(explained later) INDIA SI AP INDIA SI TN INDIA NI UP INDIA NI DELHI
The number will increase to 3. Repeat the process for all columns .
Once the rules file is created ,double click the outline, click outline> update outline. Another screen appears. Click find data file .locate the source file click find rules file and locate the rules file. Select overwrite check box. Click OK. NOTE:-After creating the rules files, “rules files” also appears under the database . Level reference method:(using notepad or excel as the data source) Make sure the source is already . A sample file to build geography diversion is as below The fields are separated by TAB (delimiter)the delimiter can be changed to any any other value(explained later) AP SI INDIA TN SI INDIA UP NI INDIA DELHI NI INDIA NOTE:- the order of the fields in the source file for the level reference method is opposite when compared with generation reference method.
Once the rule file is created double click the outline ,click, outline->update outline Another screen appears. Click find data file .locate the source file .click find rules file and located the rule file. Select overwrite check box. Click OK Parent child reference method:(using notepad or excel as the data source) Make sure the source is ready. A sample file to build geography dimension is as below the fields are separated by TAB (delimiter) the delimiter can be changed any other value.(explained later) INDIA SI INDIA SI SI AP SI TN NI UP NI DELHI The source file contains minimum TWO fields
Once the rules file is created, Double click the outline, Click, Outline-> update outline. Another screen appears. Click find data file. Locate the source file. Click find rules. File and located the rules file. Select overwrite check box. Click OK. Handling de-limiters: If the delimiter in the source file is tab, then the rules files can handle the delimiter as the default delimiter is tab. If the source file contain any other de-limiter, other than tab, for example comma(,)etc. To modify the delimiter,
Handling Header records in the source file: Some times the source file may contain header records or comment records for information purpose. To ignore these records,
Building Dimensions from SQL DB:
Select control panel Double click on the Administration Tools. Double click on Data sources(ODBC) Click System DSN. Click add button. Select the appropriate ODBC driver. Click Finish Another screen appears. Enter a DSN name. For Oracle enter the TSN name(also called host string). In the lab, it is ORCL.
Double click the outline->update outline. Select type as SQL and enter username and password for database (for example scott, tiger) .click find rules file and locate the rules file. click overwrite check box . click OK.
TekSlate is the best online training provider in delivering world-class IT skills to individuals and corporates from all parts of the globe. We are proven experts in accumulating every need of an IT skills upgrade aspirant and have delivered excellent services. We aim to bring you all the essentials to learn and master new technologies in the market with our articles, blogs, and videos. Build your career success with us, enhancing most in-demand skills .
Write For Us