Tag Archives: OLAP cube

Common Latest Period in SSAS Cube

Posted on January 27, 2015 by

Recently I came across a situation where data was being delivered at different times for different countries and client wanted to see data for latest common month in Region/Continent level reports. Data arrive on monthly basis, but it arrives at different … Continue reading →

Posted in MDX, SSAS (Analysis Service), Cube | Tagged , , , , , , , | Leave a comment

Slowly Changing Dimension in SSAS Cube

Posted on November 28, 2014 by

  This is a simple example of SCD (Type-2) in OLAP cube.  We have a Dimension table for Employee and their Departments. This dimension is an SCD. One employee worked in different department over the course of time. EmpID is … Continue reading →

Posted in MDX, SSAS (Analysis Service), Cube | Tagged , , , , , , , | Leave a comment