Is there a way to use aggregates in complex filters?
hans
Listserv Archives (BOB member since 2002-06-25)
In a message dated 99-03-30 08:58:57 EST, you write:
Is there a way to use aggregates in complex filters?
The short answer is: nope.
The long answer is: because aggregates are calculated after filters are
applied, there is no way to have an aggregate done before a filter, and
therefore aggregate functions are invalid in a filter.
It’s sort of a chicken-egg-chicken paradox. You can’t do filters until you
aggregate. And you can’t aggregate until the filters are applied. So BusObj
generates an error message if you try to use an aggregate in a filter to
prevent this from happening.
Please note: this information is a guess on my part, I don’t know if it has
ever been confirmed by BusObj tech support or the programming team. But I
believe that this is, in fact, a valid explanation.
Regards,
Dave Rathbun
Integra Solutions
www.islink.com
Listserv Archives (BOB member since 2002-06-25)
The funny thing is, the filter is real simple: ( < 0.25), The
Calculations of Maring however is quite hairy. It is a, IMO, a majer
flaw in BO is this is not possible. Excel could do such a thing. Btw
when is a filter a “complex” filter
hans
Is there a way to use aggregates in complex filters?
The short answer is: nope.
The long answer is: because aggregates are calculated after filters
are
applied, there is no way to have an aggregate done before a filter,
and
therefore aggregate functions are invalid in a filter.It’s sort of a chicken-egg-chicken paradox. You can’t do filters until
you
aggregate. And you can’t aggregate until the filters are applied. So
BusObj
generates an error message if you try to use an aggregate in a filter
to
prevent this from happening.
Listserv Archives (BOB member since 2002-06-25)