What is the default calculation order for ASO database?

Question

Options

• AAccounts, Time, all remaining dimensions in ascending order of member count
• BTime, Accounts, all remaining dimensions in ascending order of member count
• CAccounts, Time, all remaining dimensions in descending order of member count
• DTime, Accounts, all remaining dimensions in descending order of member count
• EDynamic hierarchies, Stored hierarchies
• FStored hierarchies, Dynamic hierarchies

• A
  2% (1)
• B
  3% (2)
• C
  2% (1)
• D
  7% (4)
• E
  14% (8)
• F
  73% (43)

Explanation

Aggregate storage calculation order and block storage calculation order differ. For aggregate storage databases, Essbase calculates data in the following order: 1.Aggregates members of stored hierarchies and attribute dimensions. The order in which members and dimensions are aggregated is optimized internally and changes according to the nature of the database outline and the existing aggregations... 2.Calculates dynamic hierarchy dimension members and formulas... Note: BSO calculations order: Third, remaining dense dimensions Fourth, remaining sparse dimensions Two Pass Calculation

No community discussion yet for this question.