ssrs

Reporting Services (ssrs/MSRS) 2008 Error: Set used with the complement operator must have all members from the same level
When you use the Not In operator in a ssrs 2008 MDX query filter to exclude a named set, it uses a the complement operator in the constructed MDX. This is fine as long as "all members [are] from the same level." Since you got this error, they are not You can get around this by using the Except() MDX function instead of letting ssrs use the Complement operator In the ReportServerService log, you'll see something like this: Microsoft.AnalysisServices.AdomdClient.AdomdErrorResponseExcept

Blog Content