Hi All, I have was asked to built a report model on the cube for some users and being new to report builder 3.0. I am having a weird issue. Lets Say I have following DIMS and FACTS. I have a cube built on top this Dimensional model. Two measure Groups/mearsures : ClassFact/ClassHours and FacilitatorFact/FacilitatorHours. used Many to Many relationship for FacilitatorDIM and ClassFact measuregoup. I now browse the cube it works excellent. The problem Starts Now a report model is built on top of it, then in the query wizard when I pull both groups and then FName the Classhours(measure) Disappears. Does Report Modes supports Many to Many or am I missing something? Any help will be appreciated. Thanks Dims ClassDIM (ClassID, ClassName) FacilitatorDIM ( FID, FName) Facts ClassFact( ClassID, Classhours) FacilitatorFACT(FID, ClassID, FacilitatorHours) Sample Data: Select * FROM ( SELECT ClassID = 1 , ClassDurationHours = 100.0 UNION SELECT ClassID = 2 , ClassDurationHours = 200.0 UNION SELECT ClassID = 3 , ClassDurationHours = 0.0 UNION SELECT ClassID = 4 , ClassDurationHours = 1.0 UNION SELECT ClassID = 5 , ClassDurationHours = 50 ) ClassFact Select * FROM ( SELECT ClassID = 1, ClassName = 'ABC' UNION SELECT ClassID = 2, ClassName = 'DB' UNION SELECT ClassID = 3, ClassName = 'BC' UNION SELECT ClassID = 4, ClassName = 'ZYZ' UNION SELECT ClassID = 5, ClassName = 'Z' ) ClassDIM Select * FROM ( SELECT ClassID = 1, FacilitatorID = 100, FacilitatorDurationHours = 20 UNION SELECT ClassID = 2, FacilitatorID = 200, FacilitatorDurationHours = 30 UNION SELECT ClassID = 3, FacilitatorID = 300, FacilitatorDurationHours = 50 UNION SELECT ClassID = 4, FacilitatorID = 400, FacilitatorDurationHours = 60 UNION SELECT ClassID = 5, FacilitatorID = 500, FacilitatorDurationHours = 70 UNION SELECT ClassID = 5, FacilitatorID = 600, FacilitatorDurationHours = 100 ) FacilitatorFACT Select * FROM ( SELECT FacilitatorID = 100 , FacilitatorFullName = 'F100' UNION SELECT FacilitatorID = 200 , FacilitatorFullName = 'F200' UNION SELECT FacilitatorID = 300 , FacilitatorFullName = 'F300' UNION SELECT FacilitatorID = 400 , FacilitatorFullName = 'F400' UNION SELECT FacilitatorID = 500 , FacilitatorFullName = 'F500' UNION SELECT FacilitatorID = 600 , FacilitatorFullName = 'F600' ) FacilitatorDIM

Please let me know if any one has the similar problems.

After, searching online I have found this link. http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/7bfc06dd-d835-4f08-9bc6-b9b3da958054 I have manually changed the report model as suggested. Thanks Tinku

After, searching online I have found this link. http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/7bfc06dd-d835-4f08-9bc6-b9b3da958054 Now, I have one more question how to hide the other Measure Groups? Thanks Tinku