Providing software solutions since 1976
Training & Bookstore
If you define a filter that references a member with a single quotation mark and that dimension is hidden in the table, then drilling to detail data might return an error similar to the following:
Unable to display detail data
The immediate MDX execution failed
-Formula error - An invalid member name was encountered in the MDX statement - near: "[Dim]..."
-An MDX syntax error occurred
As a workaround, unhide the dimension and assign it to either rows or columns.
Click the Hot Fix tab in this note to access the hot fix for this issue.
A fix for this issue for SAS Web Report Studio 4.3 is available at:
A fix for this issue for SAS Web Report Viewer 4.3 is available at:
A fix for this issue for SAS Web Report Studio 4.31_M1 is available at:
A fix for this issue for SAS Web Report Viewer 4.31_M1 is available at: