There is a constant debate about the direction of BI tools from Microsoft, which model will they support, the SSAS multidimensional or the office based Self service BI. There have been passionate exchanges on what will happen to SSAS multidimensional. Well recently in SQL Server 2012 there has been a new functionality that has been released. As part of SQL Server 2012 SP1 CU4, new functionality has been released that means that Power View now works with Analysis Services Multidimensional . Please go through the following link for more technical details:
As per the MSDN blog: Now Power View users can connect to both the tabular and multidimensional formats of the BI Semantic Model. This is achieved through native support for Data Analysis Expressions (DAX) in Analysis Services multidimensional models, ensuring optimal performance and functionality.
As per Chris webb a leading SQL Server BI expert: This is the first significant bit of new functionality in Analysis Services Multidimensional for a long while, and it acts as a bridge between the classic SQL Server BI stack that most of us are using and the brave new world of Office/Sharepoint-led BI. Please go through his comments on this functionality Here:
Post a Comment