COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: backhandx on 21 Feb 2017 09:16:56 AM

Title: Filtering attribut in dimensional reporting
Post by: backhandx on 21 Feb 2017 09:16:56 AM
Hi all,

I am wondering if it is a proper way to filter using attribut of a hierarchy ?

Thanks,
Title: Re: Filtering attribut in dimensional reporting
Post by: MFGF on 21 Feb 2017 09:31:13 AM
Quote from: backhandx on 21 Feb 2017 09:16:56 AM
Hi all,

I am wondering if it is a proper way to filter using attribut of a hierarchy ?

Thanks,

Hi,

It's certainly required at times. Don't be tempted to use a detail filter, though. Instead, use a dimensional expression utilising the filter() function.

MF.
Title: Re: Filtering attribut in dimensional reporting
Post by: BigChris on 21 Feb 2017 09:48:55 AM
QuoteDon't be tempted to use a detail filter

If you do that you'll be met with saddened faces and the gentle shaking of heads. There might even sharp intakes of breaths, and in some cases the sucking of teeth. People might even rush to suggest that you read the postings of CognosPaul and others on the subject. The more generous posters will kindly put an arm around your virtual shoulder and explain the error of your ways...the less so will laugh behind their hands and turn their backs on you as you flounder in a morass of misleading outputs.
Title: Re: Filtering attribut in dimensional reporting
Post by: Lynn on 21 Feb 2017 10:00:35 AM
Quote from: BigChris on 21 Feb 2017 09:48:55 AM
If you do that you'll be met with saddened faces and the gentle shaking of heads. There might even sharp intakes of breaths, and in some cases the sucking of teeth. People might even rush to suggest that you read the postings of CognosPaul and others on the subject. The more generous posters will kindly put an arm around your virtual shoulder and explain the error of your ways...the less so will laugh behind their hands and turn their backs on you as you flounder in a morass of misleading outputs.

;D ;D ;D
Title: Re: Filtering attribut in dimensional reporting
Post by: hespora on 22 Feb 2017 02:10:02 AM
Quote from: BigChris on 21 Feb 2017 09:48:55 AM
If you do that you'll be met with saddened faces and the gentle shaking of heads. There might even sharp intakes of breaths, and in some cases the sucking of teeth. People might even rush to suggest that you read the postings of CognosPaul and others on the subject. The more generous posters will kindly put an arm around your virtual shoulder and explain the error of your ways...the less so will laugh behind their hands and turn their backs on you as you flounder in a morass of misleading outputs.
Say, are you for hire? I need something like that whenever I have to tell my consumers that what they want isn't feasible. ;)
Title: Re: Filtering attribut in dimensional reporting
Post by: BigChris on 22 Feb 2017 02:22:18 AM
Birthdays, weddings and bah mitzvahs...I'm here all week, try the veal  ;D