Good Evening, i want to ask about Hierarchy ini Qlikview,
I have 2 type of product hierarchy :
1. Old Product Hierarchy that i define the start_date_history on '01/01/2000' and end_date_history on '31/12/2018'
Old Prod Hier have 3 Levels of Hierarchy;
2. New Product Hierarchy that i define the start_date on '01/01/2019' and end_date on '31/12/2999'
New Prod Hier have 10 Levels of Hierarchy ;
so in this case those 2 different Old Prod Hier and New Prod Hier , i combine those 2 and, store into PRODUCT_HIERARCHY.QVD(qvd),
after that i want to connect those dates that i defined with company transactional dates, without using any interval match,
my concern is, if i have a large amount of product hierarchy data, then what is the best practice to reach the best optimization to load the data ?
My final expectation for the result is, when i choose the date on 12-12-2018, it will associate with the Old Product Hierarchy, and when choose the date on 12-01-2019, it will associate with the New Product Hierarchy.
Dear Pedro, Thank you for your help, i tried your option number 2 but the data increase too much, i didn't know why interval match did that, so i avoid to use it. Maybe you can help me with the 3rd option ? Thank you , Jason
I made an app wich contais a 3rd option, its derivate from IntervalMatch and create a Concatenate Key in the FactTable to connect a ProductHierarchy Table, so you don´t need a BridgeTable and the performance remains good.