File Library

How ASO Works and How to Design for Performance
Topic: Kscope13 Recordings
Owner: Daniel Pressman
Date: 2013-08-02
Subtopic: Essbase

Why are some cubes fast and some are slow? When is it OK to use MDX and when should (or what types of) MDX be avoided? How do Solve Order, Dynamic, and Stored Hierarchies interact?

By understanding how Essbase goes about resolving a query, many of these questions will answer themselves. Much of this understanding comes from the cryptic Bitmap Statistics dialog in Cube Properties. All of this is summarized in 12+1 rules. These 12+1 rules are discussed and used to illustrate how they should be used when designing your cubes.

In particular, there are implications and options for the design of alternative hierarchies. These options will be discussed in terms of the trade-offs of cost (in storage size) vs. performance (in retrieval time). Concrete examples will be demonstrated.

Download File   DPressman.HowASOWorks_KScope13.pdf
Download File   Grand Ballroom D Session 09.mp4

Become a member of ODTUG to gain access to more than 12,500 files in our technical database.

  • Not a member? Click through to the topic of interest to browse a list of available presentations.
  • Already a member? Log-in here to access the full database

Click here to see the Full Techincal Resource Database