Essbase - Integration Service - Setting up the TBC sample application

Essbase Overview

About

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

  • automatically
  • manually

Steps with the Automatic process

Creation of the OLAP Metadat Catalog

Essbase - Integration Services - OLAP Metadata Catalog

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;

Create a Data Source Name ODBC

ODBC - How to create a DSN connection in Windows

Essbase Eis Tbc Dsn Odbc

Launch the wizard

Essbase Eis Create Sample Wizard

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

Creation of the TBC sample database

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;

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.

Creation of the TBC_MD OLAP Metadata Catalog

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

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

Documentation / Reference





Discover More
Essbase Overview
Essbase - Sample Data Source TBC (The Beverage Company)

TBC (The Beverage Company) is a database for a fictitious company of Essbase. It's used for sample purpose with : integration service : How to set up the TBC sample application ? Connect as...



Share this page:
Follow us:
Task Runner