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...

The pros and cons of Report Builder 3.0 over Report Builder 1.0

Thursday, March 17, 2011

So yes, I'm still thinking about RB 1.0 vs. RB 3.0. We've made the move a few months ago from SQL Server 2005 to SQL Server 2008 R2. Most of our projects in the team, if they're not cubes, are Report Builder 1.0 models.  I was really looking forward to seeing how we can move our users from Report Builder 1.0 to Report Builder 3.0. My conclusion? Except for a few very specific cases - we can't.We actually still have Report Builder 1.0 as a click once application from our Report Portal of 2008 R2 and not Report Builder...

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...