Hi people!

Next few days I will start to initial loading OLAP cubes. For some reasons
I expect to have a wrong data after initial load, so my question is how to
change (delete) data in the cube. For ex. every data from between date1 and
date2.
I'm desperate because I will not have the time for another full process
after deleting data from central table. It's an very important job for me
and I.m not sure I can finish it correctly without the options to delete
chosen rows .

Any options ?

Thanks in advance!

Vlado.

I don't think that's possible, although it would actually be quite useful in
many situations. Try and do all your verifications possible on the fact and
dimension tables before processing, do this in SQL to compare keys between
fact and dimensions, for example.

Tore
"Vlado" <vkaligari (AT) tis (DOT) hr> escreveu na mensagem
news:uD0K32esEHA.2664 (AT) TK2MSFTNGP12 (DOT) phx.gbl...

Try building partitions on smaller date range. That way when you know that
the data for a particular date/date range is not correct you can refresh
data within that partition. Later you can merge these partitions.


"Tore Johnsen" <naturamo (AT) hotmail (DOT) com> wrote