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].[M*ySite], ...


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

Take a look at the following entry on my blog, which should answer your
question
http://spaces.msn.com/members/cwebbbi/Blog/cns!1pi7ETChsJ1un_2s41jm9Iyg!166.entry

HTH,

Chris

"Michael Swart" wrote:

Thanks Chris, that's a big help.
Michael Swart