Print Page - count

Title: count
Post by: srinu_anu2007 on 16 Aug 2012 07:07:21 AM

Hi,

below is the my requirement, iam unable to find

count([business layer]. [e].[z]) for distinct e's dat have the same [b.layer]..

Expla:Having 2diffrent tables and 2 columns are numbers
e and b ----- Tables
Z and x ----- columns those are numbers

these are my requirement can any one suggest on the same.

Thanks,
Anu

Title: Re: count
Post by: tjohnson3050 on 16 Aug 2012 08:00:05 AM

count(e for x)

The extension FOR allows you to control the aggregation grain level from inside the expression. Read the syntax tips for any aggregation function and you can see the FOR extension. Learning the FOR extension inside and out will greatly increase your ability to effectively report in Cognos.

Title: Re: count
Post by: srinu_anu2007 on 21 Aug 2012 04:46:06 AM

Thanks! for your valuable information.

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: srinu_anu2007 on 16 Aug 2012 07:07:21 AM