A Comparison between SQL Server 2012 BI Tools

Saturday, July 28, 2012

I have recently posted an article in Silicon India comparing SQL Server 2012 BI tools and means of development. I addressed there the tools in SQL Server 2012: SSRS, Report Builder 3.0, Power View, Tabular and Multidimensional Analysis Services.Though I tried to cover much ground in the article, I would still recommend some additional reading: A short comparison between Tabular mode vs. PowerPivot A more detailed comparison between Tabular mode vs. PowerPivot vs. Multidimensional SSAS ...

Reporting Services and JavaScript in SharePoint 2010

Saturday, July 21, 2012

I have recently finished MOC 50429 SharePoint 2010 Business Intelligence with Lior Cohen Amikam which I found very enlightening. I thought I’d share with you some of the excerpts from my summaries throughout the course. It’s a mix of ideas of what to do with SharePoint BI abilities and a short description of what they are. This is the sixth post in a series of posts that I am making from the material of the course: Reporting Services 2008 R2 In Report Builder 3.0 we can use report parts that exist on the Report Server. In Reporting Services in Visual Studio,...

Access and Visio Services and Spatial Data in SharePoint 2010

Wednesday, June 27, 2012

I have recently finished MOC 50429 SharePoint 2010 Business Intelligence with Lior Cohen Amikam which I found very enlightening. I thought I’d share with you some of the excerpts from my summaries throughout the course. It’s a mix of ideas of what to do with SharePoint BI abilities and a short description of what they are. This is the fifth post in a series of posts that I am making from the material of the course: Access Services Making the data in access available to everybody – just like with the Excel files in Excel services.This enables us to manage the...

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

Building Effective data visualizations in Reporting Services 2008 R2

Monday, November 29, 2010

This is a live post from the session of Ronen Chen at Tech Ed Israel 2010 . New to report builder 3.0 - we can be in local mode or server mode. We can check it in relation to performance on the server and save in directly on the server (rather than on my PC). Zooming and moving my map is only possible during the design of the report. We cannot zoom in on it after running the report. A zoom in is possible through an action in the report which will create the zoom in a new report. Avoid...

Amir Netz and Ariel Netz Talk on PowerPivot, DAX, Report Builder and PivotViewer

Monday, August 16, 2010

Ok, so the unexpected happened - about a month and a half after interviewing Mr. Donald Farmer, I got to interview Mr. Amir Netz and Mr. Ariel Netz! I know!... You probably remember Mr. Amir Netz from his appearance in the recent keynote session in the BI conference in New Orleans. He spoke about what's going to be new in PowerPivot. When I heard he was coming to Israel for a conference discussing Panorama and PowerPivot, I decided I'd try to get a few more tidbits from him... In the keynote session, Mr. Netz had talked about adding the ability to...

Dividing by zero when creating a fraction as a calculated field

Thursday, July 1, 2010

I found myself recently trying to remember how a formula I wrote a few months ago in Report Builder. Doing the same thing twice, made me think I should put it on the blog, so that next time I won't need to remember it...A user complained a report in report builder didn't run for her, as she divided two measures and the report would error when the denominator would equal zero. The error message she got was: Semantic query execution failed. Divide by zero error encountered. ---------------------------- Cannot read the next data row for the data set dataSet. ---------------------------- An error has occurred during report...

Microsoft SQL Server 2008 R2 Feature Pack Download

Wednesday, May 12, 2010

Hot off the press!  I just read on Teo Lachev's blog that Microsoft SQL Server 2008 R2 Feature Pack RTM - ed. Yeah, I know! I have to admit this is also slightly amusing for me, as just this morning I asked a Microsoft consultant if he knew when it's suppose to drop...So you know what this means, you can now download a standalone version of Report Builder 3.0, PowerPivot for Excel and Data Mining Add-ins for Office 2007. Each can be downloaded by itself or as a whole package. If you're looking to check out all the new...

Report Builder 1.0 vs. Report Builder 3.0

Tuesday, May 4, 2010

The municipality has been planning to move to SQL Server 2008 R2. Now obviously I'm happy about it, but it also made me wonder about our Report Builder 1.0 models. I know Report Builder 3.0 doesn't have all the functionality that Report Builder 1.0 has. In some ways Report Builder 3.0 outdoes version 1.0 and in other ways it's lacking. I was deliberating on how the move of upgrading to SQL Server 2008 R2 may affect us in the municipality. I mean, does that make our Report Models from 1.0 obsolete? Maybe there's no point in continuing to develop...