I have a cube with the following dimensions:

Time
Product
Customer
Warehouse

and the following measures:

SalesAmount
SalesVolume

Please advice how I can report scenarios like I want to view results
where SalesAmount > 50000 and SalesAmount < 80000,etc where I want to
restrict on measures how is this possible.

Thanks
Karen

Here's one way using Filter, but there are other more efficient ways also.

select
{
[Measures].[SalesAmount], [Measures].[SalesVolumne]
} on columns,
{
NonEmptyCrossjoin( [Time],
Crossjoin ( Filter( [Product].Members, ( [Measures].[SalesAmount] > 50000
and [Measures].[SalesAmount] < 80000 ) ) ,
Crossjoin ( [Customer], [Warehouse])))
} on rows
From [Your Cube Name]


<karenmiddleol (AT) yahoo (DOT) com> wrote