Skip to Content
Former Member
Feb 27, 2008 at 11:20 AM

Aggregate not being used in Query


Hi we have some query based on the a multi provider which is using 20 cubes, Here I am pasting other technical information from rsrt. we have created agggregate but these aggregats are not being used by these query.

I have checked in statisc tables as well. there also i could not find these aggregates.

InfoCubes concerned with MultiCube 20

FEMS Number (Selection Groups) 541 8192

Number of Elements in Structure 1 88 999

Number of Elements in Structure 2 48 999

Selection Lines 1640

Columns in Memory Table SP 1566

Free Chars 3

Basic Key Figures 16

Formula Components 13540

Hierarchies 1

Hierarchy Node 54

Variables 4

i checked st03n as well but i could not find query and cube name using expert mode. please help