Hello,
I have measure Sales cost, I would like to show this cell when sales cost value <> 0, in other way I would like to display empty cell.
I use source column of mesause:
case when "dbo"."v_Sales_Stock"."slst_sales_cost" <> 0 then "dbo"."v_Sales_Stock"."slst_sales_cost" else NULL end
But when I browse the cube I see the same value "0".

I found ms support articles according this question, but there are suggestion to implement several fact tables.
http://support.microsoft.com/default...b;en-us;244650

Is it possible to leave empty cell using one fact table. Have anybode some exprerience during this topic?

Ramunas Balukonis

You can use "iif" function to display blanks instead
of "0".

Abhinav Kumar
MCP
akumar (AT) itmag (DOT) com.au

like to display empty cell.

Thanks,
when using IIF I need to create calculated memeber. Is it possible to
display blank without using calculated member?

Ramunas Balukonis

"Abhinav Kumar" <akumar (AT) itmag (DOT) com.au> wrote