Forum Discussion

Nissa23's avatar
Nissa23
Helper I
2 years ago

How to display my visual with SCD Type 2 data

Hi,

I've done many reaserch before asking my problem here.

I've built my report with a first version where I don't have changes in my dimension table. 

Now, I need to change it in order to take in account the slowly changing dimension. 

I've created 3 new columns : start_date and end_date, and a 'Current' column with values : 0,1.

I want in my report to keep the historical visualisation. I don't know how to do it?

Can anyone help me with an idea?

Thanks