Aggreagte awreness Issue

general discussion
1

Hi All,
I am facing some strange situation here.
I have two objects(Objects A & Object B) with aggregate awareness applied to it and 2 othe robjects as Object C & Object D
Object A(@aggregateaware (TableAA.FieldA,TableBB.FieldA,TableCC.FieldA)
Object B(@Aggregateaware (TableBB.FieldB,TableDD.FieldB,TableAA.fieldB)

Object C (TableAA.FieldC)

Object D (TableDD.FieldD)

Now when i have combination of few objects ObjectsA,ObjectB, Object C & Object D its not showing me value for ObjectB
It shows me ObjectB is incompitible with other objects (i.e. ObjectA, ObjectB, ObjectC)

Now as we know ideally aggregate awareness is going to choose the field from the corresponding fields but here for ObjectB it is not working

I have tried every permutaion and combination of selecting objects and confirmed that it only not working with ObjectB

Now when i change Aggregate awareness of ObjectB as
Object B(@Aggregateaware (TableAA.FieldB,TableDD.FieldB,TableBB.fieldB)
Then the combination of these objects A, B, C & D is working

Can anyone please explain me what might be the issue, except changing Aggreagte awareness this wont work.

Regards
Nirav

nniravv :india: (BOB member since 2007-08-16)

2

Can’t quite get my head round this without seeing it in front of me with joins.

Have you configured contexts and incompatibles for each of the aggregates? Can you write freehand SQL queries to extract data from all objects in the way you are expecting the universe to?

cashworth (BOB member since 2005-02-09)

3

Hi Cash
thanks for reply
Contexts and incompitables are all done as per required. The above mentioend scenarion was working few day sback without changin aggregate awareness, but all of a sudden its not working now so i have chnaged aggregate awareness sequence of tables

Thanks
Nirav

nniravv :india: (BOB member since 2007-08-16)