Introduction
In this chapter, we will continue with the The Beverage Company (TBC) sample database which we started in Chapter 2, Using Essbase Studio, with Essbase Studio, and we will conduct some of these same tasks using Essbase Integration Service (EIS). On the other hand, we will not be discussing the building of a Block Storage database in Essbase Administration Services (EAS) as these tasks are covered in Chapters 5, 6, 7, and 8.
The following is a summary of the application development steps in Essbase Studio:
Prep Data Source
Create Data Source Connection
Create minischema, user-defined tables, and add joins
Select data elements
Create or modify metadata elements, date elements, and hierarchies
Create alias tables
Create Essbase schema and Essbase Models
Set Essbase properties
Build drill-through reports
Deploy Essbase cubes
Building an Essbase application in EIS will require some of the same steps but these tasks can be accomplished within the OLAP Model and OLAP Metaoutline in contrast.
