on 01-29-2008 5:24 AM
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.
Thanks in advance
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.
and about this question
" 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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
User | Count |
---|---|
80 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.