hierarchy with weight

[adiarnon]

hi my hierarcy looks like-

node	parent	weight
X1	X	2

the weight-

the number i need to multiply the value in the fact if I WANT TO GET THE VALUE OF THE PARENT

if im using the hierarchy and hierarchybelongto

how can i do this logic?

tnx, adi

[adiarnon]

?

[Gysbert_Wassenaar]

Perhaps this blog post helps: Bill of Materials

[adiarnon]

the account dimention (hierarcy) looks like-

ACCOUNT	ACCOUNT parent	weight
X1	X	2

my fact table-

YEARMONTH	ACCOUNT parent	AMOUNT
201512	X1	10

the amount of X (PARENT) should be 20 (10*2)

the weight-

the number i need to multiply the amount in the fact if I WANT TO GET THE VALUE OF THE PARENT

to built the account dimention im using the hierarchy and hierarchybelongto

how can i do this logic?

tnx, adi

[adiarnon]

?