Nested @aggregate_aware functions are not supported. (IES 01002)

[Former Member]

Hello,

I have been working on a issue related to @AggregateAware for a particular object.

Previously we had .unv universe and there was an object with @AggregateAware function having just one parameter and it was working fine.

The .unv universe is now converted to .unx universe and the same object is now throwing an error "Nested @aggregate_aware functions are not supported. (IES 01002)"

When i remove the @AggregateAware function then the object works fine.

Is anyone aware of the actual cause of this issue and what should be the ideal approach for the same?

[former_member193452]

Hi Mandar,

Check your SQL, it may require adjustment for nested Aggregate Awareness

for example

@Aggregate_Aware( (Sum(table1.MyAMOUNT)*@Select(Timeref\YTD Ref)), Sum(Table1.MyFACT.AMOUNT))