cancel
Showing results for 
Search instead for 
Did you mean: 

Why BEx query not hitting aggregates?

former_member198905
Participant
0 Kudos
439

Hi

I already read lots of documents regarding creating aggregate.

I try following procedures to create aggregates on cube:

1) Create separate aggregate for each dimension.

2) Create separate aggregate for each dimension with time dimension.

3) Single aggregate contains all dimension.

4) System proposed all aggregates.

5) Selected optimize aggregates from system proposed all aggregates.

Non of the aggregate size is greater then InfoCube size.

Following are the best valuation when using option (2):

But

Why BEx query not hitting aggregates?

Thanks

View Entire Topic
former_member202718
Active Contributor
0 Kudos

Hi Imran,

Use the Characteristics of Aggregates in the Query input and then check.

Create Agg as per need of the Query and not necessarily as suggested by system.

Regards

SVU

former_member198905
Participant
0 Kudos

Hi SVU

Sorry I don't get your point "Use the Characteristics of Aggregates in the Query input".

Please explain it in detail.

Regards