This content has been marked as final. Show 2 replies
I have a model where i have a slowly changing dimension called CATEGORY which takes the following changing values;
A product's CATEGORY can change from say SECTION 75 IMPORTS to NORMAL IMPORTS, or from NORMAL IMPORTS to IMPORT - LOCAL etc.
I initially had the model without Slowly Changing Dimension but remodelled it with SCD as per the attached qvw document. The model is consistent for the months of January, February, March and April with the % Value and actual values of the above categories staying in a consistent range. However, for the month of May, all values are very low when compared to the historical values.
I then remodel the application with no slowly changing dimension and the values of May become consistent with those of Jan, Feb, Mar and Apr as follows:
Where could i be going wrong with my model? Your assistance will be greatly appreciated.