Category Archives: SSAS

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, … Continue reading

Posted in MDX, Proactive Caching, ROLAP, SSAS | Tagged , | Leave a comment

MDX Studio – Tool to Debug MDX

MDX Studio is a great tool developed by Mosha to help in tuning and debugging MDX. This is a Windows application which one can install in a PC / Windows Server. There is a cut-down version of the tool online … Continue reading

Posted in MDX, SSAS | Leave a comment

SSAS Data Connection and Impersonation Info

When we create a datasource in SSAS, we need two types of connection information Data Connection: As the name goes, this information is used to connect to data source. This can be a standard User ID / Password combination (can … Continue reading

Posted in BusinessIntelligence, SSAS | Tagged | Leave a comment