15 Dimension Build Examples

The build method you should use to load dimensions to an Essbase outline depends on the type of data in the source system. Design your load rules with the build method in mind. Build methods determine the algorithm that is used to add, change, or remove dimensions, members, and aliases.

All examples in this chapter are based on the Sample.Basic database.

• Understanding Build Methods

• Using Generation References

• Using Level References

• Using Parent-Child References

• Adding a List of New Members

• Building Attribute Dimensions and Associating Attributes

• Building Shared Members by Using a Rules File

• Building Duplicate Member Outlines

All examples in this chapter are based on the Sample.Basic database, which you can create using the Block Storage Sample (Stored) sample application workbook (Sample_Basic.xlsx). See About Application Workbooks.