Print Page - iam not able to create columns

Title: iam not able to create columns
Post by: anilkumar on 21 May 2011 07:48:01 AM

Hi to all

i brought required tables from database in to FM for the report

in one table contains BAL_TYPE COLUMN(balance types CONTAION VALUES like 1,2,34,52,60)

now i want to use this BAL_TYPES AS Different colums in my reports, iam not able to filter it.

please help me
Thanks & Regards
Anil kumar .Marri

Title: Re: iam not able to create columns
Post by: blom0344 on 22 May 2011 01:32:09 PM

If this is a non-fact, then set usage to attribute. Cognos has the nasty habit of setting numerical values (except keys) to usage fact. (Matter of fact, the default is such that all dataitems can be used as filters). What do you mean by 'Different columns' ?

Title: Re: iam not able to create columns
Post by: anilkumar on 23 May 2011 04:04:24 AM

thank You bloom

if i set data item usage property as attribute one column data will disply , if drag one more column it wont display any data

in one table contains Column Name Is BAL_TYPE (This BAL_TYPE Contains VALUES like 1,2,3,4,,60)
here 1 means EOP ,2 means AVERAGE , 3 means P&L)
Now Iwant to display as columns, iam not able to differentiate

Balance types(which shown in the bracket) different colums means 1 is one column, 2 is another column like that in the report

If iam wrong please correct me

Regards
Anil K.Marri

Title: Re: iam not able to create columns
Post by: anilkumar on 24 May 2011 03:25:10 AM

please any one

Thanks & Regards
Anil K.Marri

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: anilkumar on 21 May 2011 07:48:01 AM