Query execution failed for dataset. Server: The operation has been cancelled

Question!

An error has occurred during local report processing.

An error has occured during report processing.

Query execution failed for dataset 'DataSet_XXXXX'

Server: The operation has been cancelled.

What the William H Gates is going on here?

I am trying to preview a report, that uses datasets which connect to ssas cubes, in the report designer.

I'm using SSRS2008 on xpsp3



Answers
I changed the query to use a different dimension containing the same data and it works.

The number of dimensions used in the query was reduced from 3 to 2.

I guess by touching the other dimension it was creating a large dataset which in turn caused the error.



You need to pull the report apart and run each query manually to find the failure.



This video can help you solving your question :)
By: admin