Unanswered: Getting a ROLAP cube to refresh when a dimension changes
Have 1 ROLAP cube in an AS DB with other MOLAP cubes. The ROLAP cube is derived from a SQL database view and uses dimensions that are also used by the MOLAP cubes. The aggregation storage of the source view is defined as ROLAP. Updates to the Fact table cause the ROLAP cube to refresh while updates to the dimensions do not cause a refresh of the ROLAP cube.
What can be done to enable an update of a dimension used by the ROLAP cube to cause the ROLAP cube to be refreshed without reprocessing the MOLAP cubes also using the dimension?