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
Hierarchy Node 54
i checked st03n as well but i could not find query and cube name using expert mode. please help