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?

How many routing types ? How many children are there per routing type ?

\Michael V


"Grega Jerkic" <grega.jerkic (AT) siol (DOT) net> skrev i en meddelelse
news:5nEwc.4431$37.552130 (AT) news (DOT) siol.net...