extremely long execution while cube data view

[former_member245939]

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.

[KodandaPani_KV]

Hi,

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

or

create the indexes at cube performance tab.