Essbase - Sample Data Source TBC (The Beverage Company)

About

TBC (The Beverage Company) is a database for a fictitious company of Essbase. It's used for sample purpose with :

Steps with Essbase Studio Scripts

Creation of the user

Connect as sysdba and perform this statement to create the user :

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

Loading the schema

In the directory

HYPERION_HOME\products\Essbase\EssbaseStudio\Server\sqlscripts

you will find all the installation scripts and the instruction for each database is in the file readme.txt

For oracle :

E:\>cd E:\Hyperion\products\Essbase\EssbaseStudio\Server\sqlscripts
E:\Hyperion\products\Essbase\EssbaseStudio\Server\sqlscripts>sqlplus EST_TBC/[email protected]

SQL*Plus: Release 11.1.0.7.0 - Production on Ma Dec 21 03:05:49 2009

Copyright (c) 1982, 2008, Oracle.  All rights reserved.


Connect with:
Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL>-- Create TBC tables
SQL>@tbc_create_oracle.sql
.......................
.......................
SQL>Alter session set nls_date_format='MM/DD/YYYY';

Session is altererd.

SQL>-- Insert TBC Data:
SQL>@tbc_sampledata.sql
.......................
.......................

Documentation/Reference


Powered by ComboStrap