Essbase - Integration Service - Setting up the TBC sample application

1 - About

To set up the Beverage Company sample application in integration service, you have two possibilities :

  • automatically
  • manually

3 - Steps with the Automatic process

3.1 - Creation of the OLAP Metadat Catalog

3.2 - Creation of the schema

Log in the Oracle Database and perform this statement


CREATE user TBC IDENTIFIED BY TBC
DEFAULT tablespace users
TEMPORARY tablespace temp
quota unlimited ON users; 
 
GRANT connect, resource TO TBC;

3.3 - Create a Data Source Name ODBC

3.4 - Launch the wizard

4 - Steps with a manually process

It seems that the last release of Essbase doesn't provide the file anymore. You will find then here: Tbc.zip

4.1 - Creation of the TBC sample database

4.1.1 - Creation of the user


CREATE user EIS_TBC IDENTIFIED BY EIS_TBC
DEFAULT tablespace users
TEMPORARY tablespace temp
quota unlimited ON users; 
 
GRANT connect, resource TO EIS_TBC;

4.1.2 - Creation of the table and load of the data


C:\Documents and Settings\Administrator>cd E:\Hyperion\products\Essbase\eis\server\samples\tbcdbase

C:\Documents and Settings\Administrator>e:

E:\Hyperion\products\Essbase\eis\server\samples\tbcdbase>install_oracle.bat EIS_TBC EIS_TBC ORCL
.
Creating tables.
Loading fact table.
Done.

4.2 - Creation of the TBC_MD OLAP Metadata Catalog

The script is located in the ocscript directory. See Creating Tables for the TBC_MD Database.

4.3 - Import of a sample OLAP model and metaoutline

XML files for importing a sample OLAP model and metaoutline in the TBC_MD OLAP Metadata Catalog database. These XML files are located in the samples\tbcmodel directory.

See Using the XML Import Utility to Load Data into the TBC_MD Tables

5 - Documentation / Reference


Data Science
Data Analysis
Statistics
Data Science
Linear Algebra Mathematics
Trigonometry

Powered by ComboStrap