slicer

[Vick]

Can anybody tell me in what scenarios can we use slicer..Can it only be used with Dimensional Model or relational as well.

Thanks in advance,
Vick

[TJohnson]

A slicer is only for dimensional models (either cubes or dimensionally modeled relational data (DMR)).  It allows you to 'filter' out the result set from a multi-dimensional source.  For example, if you have a year dimension, if you drag a year member, say 2008 into the slicer pane, the query will be limited to just 2008 values.