How to avoid breaking reports based on your Report Model

Sunday, June 8, 2008

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

Creating a Report Model based on an Analysis Cube – Pros and Cons

Thursday, May 15, 2008

Creating a Report Model based on an Analysis Cube – Pros and Cons If you follow my blog, you probably know by now that I developed a report model based on the Analysis Services cube I already had. I even got around to updating the report model. And then, my users started using it. And you know, whatever we do just seems so wonderful to us, until our users find all sorts of flaws with what we did… so yes, my users did open my eyes to...

Inheritance in Report Model

Friday, May 2, 2008

I recently finished defining and refining a report model based on a relational database. At first, I just set up my DSV and then added a report model with the “Autogenerate” option. Then came the grueling task of refining the report model that was generated… I was using the MSDN pages which were very helpful on that subject, but it’d be fair to say that I something to add to what they suggest for inheritance. See, I was using the inheritance property for my entity and deployed my model to the server. Only thing, when I viewed my...

Updating your Report Model

Saturday, February 9, 2008

I know I had written of the simplicity and ease of creating a report model based on a cube, but I too would have to admit that even a good thing can be made better. Just in case you hadn't noticed, when you enter the report site you can manage your models. If you can't see the "Models" folder, simply click the "Show details" and you'll see it. Select the folder and click on the name of your model or on the "edit" icon next to it. You now have a chance to "Edit" or "Update" your...

Creating a Report Model based on an Analysis Cube

Wednesday, November 21, 2007

Well I guess congratulations are in order because I finally got around to using a report builder in my project. Turns out that building a report model based on a cube is as easy as 1-2-3. Still I had a problem, as for some unknown reason the translations were showing for my dimension names and my measures, but not for the dimension's attributes... At first I thought maybe this is a problem solved by Service Pack 2 (as my tests were done on a Server with Service Pack 1). Alas, no. So, a further look in the MSDN library,...

Recreating a Report Model

Wednesday, October 31, 2007

Remember how I taught you to recreate your Analysis Project? Well, let's say this time you have a model you deployed to the Reporting Services Server, but you have changed it since then and want the old version back. So how would you recreate the model you have on the server?  First of all, create a new Data Source View in your Analysis Project. It doesn't have to include all the relevant tables, as you'll only use it as a shell to build upon. After you've finished defining the DSV, save the project. Then, right click the new DSV...