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

Answer 1

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

Answer 2

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.