Hello Hassan,

Check out this MSDN article.

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql2k/html/sq
l_real-timeolap.asp

When searching for more examples look under ROLAP (Relational OLAP).

Myles Matheson
Data Warehouse Architect