Databases Reference
In-Depth Information
The way to approach this type of case is to store historical data (data that
does not changes) using the MOLAP storage method and store current data
(which can be defined as hours, days, or weeks) in ROLAP mode. Then set
proactive caching to operate on the ROLAP partition only. In this way you will
get fast access to fact data from the MOLAP store even when there are
changes being processed on the ROLAP partition. We recommend this solu-
tion whenever you have very large amount of fact data with new fact data ar-
riving periodically and which you need to see in real-time.
Even if you have a MOLAP cube specified, if you still want
real-time data you should use the connection string property
called Real Time OLAP and set it to True while connecting to
Analysis Services. This will help provide you the most up-to-
date data from the relational data source.
Important
Search WWH ::
Custom Search