Former Member

1 characteristics in different aggregates

Hi,

Can someone explain me the following,

Say we have a characteristics A, B, C in an infocube, and we have built 3 aggregates on that infocube.

1st Aggregate contains Characteristics A

2nd Aggregate contains Characteristics B

3rd aggregate contains Characteristics A and C

My question is why do we need to add a single characteristics in two different aggregates ??

And when we do a change run for suppose A, both the 1st and 3rd Aggregate will be captured rite??

Points will be rewarded.

10|10000 characters needed characters exceeded

Related questions

Former Member
Posted on Jan 29, 2008 at 05:38 AM

Hi,

No i dont think that if u run a change run for suppose A then Both the Aggregates 1st and 3rd would get captured.

Only 1st aggregate will be captured because the 3 rd aggregate is the combination of A and C

u need to run a change run separately for all the 3 aggregates.

" My question is why do we need to add a single characteristics in two different aggregates ?? ''

i think ur Bussiness requirements would be like that.

thanks,

Nagesh

10|10000 characters needed characters exceeded
• Former Member
Posted on Jan 29, 2008 at 06:19 AM

If there is a change in the master data of the characteristics A then how does the data get stored...in 2 different aggregates....is it like the data in both the aggregates is the same......or is it like half the data is in one aggregate and half is in the other 1

BCoz if same data is present in both the aggregates then its enough to capture 1 aggregate in the changerun

also when a query is executed it referes all the aggregates for the output rite?? so is like it refers 1st aggregate for A and 3rd aggregate for A and C.....

i m a bit confused...and would appreciate if someone helps me understand the complete process

Thanks

10|10000 characters needed characters exceeded
• Former Member

Hi,

Look Aggregate are build on Master data. u have aggregates build on "A", "B", "A and C"

if there is a change in Master data For " A"

Then when u run the change run for Aggregate build on "A" the change will be reflected in Aggregate "A"

and if u dont run change run on Aggregate build on " A and C"

then the change of master data "A" wont be reflected in Aggregate "A and C"

To reflect this change u need to run the change run For Aggregate " A and C"

Thanks,

Nagesh

Edited by: Nagesh Mule on Jan 29, 2008 7:29 AM

• Former Member
Posted on Jan 29, 2008 at 09:27 AM

Dear Mugdha

If you run Aggregate one, that character will refer in all the places where you are using that object.

Hence, aggregates are based on the object level, not how many times you are using.

According to my point the aggregated value for Object1 has to populated with newly loaded data even though object 3 is not validated with "Change Run". (But here you can't get object3 data)

Friends, Please correct me, if i am wrong

Regards

Raju Saravanan