on 2015 Oct 16 12:09 PM
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.
Request clarification before answering.
Hi,
can you create the aggregates on the cube for the zMonth.
or
create the indexes at cube performance tab.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
12 | |
9 | |
8 | |
8 | |
5 | |
4 | |
4 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.