Ella Maschiach's BI Blog : Analysis Services, Reporting Services

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

Ella Maschiach — Thu, 15 May 2008 23:41:24 GMT

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 quite a few problems that may occur when you build...(read more)

Creating a Report Model based on an Analysis Cube

Ella Maschiach — Thu, 22 Nov 2007 01:06:00 GMT

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...(read more)

Recreating a Report Model

Ella Maschiach — Wed, 31 Oct 2007 20:55:00 GMT

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...(read more)