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
In Query Studio, you will need to delete and re-create the filter.
MF.