hierarchy(DrillUp and Drill down) result problem

[Former Member]

Hi All,

I am having tables in my database like

Desk Ammount

1 10

2 60

3 20

Desk Charm Ammount

1 a 5

1 b 7

2 c 10

2 a 8

2 b 5

-

---

-

---

here I would like to make hierarchy for Desk--->Charm, but my problem is ammount at Desk "1" is 10 at firstlevel and 5,7 at Charm should not produce summarise result but I am getting 12 at desk level.

Please help me.....

Thanks

[Former Member]

Hi All,

is there any solution to this issue?

please if you can help me

Thanks

[Former Member]

You can assign hirerchy but for the Measure Amount, first create @Aggregate_Aware funtion and set the compatibilty.

After that use that measure with whatever hirerchy you want. That will not sumarized your data.

Here you want to retrieve data from a 2 different table and both has different value for Amount that is why it is summing up your data.

Go throuh the desinger pdf for how to create @Aggregate_Aware.

[Former Member]

Hi srrachna,

thanks for your quality help

I have tried with aggregate_aware and set up incompatible objects but no luck I am getting duplicate measure at charm level

like

Desk amount

1 10

Desk Charm amount

1 a 10

1 b 10

Please help me on this the query doesnt go for amount at charm table when I am performing drill down

Thanks

Edited by: Satish Raju Kalidindi on Mar 15, 2011 2:12 PM

[Former Member]

Hi All,

is there any solution to this issue?

please if you can help me

Thanks

Edited by: Satish Raju Kalidindi on Mar 21, 2011 7:52 AM

[Former Member]

Can you please share the aggregate_aware formul;a you have created with us, if possible for you.

[Former Member]

Can you please share the aggregate_aware formul;a you have created with us, if possible for you.

[Former Member]

Hi srrachana,

please find the below function for aggregate function

aggregate_aware(Desk.amount,Charm.amount)

Thanks

[MariannevL]

Hi Satish,

Looking at your plain data without any knowledge of the structure I would make the same mistake as Webi.

Shouldn't the sum "of the parts" be the same as the "sum of the parts"?

I guess this means they are retrieved from a different table (aggregate awareness may be) and there are some duplicate amounts if you look at the desk/charm level. Setting the amount to data base delegated could help here,

because the value for the level desk will be retrieved separately from the value on the level desk/charm...

Good luck,

Marianne

[Former Member]

Thank You Marianne,

I have tried with aggregate_aware but no luck.

please if you can elaborate the data base delegate process.

Please help me.

Thanks inadvance