For drillthrough purposes, we have created a fact dimension and set it
to ROLAP storage mode.

Then we created a drillthrough action that would pull data from this
dimension. In theory, this allows us to pull data directly from the
SQL Server table.

When there are changes to the underlying table, we don't care about
immediately updating the dimension or the cube or anything in MOLAP.
However we do need the changes to show up immediately whenever a
drillthrough action takes place.

In other words, perform the drillthrough action, see some data, go to
SQL Server and change the data, re-submit the drillthrough action, and
see the refreshed data.

I have not been able to get this to work except by shutting down and
re-starting Analysis Services. It must be caching the ROLAP dimension
because the drillthrough result shows data that has not been refreshed.

Is there some setting or property to get the behavior we want? Is this
situation documented anywhere?

Regards,
-TW