About
TBC (The Beverage Company) is a database for a fictitious company of Essbase. It's used for sample purpose with :
Articles Related
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/EST_TBC@ORCL
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
.......................
.......................