Monthly Archives: August 2012

Enterprise Data Warehouse Bus Matrix

When you combine the list of EDW subject areas with the notion of conformed dimensions, a powerful diagram emerges, which we call the enterprise data warehouse bus matrix. A typical bus matrix is shown in following figure: At the beginning … Continue reading

Posted in SSAS | Tagged , | Leave a comment

Using DirectQuery in the Tabular BI Semantic Model.

This paper introduces DirectQuery, a mechanism for directly querying a SQL Server data source for Analysis Services tabular models. Readers will learn when and how to use DirectQuery in SQL Server 2012. https://zaimraza.files.wordpress.com/2012/07/directquery20in20the20tabular20bi20semantic20model1.docx

Posted in SSAS | Tagged | Leave a comment

Business intelligence Semantic Model (BISM):

Microsoft now offers two types on analytic database. There is the “traditional” BISM OLAP and the new BISM Tabular version. The 2012 version of BISM OLAP is very similar to SQL Server 2008 R2 Analysis Services. But the new “tabular” … Continue reading

Posted in SQL Server features | Leave a comment

Percentage of companies using versions of SharePoint

Posted in Sharepoint 2010 | Leave a comment