![]() | |
![]() |
| | Thread Tools | Display Modes |
#1
| |||
| |||
|
#2
| |||
| |||
|
|
I have a cube with 250.000 facts and 4 dimensions (molap): 1) date (year > month > day) 2) item > components (parent - child) - 5000 entries 3) production order (type > no > line no) - 8000 entries 4) routing (type > no) - 10000 entries and 8 simple sum facts. I have all integer surrogate keys and folow all the ideas of good design and implementation, but the problem is when I put date >> some month, item specified no and filter production order to smt specifed and i want to add a routing dimension, it takes long long time to display (over 3 minutes). Are there any ideas how to speed up querry performance? |
![]() |
| Thread Tools | |
| Display Modes | |
| |