compare time dimension with month(now)

#1

I have a very simple time dimension: year -> month

I need to create a calculated member in that

If the current member of DIM_TIME is < '05/2006', then use MeasureA.
If the current member of DIM_TIME is >= '05/2006' then use MeasureB.

'05/2006' will change based on NOW(). Please help me write the IIf statement.

Thank you.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

compare time dimension with month(now)

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap

compare time dimension with month(now) - 05-05-2006 , 03:31 PM