Essbase - Sample Data Source TBC (The Beverage Company)

Essbase Overview


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 :

DEFAULT tablespace users
TEMPORARY tablespace temp
quota unlimited ON users; 
GRANT connect, resource TO EST_TBC;

Loading the schema

In the directory


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 - 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 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

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

Session is altererd.

SQL>-- Insert TBC Data:


Discover More
Tbc Product Dimension
Essbase - Consolidation Operator

The consolidations operator define the consolidation path and can be used in formulas. It defines how Essbase rolls up data for each member in a branch to the parent. Operator Representation Description...
Essbase Overview
Essbase - Consolidation Path

The definition of the consolidation operator define the consolidation path. The TBC application has several consolidation paths: Individual products roll up to product families, and product families...
Essbase Overview
Essbase - Getting Started - Tutorial

Oracle by Example Documentation Oracle...
Essbase Eis Tbc Dsn Odbc
Essbase - Integration Service - Setting up the TBC sample application

To set up the Beverage Company sample application in integration service, you have two possibilities : automatically manually Log in the Oracle Database and perform this statement ...
Essbase Overview
Essbase - Sample Applications

Essbase provides a set of sample applications and associated databases that you can use to learn Essbase features, and which are the basis for many of the examples given in the documentation. Sample...

Share this page:
Follow us:
Task Runner