Entries in Analysis Services (2)

Sunday
May302010

Many-to-Many Dimensions, How Scalable?

SSAS introduced the concept of many-to-many relationships between dimensions, an outstanding development that partially overcomes the rigidity of strict star/snowflake schemas. But with this feature came all sorts of warnings from Microsoft.

Click to read more ...

Wednesday
Oct292008

Drillthrough

It's rare that a cube will contain transaction details. So once a user drills down to the bottom of a cube, it's common to want to see the transactions that comprise a given value. That's what drillthrough is for, or at least that was the case in the old days.

Click to read more ...