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: … Continue reading MDX: Scope and Precedence for Calculated Members and Sets
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 … Continue reading A Closer Look at the Coverage Fact Table