Cognos Limitation

[ManojCognos]

I am working on Cognos Impromptu 6.0, I have few query I will really
appreciate if you give me solution soon

1) Can we output 270 column in Cognos Impromptu 6.0
2) If yes, how to export data in Excel in differnt worksheeet
3) I have cross tab report
Pay element
pay element id
cost code no | Total amount

when I add cost code (numeric column) in cross tab report it show as count of that particular column whereas I just want to display that number as it is I hope this will be clear to you

 

[christenhusz]

hi,

1. you can but for what reason???
2. with a macro you can
3. sorry not clear...

christenhusz

 

[ManojCognos]

1. I am generating report for Payroll & finance team they require that the report contain this many column
2. If u have macro available do send me
3. I have a cross tab report which is
Pay element desc
pay element id
EES | ERS
Empl No. | Emp Name


explanation :
Pay element desc = It is a pay element description(character) which is a column in the report

Pay element id = It is a pay element id(numeric) for each payelement description which is also shown in column

for each employee pay element has been divided into two column that is employee deduction(EES) & Employer deduction (ERS) with some calculation for each EES & ERS
If u still not clear do let me know.