Almost every post I made about Report Builder, be it the pros and cons of creating a report model on a cube or refining a report model based on a cube, brought the same question – what makes reports based on a report model to break and how can you avoid it?
Well I didn’t know the answer as I admit it never happened to me, (sigh of relief), but the question did bother me enough for me to try and research it a bit more on the internet. And yes, I’m happy to say there is more than enough information on the internet for me to come back with some answers:
There’s a summary from Bob Meyers on what will break your reports when you change the properties of attributes, entities and roles in your Report Model.
Yes, Bob Meyers knows SSRS inside – out, and if the above post was a summary, then this one elaborates on some of the points mentioned before and will give you great tips on how and why to denormalize your Report Model. So read it also!
Msdn has also dealt with the issue of what will break reports based on your Report Model. This article relates to Report Model management in SQL Server 2008, and this one for Report Model management in SQL Server 2005. The articles are one and the same for the time of writing this post, but that may change in the future.
Apparently what Bob Meyers said about avoiding changes to an object’s ID in Report Model, also holds true when you do that in your SSAS cube, when your report model is based on it. Steve Novoselac gives you the details on what happens because of it.
Hope that helps you avoid breaking the reports you have based on your Report Model, so that your users can keep running them!