5 Replies Latest reply: Mar 19, 2013 4:12 AM by Kaushik Solanki RSS

    How to do simple Slowly Changing Dimension?

      Hi,

       

      In my client, it was being requested to the slowly changing dimension, because they will only updathe the excel file once there's a change to any of the records, specifically to its numeric value.

       

      Say for example:

       

      As of 4/1/2012

       

      Item No.Item DescriptionAgreed Cover
      AApple3
      BBlackberry2
      CChico3

       

       

      And as of 6/4/2012

       

      Item No.Item DescriptionAgreed Cover
      AApple2.5
      BBlackberry2
      CChico3

       

      As of 8/1/2012

       

      Item No.Item DescriptionAgreed Cover
      AApple3
      BBlackberry2.6
      CChico2

       

       

      Note that, this is only one file (excel file)... And excel file will only be overwritten once there's change.

       

      Please help me on this. Your help is much appreciated.

       

       

      Thanks,

      Bill