SSAS Articles Management UPDATE CUBE in subcubes
UPDATE CUBE in subcubes
User Rating: / 0
PoorBest 
Written by Michel Caradec   
Thursday, 20 March 2008 03:55

Excerpt from BOL: "subcube is a subset of a cube on representing a filtered view of the underlying data".

Subcubes can be used for different purposes:

  • Simplify user navigation by displaying only needed cube items.
  • Improve query performance by limiting query evaluation space.

Implementing security

Subcubes can be interesting for implementing application-level security, similar to dimension security (I talked about this in a recent article dedicated to SSAS 2008 personalization extensions).

Read more...
 
Strategy Companion