Creation of the OLAP Metadat 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
Launch the wizard
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.