the concern here is that if i update the fact table (which is huge in size) then i will need to reprocess the entire cube everyday. I want to be...

how exactly do i do that?

Vijay,

Thanks for your response......

However, its not a current production system so the view workaround will not work!!

Is there any other way of doing this?

Regards,

Ritika