SSAS OLAP cubes Real Time data

i have situation where  need see real time data in dashboards.

 is possible using molap cube or heard tabular model in sql 2012.

please suggest.

hi reddy07,

please refer following information form msdn document:
source data changes, objects in molap storage must processed periodically incorporate changes , make them available users. processing updates data in molap structure, either or incrementally. time between 1 processing , next creates latency period during data in olap objects may not match source data. can incrementally or update objects in molap storage without taking partition or cube offline. however, there situations may require take cube offline process structural changes olap objects. can minimize downtime required update molap storage updating , processing cubes on staging server , using database synchronization copy processed objects production server. you can use proactive caching minimize latency , maximize availability while retaining of performance advantage of molap storage.

for more information proactive caching (partitions), please see:
http://technet.microsoft.com/en-us/library/ms174769.aspx

best regards,

---

elvis long
technet community support

SQL Server  >  SQL Server Analysis Services