what is the default calculation order when performing a database consolidation?


If a database includes a dimension tagged as Accounts and a dimension tagged as Time and if formulas are applied to members on the Accounts dimension, Essbase calculates in the following order:
• First, the dimension tagged as Accounts, whether dense or sparse
• Second, the dimension tagged as Time, whether dense or sparse
• Third, other dense dimensions (in the order that they are displayed in the database outline)
• Fourth, other sparse dimensions (in the order that they are displayed in the database outline)
• Fifth, two-pass calculations (if selected in the database settings)

Comments