Introduction

In this chapter, the first recipe Adding an application and database on an Essbase server is used to build the outline from a Basic.otl outline file, which is included in this book. This recipe is important as the Sample Basic database is used in the next five chapters. In the following five recipes, we will build and load the Sample Basic database using the Outline Editor and dimension build rules. Moreover, we will also discuss more intermediate topics such as creating and using substitution variables, applying If/Else logic, and creating Text and Date measures to name a few. In addition, we will touch on the more advanced topics of creating SQL load rules. Finally, we will build an Aggregate Storage database from a Sample.otl file and apply some MDX outline formula. You might be asking yourself, based on the first four chapters, why use Essbase Administrative Service (EAS) to develop Essbase databases? The most important reason is that it is the most matured development...