…brew your own Business Intelligence

Archive for March 2014

MDX: Scope and Precedence for Calculated Members and Sets

With calculated members and calculated sets, there are 3 primary levels of scope: Global: calculated members and sets defined at this level (in the MDXScript of the SSAS cube) are available to all queries Session: calculated members and sets defined at this level (as a standalone statement executed after connecting […]

Read more

A Closer Look at the Coverage Fact Table

One of the more interesting types of fact tables is the factless fact table for conditions – also known as Coverage Fact table by Kimball purists. I was recently reminded of this type of fact table while reading Star Schema: A Complete Reference in which Chris Adamson (b | t) describes […]

Read more