Chapter 5. Using EAS for Development

In this chapter, we will cover the following topics:

• Adding an application and database on an Essbase server

• Using the outline editor to add dimensions

• Using dimension build rules to add parent-child dimensions

• Creating dimension build rules to add a base and attribute dimensions

• Using dimension build rules to add parents to attribute dimensions

• Creating load rules for flat file data loads

• Creating substitution variables

• Using If/Else logic and substitution variables in outline formulas

• Using Text measures on a BSO cube

• Using Date measures on a BSO cube

• Using different outline formula logic at the parent level

• Creating a load rule for SQL data load using substitution variables

• Using MDX in aggregate storage applications