Essbase - Sample Data Source TBC (The Beverage Company)

Essbase Overview

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/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
.......................
.......................

Documentation/Reference





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