Slowly Changing Dimension Type 2 in SSAS Dimension
In the world of BI, everybody must be familiar with slowly changing dimension. There are three types of changing dimensions namely Type 1 (where the attributes are overwritten), Type 2 (history is preserved) and Type 3(limited history is preserved in additional columns).
And when it comes to creating a SSAS dimension, we need to take care of few things like
Read more...