cancel
Showing results for 
Search instead for 
Did you mean: 

extremely long execution while cube data view

former_member245939
Participant
0 Kudos
244

Hi experts!

My issue:

I have infocube zEsncub. It contains only 100.000 records and 10 requests in admin panel.

while I am execute infocube data view in RSA1, my query to cube hangs in DB and doesn't give any reaction.

Selection Creterias:

zYear = 2015

zMonth = 09

zBus_area = 0001

BUT! If I delete char "zMonth" from Selection Criterias and execute, then query works fine.

All these chars are in one dimension of cube.

I can't undestand such behaviour. Please help me solve this problem.

Indexes and statistics in cube are green.

View Entire Topic
KodandaPani_KV
Active Contributor
0 Kudos

Hi,

can you create the aggregates on the cube for the zMonth.

or

create the indexes at cube performance tab.