Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Hi,
I just wanted to check this is dummy data and not sensitive as it looks quite full on....
Can you give us an idea of what values you are expecting? Lets focus on one particular value for now, break down the expression and the data model and see whats going wrong
Thanks Adam
This is real data. The expected values are as follows:
Managed to solve my problem