OP-ERR-0181

[Brent]

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' ?

Regards
Brent

[MFGF]

In Query Studio, you will need to delete and re-create the filter.

MF.