Hierarchy and Slowly Changing Dimensions

[#1]

Hi,

I have a problem with organization hierarchy.

Organization table is joined to link table with interval match (this link is working OK)

main problem is that in d_organization table I have multiple rows with same ID

Organization_id	Name	scd_start_date	scd_end_date
1001	Name 1	01.01.2012	10.12.2012
1001	Name 1	11.12.2012	31.12.2014
1001	Name 2	01.01.2015	31.12.9999

How can I create Hierarchy with hierarchy()-funktion so that it's working properly with slowly changing dimensios?

At the moment Name 1 and Name 2 are both always active

cheers,

Tommi

[Gysbert_Wassenaar]

Did you select a date? Otherwise, how should Qlikview know which organisation records should be shown?

[#3]

Yes, I have selected a date

[Gysbert_Wassenaar]

Can you post a qlikview document that demonstrates the problem? Read this document if you're worried about confidential information: Preparing examples for Upload - Reduction and Data Scrambling