BI Semantic Model – the new solution for SSAS and PowerPivot

Saturday, May 28, 2011

TechEd North America 2011 wrapped up last week with big news about PowerPivot and SSAS. Just in case you haven't read it already somewhere else, I'll give you a very short re-cap. In SQL Server 2005, the UDM was supposed to encapsulate the solution for modeling your project. In SQL Server 11, codename Denali, it's going to be replaced by BISM - the Business Intelligence Semantic Model. All the reporting tools in the Microsoft BI Stack will work against this model. In Denali, you will be able to use BISM both for tabular model in PowerPivot and for cubes...

SSAS and SSRS in SQL Server 2011

Saturday, November 13, 2010

Don't know if you're aware of it, but Microsoft just rocked your world! I remember interviewing Mr. Ariel Netz, Product Unit Manager for SSRS.  I wanted to hear from him what's planned for Report Builder 1.0 as I didn't feel like Report Builder 3.0 covered all the functionality that was in 1.0. I also wondered what sort of answer we will get for ad - hoc reporting against SSAS in SSRS. Mr. Netz said as much as he could I guess, as things were still under NDA. And now the future of Reporting Services is here... Project Crescent was just presented...