Sorry if this is a newbie type question. The easier to answer I guess.

I have an MDX query that queries a cube with syntax that looks
something like this:

WITH
MEMBER [Measures].[Passed]
AS '([Measures].[Value], [Pass Flag].[Pass Flag].&[-1])'
SELECT { [Measures].ALLMEMBERS } ON COLUMNS
{ [Operation].[Name].ALLMEMBERS } ON ROWS
FROM MyCube
WHERE ([EquipmentLocation].[Name].[MySite], ...


If the cube is processed from a database with no data, the query will
fail when querying a table with -1 since -1 is not yet a member of the
given dimension.

Question: What is the best way to filter query results if we don't yet
know if the member exists in the cube?

Michael Swart