I am new to Analysis services and our users sometimes want to filter
data in the OLAP report based on conditions like Sales > 10000 and
month > 6 and <= 8
how can we do this please give some simple samples against the
Foodmart cube.

Also, how do we implement Exceptions our users want when salesamount <
400 cells to be shown in red and sales >= 80000 to be shown in green.

Please provide a simple sample in the Foodmart cube also these kind of
conditions and exceptions from a Excel pivot report.

Thanks
Karen