When are aggregates not used???

[Former Member]

Hey All,

I have a question concerning aggregates and when they get used. I have a user running a query and specifiying values in the selection criteria for the following:

- Sold-to Party

- Distribution Channel

- Site

- Condition Type

- Calendar Week

All 5 of these Characteristics are part of the new aggregate I build. I guess I don't understand why the aggregate is not being hit, if they're reporting on the exact same Characteristics that are part of my aggregate.

Can anyone explain????

Much appreciated.

John

[Former Member · Accepted solution]

Run the query through RSRT in debug mode and check the aggregate usage to see whether your aggregate does contains all the filter fields in the query.

or

If any CKF or RFK in the query uses "Before Aggregation" the query can't use aggregate.

[Former Member · Accepted solution]

Hi Rick,

Where do I check to see if "Before aggregation" is turned on in a query.

Thanks,

John

[Former Member · Accepted solution]

Actually, I checked out the query definition and there are no CKF or RKF used.

[Former Member · Accepted solution]

John,

For an aggregate to be used all of the following have to be true:

InfoObjects in the Rows must be included in the aggregate

InfoObjects that have restrictions on them (Rows, Filters, FCs, KF Columns) must be included in the aggregate

InfoObjects that are referenced as part of exception aggregation

No Virtual KFs in the InfoProvider

No 'Before aggregation' calculations on the CKFs

I believe that is the complete criteria.

[Former Member · Accepted solution]

Hey All,

I believe I figured out the issue. I have identified one characteristic that should be part of this aggregate, that isn't. I've done some testing and that proves true.

I appreciate everyone's help.

Thanks,

John

[Former Member]

Run RSRT and select " Display aggragate found".

First of all, make sure your aggregate is active and rolled up.

Ravi Thothadri

[Former Member]

Hi,

The aggregate is active and filled, since it's in a Production system. When I run the query through RSRT, and choose "Display Aggregate Found", it more or less displays a suggested aggregate. This one has fixed values for two of the Characteristics. The one I created does not have any fixed values, and nor it shouldn't.

John