Entries Published On 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 the cube and establishing a …
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 the factless fact table for …