COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: ambuj2k50 on 24 Mar 2012 01:54:27 AM

Title: Slicer and Context Filter
Post by: ambuj2k50 on 24 Mar 2012 01:54:27 AM
What is the difference between Slicer and Context filter. What are there uses.
Title: Re: Slicer and Context Filter
Post by: navissar on 24 Mar 2012 09:47:21 AM
Well, by and large, a slicer will filter your data by a set of several members from the same hierarchy. A context filter is a simple filter that will only filter your data based on one member from the same hierarchy.
So, if you're displaying sales by region and year, but you only want to display data for a specific product, you can use a context filter with the member representing that product. If you would want to see the data for more than one product, you'd ue a slicer that returns the result of set(prod1,prod2,prod3) and so on.
It of course gets more complicated, but that's the basics - whenever you require more than one member in your filter, or a more complex calculation (e.g. show data for all products besides a selected product) you'll want to use a slicer.
Title: Re: Slicer and Context Filter
Post by: ambuj2k50 on 25 Jul 2012 05:18:54 AM
Thanks  :)