You are currently viewing the BOOK: Microsoft SQL Server Reporting Services Recipes: for Designing Expert Reports section of the Wrox Programmer to Programmer discussions. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
I have Adventure Works DW 2008 R2 cube on installed on my server, and I'm running into a similar issue. When I try to change the "Date" dimension by clicking on the date field after "for" in the report title of the Cube Browser report, I get the error message "Query execution failed for dataset 'DataSet1'. Parser: The syntax for ',' is incorrect.
I think the error is coming from the DataSet1 code in the Cube
Grant Paisley, are you there?
Last edited by GWadeCF; December 27th, 2011 at 06:11 PM.
Reason: Left out an important word - 'cube' in first line.
The Cube Browser report returns no data results even before the Cube Member report is accessed. It returns a raft of warnings, all variations on the theme "Warning 1 [rsMissingFieldInDataSet] The dataset ‘DataSet1’ contains a definition for the Field ‘Measure_Value’. This field is missing from the returned result set from the data source. C:\teamserver\SQL Reports\Secure\BI\Cube Reports\Cube Browser.rdl 0 0
I was attributing this to the Cube Member report issue, but now I'm realizing that this is probably a separate issue.
Found several issues, may have resolved the problem
Good news. I think I may have found the issue that brought me to a standstill.
The first issue (which is my fault) was that I had started trying to point the Cube Browser report at one of my cubes, and set the default measure to one of my cube measures.
I reverted these back to the Adventure Works values, but the Cube Browser still didn't run properly.
Then I noticed the default date was [Date].[Calendar].[Month].&&. The Adventure Works DW 2008R2 cube data begins in July, 2005. When I manually updated the default date to [Date].[Calendar].[Month].&&, presto, the Cube Browser report works properly.
Not only does the Cube Browser report work properly, but the Cube Member report works properly when called from the Cube Browser report with a valid date.
I changed the date parameter default in the Cube Member report, and it works properly as a stand-alone as well. Better and better.
I'm still having trouble adding the bug fix you shared. When I try to edit the Cube Member DataSet 1 query, I still get the "syntax for ',' is incorrect." error. Any thoughts on how to make that work?
Incidentally, the "Angry Koala" versions with the graphs in them also have the issue with the default parameters. I've changed the default date parameters in all reports, and they're all now producting results. However, the Cube Metadata and Angry Koala Cube Driver reports sometimes show incomplete results and do not link back to the calling report properly. I'm looking into this.