I have 2 objects defined in a universe where they have conditions along with the select. I have also defined aggregate awarenss rules so that only one of the object is picked up automatically based on the join context. When I select the object in the query, the sql code does not pick up the “conditions” defined in the object. It is picking up the “select” clause only. Is there a limitation on aggregate awareness rules or I am missing something?
Thanks Reema… It looks like there is a limitation on defining the aggregate awareness rules as it does not pick up the conditions defined in where clause…