O'Reilly logo

Oracle Essbase 11 Development Cookbook by Jose R. Ruiz

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Creating an OLAP Model in EIS

In this recipe, we will build an OLAP Model using Essbase Integration Services (EIS). The EIS environment has some similarities and many differences when compared to Essbase Studio. To begin, we will have to set up an ODBC for the connection to the TBC database created in the first recipe of Chapter 2. The metadata catalog needs to be created before using EIS. The metadata catalog is created when you first install EIS or can be create by following the instructions in the Oracle Essbase Integration Service Adminstrator's Guide at the following link: http://download.oracle.com/docs/cd/E17236_01/epm.1112/eis_sysadmin.pdf. That said, the Essbase Studio minischema and the OLAP Model in EIS are very similar in practice. ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required