If you are unable to create a new account, please email support@bspsoftware.com

Author Topic: OP-ERR-0181  (Read 7238 times)


  • Guest
« on: 04 Jan 2011 06:48:08 pm »
We have a cube over which we allow users to create their own Query Studio reports.

We have recently have a change in the coding of key values in the database that we will build the cube from. E.G Value 'ABC' is now 'XYZ'

This has caused any reports that has a filter on the value 'ABC' to fail with the error:

OP-ERR-0181 At least one invalid member reference was encountered in the query.'[Cube].[All values].[All values].[Hierachy]->:[PC].[@MEMBER].[ABC]'

Is there a 'quick and easy" way to change the filter to filter on 'XYZ' rather than 'ABC' ?


Offline MFGF

  • Never knowingly correct
  • Super Moderator
  • Statesman
  • ******
  • Join Date: Jul 2005
  • Posts: 11,707
  • Forum Citizenship: +677/-10
  • Cognos Software Muppet
Re: OP-ERR-0181
« Reply #1 on: 05 Jan 2011 03:23:14 am »
In Query Studio, you will need to delete and re-create the filter.