QlikConnect Articles

Entries for August 2010

26

Slowly Changing Dimensions Type2 example

QlikConnect posted on August 26, 2010 10:33

Hi Everyone, In this article we will provide you with an example on how to create slowly changing dimensions in QlikView and preserve the history o...

[Read the rest of this article...]

Posted in: Dimensional Modeling

Actions: E-mail | Permalink | Comments (0)

| Kick it! | DZone it! | del.icio.us

18

Role playing date dimensions

QlikConnect posted on August 18, 2010 11:34

In the past we have created an example on how to overcome the challenge of building a date dimension table that also contains reporting periods of 4 w...

[Read the rest of this article...]

Posted in: Dimensional Modeling

Actions: E-mail | Permalink | Comments (0)

| Kick it! | DZone it! | del.icio.us

10

Recording history in a dimension table (Slowly Changing Dimension)

QlikConnect posted on August 10, 2010 17:39

Recently we spotted some scripts that were trying to incorporate history in the dimensions by creating Slow Changing Dimensions (SCD). It appeared tha...

[Read the rest of this article...]

Posted in: Dimensional Modeling

Actions: E-mail | Permalink | Comments (0)

| Kick it! | DZone it! | del.icio.us