Entries in Analysis Services (2)


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 ...



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 ...