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

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

The Many to Many Relationship

Saturday, September 1, 2007

So today's post will be about the usage of the many to many relationship that can reside between two dimensions. Quoting from the definition of Dimension Relationships, I would note that "Dimension usage defines the relationships between cube dimensions and the measure groups in a dimension…The many-to-many dimension relationship defines an association between a dimension and a measure group by specifying an intermediate fact table that is joined to the dimension table".       Now I know the usual example for this relationship is with bank accounts and people, as in: each person can have more than one bank account and...