I'm very new to Reporting and this is my first assignment. I have to create a report out of Cube. I did pulled out the necessary Dimensions and Measures in the data set. However, I do have a problem generating the structure of the report. I have two dimensions and two measures. DimRegionName, DimDate, Measures.NewCustomers and Measures.RevisitMembers. The Year out of DimDate should be in columns and RegionName on Rows. On the top, the requirement is to display the names of the measures in rows under every RegionName and their values in the data field. Something as below - I did try to produce this using Matrix report but not sure how to display the measures on rows under the RegionName. Year 2010 Year 2009 Bay Area New Customers 100 150 Revisit Members 50 30 South California New Customers 200 100 Revisit Members 100 50 Also, I have to add a column in the middle that display the change from 2009 to 2008. Any help or suggestion would be very much appreciated. Thanks!

Hi, I created a demo report base on sample cube [Adventure Works]. The report contains two dimension product and time, and two measures. Could you check below picture if this is what you want: If yes, then you can download the demo: http://cid-75f1f331db7892bf.office.live.com/self.aspx/.Public/New1/ssasCube.rdl Hope this helps, Raymond Raymond Li - MSFT