1 Reply Latest reply: Jan 27, 2015 11:06 AM by Juan Gerardo Cabeza Luque RSS

    How to implement Slowly Changing Dimension Type 2 with QlikView Expressor

    Christian Vogg

      Hi Community,

       

      do someone of you know how to implement Slowly Changing Dimension Type 2 with QlikView Expressor?

      My Source is a SQL Server table and the destination is QlikView or more precisely a QVX file. This QVX file is for example the Product Dimension and within this the history should be visible. The Surrogate Key is in this case ProductKey and is handled with Expressors 'utility.sequence()'-function. Maybe also with the start and end time intervall in each record.

      Have someone an idea how to implement this scenario?

       

      Greetings

      Christian