6 Setting Dimension and Member Properties

When you tag an Essbase dimension as a specific type, such as accounts, time, or attribute, the dimension can access built-in functionality designed for that type. You can set member properties to specify member consolidation, how data values are stored, member aliases, and UDAs. You can also create member formulas.

• Setting Dimension Types

• Understanding Member Consolidation Operators

• Determining How Members Store Data Values

• Setting Aliases

• Setting Two-Pass Calculations

• Creating Formulas

• Naming Generations and Levels

• Creating UDAs

• Adding Comments to Calculation Scripts

• Member IDs

Some information in this chapter applies only to block storage databases and is not relevant to aggregate storage databases. Also see Comparison of Aggregate and Block Storage.