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.
ClassDIM (ClassID, ClassName)
FacilitatorDIM ( FID, FName)
ClassFact( ClassID, Classhours)
FacilitatorFACT(FID, ClassID, FacilitatorHours)
SELECT ClassID = 1 , ClassDurationHours = 100.0
SELECT ClassID = 2 , ClassDurationHour
View Complete Post