Define a Slicer

Use slicers to create dimensional filters that reduce the data included in measure rollups. A slicer is a filter that is applied to the cells but not the rows or columns in a crosstab.

Sample XML

The query defines all the data items included in the report. The slicer is defined in the query. The slicerMemberSet reduces the data to that related only to Camping Equipment, Golf Equipment and Outdoor Protection.

The XML required to define the slicer is highlighted in bold.

<query name="Query1">
   <source>
    <model/>
   </source>
   <selection>
    <dataItem name="Revenue">
     <expression>[great_outdoors_company].[Measures].[Revenue]</expression>
    </dataItem>
    <dataItem aggregate="none" name="Product line">
     <expression>[great_outdoors_company].[Products].[Products]
		 .[Product line]</expression>
    </dataItem>
    <dataItem name="Fax">
     <expression>[great_outdoors_company].[Order Method].[Order
Method].[Order Method1]-&gt;:[PC].[Order Method (Root)].[601]</expression>
    </dataItem>
    <dataItem name="Web">
     <expression>[great_outdoors_company].[Order Method].[Order
Method].[Order Method1]-&gt;:[PC].[Order Method (Root)].[605]</expression>
    </dataItem>
    <dataItem name="Camping Equipment">
     <expression>[great_outdoors_company].[Products].[Products]
		 .[Product line]-&gt;:[PC]
		 .[Products (Root)].[1]</expression>
    </dataItem>
    <dataItem name="Mountaineering Equipment">
     <expression>[great_outdoors_company].[Products].[Products]
		 .[Product line]-&gt;:[PC]
		 .[Products (Root)].[2~239]</expression>
    </dataItem>
    <dataItem name="Outdoor Protection">
     <expression>[great_outdoors_company].[Products].[Products]
		 .[Product line]-&gt;:[PC]
		 .[Products (Root)].[4~237]</expression>
    </dataItem>
    <dataItem name="Golf Equipment">
     <expression>[great_outdoors_company].[Products].[Products]
		 .[Product line]-&gt;:[PC]
		 .[Products (Root)].[5~236]</expression>
    </dataItem>
    <dataItem aggregate="none" name="Retailer type">
     <expression>[great_outdoors_company].[Retailer].[Retailer]
		 .[Retailer type]</expression>
    </dataItem>
    <dataItem aggregate="none" name="Year">
     <expression>[great_outdoors_company].[Years].[Years].[Year]</expression>
    </dataItem>
   </selection>
   <slicer><slicerMemberSet>set([Fax],[Web])</slicerMemberSet>
   <slicerMemberSet>set([Camping Equipment],[Golf Equipment],[Outdoor Protection])
   </slicerMemberSet></slicer></query>
 </queries>