At least one invalid member reference was encountered in the query
When encountering this error message “At least one invalid member reference was encountered in the query…”, when reporting against SQL Server Analysis Services with IBM Cognos Report Studio 10.1 using a crosstab, the problem may be caused by having no data in a row and column intersection.
A potential solution is to go to the query properties and, under Query Hints, change Suppression to Nulls. This can also improve performance as it can reduce the data returned from the cube. Note that this is a different setting than the Zero Suppression that suppress rows and/or columns. It’s on the query, not the reporting object.
There could be many reasons that a missing member reference was encountered, but this simple change often fixes the problem.