Hi,
I have the following fact table

id qty qtyleft qtydam delivyesno
1 5 2 1 1
1 2 0 0 0

I need to create a calc memeber to read

netsale = ( (when delivyesno = 1 then qty - qtyleft - qtydam) - (when
delivyesno = 0 then qty) )

At the moment I have qty, qtyleft, qtydam as measures. Please advice.

I created the following expression in SS2k5 olap cube and it worked for me.

(case when delivyesno = 1 then qty-qtyleft-qtydam else 0 end) - (case when
delivyesno = 0 then qty else 0 end)

HTH..
--
http://zulfiqar.typepad.com
BSEE, MCP


"Chris" wrote:

The problem is that this data is in the FACT TABLE and when I try to create a
measure I don't see the FACT Table listed to select the column like

CASE [Measure]...

Any other ideas? I am using SQL 2000. Even If I want to create a separate
CUBE the problem I have is that the data I want to use in the CASE or IIF
exists in the FACT Table.

Thanks

"ZULFIQAR SYED" wrote:

If you make delivyesno a slicer in you cube then the following
calculation should work...

iif([delivyesno].currentmember is [delivyesno].[YourLevelName].&[1],
qty - qtyleft - qtydam,0)