Error when using IIF on Source Column

Cannot add functions like:

iif("dbo"."FACT_Sales_order_transaction"."Delivere dQty" > 0,1,0)

on the Source Column property on a measure in my cube.

Get error "the column is not valid"

I'm sure it's a valid name !
I have a measure called so and
commands like "dbo"."FACT_Sales_order_transaction"."DeliveredQty "- "some other measure" works fine.

It works fine if I try the same on the Tutorial Sales cube:
iif("sales_fact_1998"."store_sales" > 0,1,0)

Only difference is "dbo"... Should work on SQL-server also ???

Hi:

I'd suggest using the CASE statement against the MSSQL Server data source. I use IIF() in one of my articles to accomplish a different end, then explain that, while this is great for the MS Access sample database (FoodMart), CASE would be the way to go for the same desired end with an MSSQL Server data source.

I give an example of how to use CASE at that point, and you can see it here:

http://databasejournal.com/features/...0894_3525516_5

Good Luck! Hope this is useful.

Bill

Hi, I have the same problem:

with case:
case when ("dbo"."probando"."CHECK1") ="X" then "dbo"."probando"."EXISTENCIA" else 0 end
With IIF:
iif ("dbo"."probando"."CHECK1" ="X", "dbo"."probando"."EXISTENCIA", 0)

and with both I got the same the column doesnt exist

THX