Report Portal

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...

Tags: design, dimension

 

2007-2015 VidasSoft Systems Inc.