Hi all,
I am getting time interval between two dates and use it as a set of dates.
Like:

WITH MEMBER [Time].[SetTime] AS 'Sum({[Time].[2005].[1]:[Time].[2006].[6]})'
SELECT {..} ON COLUMNS, NON EMPTY {..} ON ROWS FROM CRM_Detail where
([Time].[SetTime] )

and it works unless two date parameters are found in dimension members.

Otherwise, (i.e. [Time].[2005].[1] is not a member in the dimension) it
returns an exception. With error Message:

Formula error - cannot find dimension member ("[Time].[2005].[1]") - in a
name-binding function

So what should i do if the user enters an invalid date? Do you have any
advise? Can i handle it with 'ISEMPTY' function?

Thanks

--
Necati Sekkeli
CBKSoft
Junior Software Developer

If you're using AS 2005, you can set the 'MDX Missing Members Mode on
the dimension to "Ignore":

http://sqljunkies.com/WebLog/mosha/a...missing_member
s_mode.aspx
...

With AS 2000, you can use the VBA IsError() function:

http://groups.google.com/group/micro...olap/msg/cadb2
e3e58fad0df
With Member [Measures].[TestExist] as
'iif(IsError(StrToValue("[Store Size in SQFT].[All Store Size in
SQFT].[20318]")),
"Missing", "Present")'

select {[Measures].[TestExist]} on columns
from Sales
...

- Deepak

Deepak Puri
Microsoft MVP - SQL Server

*** Sent via Developersdex http://www.developersdex.com ***

Thanks Deepak!
It seems it works in Foodmart sample.

--
Necati Sekkeli
CBKSoft
Junior Software Developer


"Deepak Puri" wrote: