Aggregate Aware Function

Is it possible to to have the following object definition in Designer @Aggregate_Aware(sum(ODS_FACTS_AGG.NET_REVENUE_THIRD_PARTY),sum(@Select(Reve nue\X)-@Select(Revenue\Y)))

I am getting ‘Parse Failed:Nested @ Aggregate Aware Function’. Am I doing anything wrong or BO does not allow ‘Select’ inside Aggregate Aware ?


Listserv Archives (BOB member since 2002-06-25)

In a message dated 00-03-07 07:34:58 EST, you write:

I am getting ‘Parse Failed:Nested @ Aggregate Aware Function’. Am I doing
anything wrong or BO does not allow ‘Select’ inside Aggregate Aware ?

As far as I know, you cannot use @select inside of an @AggAware. I have not tested this in v5 yet, but I believe that was the case in v4.

Regards,
Dave Rathbun
Integra Solutions
www.islink.com


Listserv Archives (BOB member since 2002-06-25)