Suppose I have a clientID dimension in my Cube and again suppose that i
create a query for a ClientID which does not exist in the values of that
dimension. Than i got an exception declaring "non existing dimension". Is
there any way of not receiving an exception and (for example) get blank table
instead.

I tried to use isError property to handle it but can not succeed.

Or should i just catch these exceptions on the software side?

Help please
--
Necati Sekkeli
CBKSoft
Junior Software Developer

By the way ı am using AS2000. Thanks for all.

--
Necati Sekkeli
CBKSoft
Junior Software Developer


"necati@cbksoft" wrote:

IsError() should work, as in this AS 2000 Foodmart example:

http://groups.google.com/group/micro...olap/msg/cadb2
e3e58fad0df

From: Deepak Puri
Date: Wed, Dec 14 2005 11:37 pm
Groups: microsoft.public.sqlserver.olap

You can use the VBA IsError() function, as in this Foodmart Sales
sample. AS 2005 has a "Missing Members Mode" that could be used to
ignore such errors:

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 ***