Sunday, March 25, 2012

Cannot read the next data row for the data set

Hello all -
Our users are getting the above error when trying to execute a report.
Permission has been granted to the security group that they belong to, for
the report folder and report (browser permissions), as well as the Analytical
Services database and the associated data warehouse database (db_datareader).
The report uses two parameters, which have default values set (year and
month).
Any ideas as to what may be the problem?
Thanks!
Pam RichardsonIn case anyone else runs into this problem, here's the answer. In the
analysis services database, the Reader role/Cell Data had the "Enable read
permissions" checkbox checked, but nothing was in the "Allow reading of cube
content" textbox. Unchecking this checkbox solved the problem.
Thanks,
Pam Richardson
"Pam Richardson" wrote:
> Hello all -
> Our users are getting the above error when trying to execute a report.
> Permission has been granted to the security group that they belong to, for
> the report folder and report (browser permissions), as well as the Analytical
> Services database and the associated data warehouse database (db_datareader).
> The report uses two parameters, which have default values set (year and
> month).
> Any ideas as to what may be the problem?
> Thanks!
> Pam Richardson

No comments:

Post a Comment