IBM Cognos BI report error against SSAS – At least one invalid member reference was encountered in the query


At least one invalid member reference was encountered in the query

Problem

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.

Solution

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.

Advertisements

3 thoughts on “IBM Cognos BI report error against SSAS – At least one invalid member reference was encountered in the query

    1. willthrash Post author

      Hi Cindi,

      New members will automatically appear in the package. It’s not literally a DMR, which is dimensionally modeled relational, but an natural OLAP datasource. You do not have to republish the package.

      I’ve sometimes found that I have to log off of Cognos and log back in before cube changes show.

      Thanks,

      Will

      Like

      Reply

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s