Tried this once before:

New dimension values must be added "gracefully"...that means incremental
update ... if I do this is there something
wrong with dropping the fact table in sql and loading it again and doing a
refresh data process on the cube ?

Will I then loose used based optimization - if such ... ?

Have an environment where the processing isnt' the buttle neck .. take only
2-3 minutes - shouldn't I worry then ?

\Michael Vardinghus

i would never drop the fact table, but i dont think that it sounds like it
will be a problem.

access to the data in the cubes should work even while the fact is gone ---
try this of course first and

ALWAYS USE MOLAP


"Michael Vardinghus" <michaelvardinghus (AT) notexisting (DOT) com> wrote

Molap - always

if you don't drop the fact how do you filter records ? by date in host ?

<aaron_kempf (AT) hotmail (DOT) com> skrev i en meddelelse
news:O4LVvEqQEHA.4020 (AT) TK2MSFTNGP11 (DOT) phx.gbl...