Monthly Archives: February 2013

Real Time ROLAP Setup in SSAS Enterprise Edition

Posted on February 25, 2013 by EasyBIJegan

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

How to check for Contiguous Dates

Posted on February 25, 2013 by EasyBIJegan

Let’s say we have an SCD 2 Dimension called Dimension.Store.  Lets assume the Business Key is BranchCode and the type II rows is versioned using RowStartDate & RowEndDate  columns. How do we verify if the dates are contiguous with no … Continue reading →

Posted in Data Quality, DataWareHousing, Uncategorized | Leave a comment