Getting value from dimension to filter a measure.

#1

Hello all,
My cube have a numeirc dimension i need make the validation:

IIF( [Dimension].CurrentValue = [Dimension].&[9998], 0 , [Measures].[Vlr])

But in row the values that belong to "[Dimension].&[9998]" was summarized
together another values.
Example:

I have this:

Year | Client | Vlr
2002 | 1 | 10

Quote:

2 | 20
5 | 30
9999 | 10
2002 Total | 70

I Want this:
Year | Client | Vlr
2002 | 1 | 10

Quote:

2 | 20
5 | 30
9999 | 10
2002 Total | 60

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

Getting value from dimension to filter a measure.

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

Getting value from dimension to filter a measure. - 09-20-2004 , 03:13 PM