I have set up a ROLAP Cube because of the advantage that you do not need to re-process the cube. AS will always go to the underlying data source for the most up to date data. Unlike MOLAP you do not need to re-process your cube to refresh the
BUT. I find this is only true for my FACT data (or for my measures). Say for instance my dimension changes - I add the member "Australia" to the country dimension. This new data is NOT filtering down to AS automatically, I need to re-process
my dimensions for the cube to be valid again.
So my question is this. If you have dimensions changing with each datawarehouse load, what is the advantage of ROLAP? Is there a way for ROLAP to figure out that a dimension has changed and re-process it automatically?
View Complete Post