Print Page - How to filter Accounts that ends with 000 in Dimensional Reporting

Title: How to filter Accounts that ends with 000 in Dimensional Reporting
Post by: cognos05 on 21 Oct 2015 09:45:13 PM

What function can I use to filter Accounts that ends with "000".

Thanks,
Nithya

Title: Re: How to filter Accounts that ends with 000 in Dimensional Reporting
Post by: BigChris on 22 Oct 2015 01:55:44 AM

right([AccountNumber],3) = '000'

I'm assuming the you're talking about a relational model and that the right function is available in your environment (you don't say if you're using SQL, Oracle etc.)

Title: Re: How to filter Accounts that ends with 000 in Dimensional Reporting
Post by: MFGF on 22 Oct 2015 03:14:22 AM

Quote from: nithya1224 on 21 Oct 2015 09:45:13 PM
What function can I use to filter Accounts that ends with "000".

Thanks,
Nithya

Still using a dimensional package?

if so, how about

filter([your Accounts level], caption([your Accounts level]) ends with '000')

MF.

Title: Re: How to filter Accounts that ends with 000 in Dimensional Reporting
Post by: cognos05 on 22 Oct 2015 07:39:45 AM

Thanks , Ends with works !!

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: cognos05 on 21 Oct 2015 09:45:13 PM