Monthly Archives: February 2013

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

How to check for Contiguous Dates

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