Power View on SSAS Multidimensional

Tuesday, December 11, 2012

Microsoft recently released a CTP of Power View on SSAS Multidimensional, (and yes, I know I'm a bit late writing about this, but I still wanted to give my two cents on it). So we're edging closer towards the point where Power View and Excel will be able to cover all of your viewer needs (or at least most of them :)). Years ago when I wrote about Report Builder on a cube and all the problems that that relationship created, I wondered when that would be fixed. Now that we have Power View, I'm glad that Microsoft is...
no comments

Using a filter on a calculated field in Report Builder

Friday, December 16, 2011

A short and sweet tip on using Report Builder 1.0So, my users are still using Report Builder 1.0. I recently discovered that using a filter on a automatically calculated field there doesn't work. I tried running a report where I ran a filter on a year generated filed of a certain date. In essence, I filtered on Year creation date = 2011. The report took ages to run so I took a look at it on the profiler to see the query that was run. Apparently, it wasn't even running the filter correctly.Changing the filter to creation date on...
6 comments

Model Item Security and Identifying Attributes in Report Builder

Thursday, October 6, 2011

I found myself needing to define Model Item Security on a Report Builder 1.0 Model I did some time ago. I followed the guidelines detailed in the Model Item Security page (you can read more also about Securing Models). First of all, I would like to call to your attention that Model Item Security works only if your user isn't a Content Manager or Publisher (as noted in this article about Security in Report Builder 1.0. Please note that it describes the process in the way it worked in SQL Server 2005, which has changed for SQL Server 2008...
no comments

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

Problem updating Report Builder 1.0 Model in SQL Server 2008 R2

Thursday, January 6, 2011

So, as you may have gathered from the previous post, we installed SQL Server 2008 R2 in the municipality not too long ago. And yes, that led to all sort of problems... One of the main problems that all of us encountered, was that we couldn't update our report models. Yes, we could start a new Report Builder 1.0 Project. We could define a DSV and autogenerate a Report Model. But then, if we added a table to the DSV or new columns were added to an existing table, and then we would run an Autogenerate on the Report Model...

Error Message When Using a New Feature in SSRS 2008 R2

Tuesday, January 4, 2011

We installed SQL Server 2008 R2 about 2 months ago, and I recently tried to use a new feature in Reporting Services 2008 R2. I used the Business Intelligence Development Studio (BIDS) to open a new Report Server Project. After creating a data source I also defined a shared dataset (a new feature to SSRS 2008 R2). I put some of the fields into a table and tried to run the report (still inside the BIDS).  But I failed with an error: The report preview failed because the report could not be built. Read the errors, warnings and messages in...

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

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