Chapter 1. Understanding and Modifying Data Sources

In this chapter, we will cover the following topics:

• Setting up an Account or Measures dimension with a parent-child reference

• Setting up dimensions with a generation reference

• Adding columns for outline formulas

• Adding the Solve Order column to tables that have ASO formulas

• Adding and populating the Sort Order Column

• Adding tables for varying attributes

• Determining hierarchies in relational tables

• Using the Essbase Outline Extractor to extract dimensions

• Using Star Analytics to build your star schema from existing Essbase cubes