COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: inu on 13 Mar 2014 11:46:06 PM

Title: can we use detail filter in dimensional report
Post by: inu on 13 Mar 2014 11:46:06 PM
Hi
If i want to filter the data in dimensional report, then can we use detail filter for it. OR slicer member set only can be used for filtering the detail level data.
Whatever we are writing in the expression of detail filter in relational report. the same code can we write in slicer member set expression editor. OR any other function i need to use to resolve this problem.

Thanks
Inam
Title: Re: can we use detail filter in dimensional report
Post by: navissar on 14 Mar 2014 02:54:55 AM
Quote from: inamulhaque on 13 Mar 2014 11:46:06 PM
Hi
If i want to filter the data in dimensional report, then can we use detail filter for it.

NO.
See here a good explanation of why: http://www.cognoise.com/index.php/topic,18290.msg53585.html#msg53585 (http://www.cognoise.com/index.php/topic,18290.msg53585.html#msg53585)
As for the rest of your questions, I suggest you familiarize yourself with dimensional functions.
Title: Re: can we use detail filter in dimensional report
Post by: BigChris on 14 Mar 2014 03:30:47 AM
You beat CognosPaul to it Nimrod!  ;D
Title: Re: can we use detail filter in dimensional report
Post by: navissar on 14 Mar 2014 03:47:45 AM
Paul sometimes contracts stuff off to me :)
Title: Re: can we use detail filter in dimensional report
Post by: MFGF on 14 Mar 2014 03:53:09 AM
Aha! A tag team! :)
Title: Re: can we use detail filter in dimensional report
Post by: BigChris on 14 Mar 2014 04:27:37 AM
With the time difference between them they can probably slap would be filter users of dimensional data 24/7
Title: Re: can we use detail filter in dimensional report
Post by: navissar on 14 Mar 2014 06:15:06 AM
Actually, at any given point in time, Paul and I aren't likely to be more than half an hour away from each other by car.
Title: Re: can we use detail filter in dimensional report
Post by: MFGF on 14 Mar 2014 11:28:58 AM
Quote from: Nimrod Avissar on 14 Mar 2014 06:15:06 AM
Actually, at any given point in time, Paul and I aren't likely to be more than half an hour away from each other by car.

Rumour has it that Paul's driver is so fast that he's never more than half an hour away from anyone on this forum by car ;)
Title: Re: can we use detail filter in dimensional report
Post by: navissar on 15 Mar 2014 04:39:47 AM
Paul doesn't need drivers. He's Linux.