Hierarchy Vs Text

[vishnumusani]

HI,

I have 3 tables namely as below. I want build a hierarchy model but here Hierarchy Data and its text data both are time dependent. I am able to achieve Time dependency between Hierarchy & Transaction table but not able to do same thing with its Text table to get its text information.

Transaction:

Date               Key            Count

01-01-2015       M1               4

01-12-2014       M1               6

Hierarchy:

Hier        From            To

M1         1-12-2014    31-12-2014

M1         1-01-2015    31-01-2015

hierarchyText

Hier        From            To                    Name

M1         1-12-2014    31-12-2014           N1

M1         1-01-2015    31-01-2015           N2

Could anyone please help me on this.

Thanks,

Vishnu

[settu_periasamy]

Can you give the expected Output?

Do you mean "Hierarchy Text " table contains the text information?

if so, you can convert your From and To Field to Date field, right?

Like

Date(Date#(From,'DD-MM-YYYY)) as From,

Date(Date#(To,'DD-MM-YYYY')) as To

[vishnumusani]

Transaction table consists of transaction data.

Hierarchy table consists of multiple hierarchies which are going to be varied with respect to time

Text table consists of text information of those hierarchies which are also going to vary based upon time

Expected Output

For a particular month we need to build a tree hierarchy and we need to get the text information for all those tree hierarchies

if i select Jan Month Hier name should come as "N2" If its december it should be "N2" like this it needs to happen for entire hierarchy structure based upon the month selected.

Node1	Node2	Node3	No Of Emp
ROOT	Hier	Hier1	42
		Hier2	6
		Hier3	3
		Hier4	6
		Hier5	6
		Hier6	3

Thanks,

Vishnu.