Real Time ROLAP Setup in SSAS Enterprise Edition


If you need to access the underlying data in an SSAS measure group in Real Time with no latency (without any processing involved), proactive caching setting Real Time ROLAP has to be configured.  If you work on a typical Datawarehouse, this need is not normal. But if you use SSAS for real time calculations this setup will be useful.

Procedure:

1) Select the Storage Settings of the partition to be configured and select Real Time ROLAP.

RealTimeRolap

2) Click on Options to launch the Storage Options window as below .

StorageOptionsRTR

Note that the Latency is mentioned as 0 (zero). 

3) Go to the Notifications tab and select SQL Server (if the fact table resides in SQL Server)

You can select more than one tracking tables to watch for any updates. When the measure group is deployed SSAS watches for trace events raised against the specific tables. To do this, SSAS needs ALTER TRACE privileges in the underlying database (as mentioned in the bottom of the dialog box below)

SpecifyTrackingTablesRTR

Advertisements

About EasyBIJegan

Business Intelligence Developer
This entry was posted in MDX, Proactive Caching, ROLAP, SSAS and tagged , . Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s