Skip to Content
author's profile photo Former Member
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.

Thanks in advance

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • Best Answer
    author's profile photo Former Member
    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.

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    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

    Add a comment
    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

  • author's profile photo Former Member
    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

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.