When I have two measure groups (GroupA and GroupB) and GroupA has a dimension not in GroupB, then when slicing by that dimension on the GroupB measures, the total is correct, but all the members have the value of the total. This is confusing users who are not paying attention and are slicing on dimension against measures that are not to the same grain. Is there a way to hide the values of measures when they are being sliced by dimensions when their is no relationship defined?
You can try setting the "" property of GroupB to false (default is true): http://msdn.microsoft.com/en-us/library/ms365411.aspx >> Configuring Measure Group Properties .. IgnoreUnrelatedDimensions Determines whether unrelated dimensions are forced to their top level when members of dimensions that are unrelated to the measure group are included in a query. Default setting is True. .. >> - Deepak Deepak Puri Microsoft MVP - SQL Server *** Sent via Developersdex http://www.developersdex.com ***
