Thursday, April 12, 2012

Using an SSAS Calculation in SSRS: ERROR: A set has been encountered that cannot contain calculated members

Now I am going to provide a cliff notes version of resolving this error and will provide links to other resources for more details on the solution.

While working on a project we discovered when using certain calculations (Business Intelligence Time Calculations in this example) that SSRS would error when query building the Analysis Service Cube.


ERROR: A set has been encountered that cannot contain calculated members.
















Now the quick and easy way to resolve this error...
  1. In the SSRS Solution Explorer double click the datasource to open the Data Source Properties box.
  2. In the text box for connection string: append the connection string with ;Subqueries=1
  3. Click OK
  4. Have fun using your Calculations.


Need a little more: Here is a like to Mike Milligan's Blog with some more detail and step by step.

No comments:

Post a Comment