Changing hierarchy

Wed, 09 Jan 2013 06:42:55 GMT

Hi!

Hierarchy is changing and history information is given with from to.

In this very small example MATS has changed his AREA to 3 from 2.

Hierarchy from to

HQ-DIV1-AREA2-MATS 1.1.2010 11.1.2012

HQ-DIV1-AREA3-MATS 12.1.2012 NULL

HQ-DIV1-AREA4-JACK 1.1.2010 NULL

HQ-DIV2-AREA1-JIM 1.1.2010 NULL

How you have implemented this kind of changing hierarchy in QV.

IF user selects in application MATS, user should get all MATS data.

IF user selects AREA2 (and MATS) only data from 1.1.2010 --> 11.1.2012 from MATS should be as a result.

I know how to implement static hierarchy with hierarchy load. But this changing hierarchy is problematic for me.

Thank you for your time, BR.

-Harri

Re: Changing hierarchy

Wed, 09 Jan 2013 07:50:01 GMT

Do u have particular field for Mats and Area2 like Name and Place?

~kabilan K

Wed, 09 Jan 2013 10:49:42 GMT

Hi!

Yes every level of the hierarchy has it's own column (or name) in QV-table. Hierarchy was just shown like

HQ-DIV1-AREA2-MATS in my text. In real application this information is in 4 columns.

BR,

Harri