How to create a dynamic column name in Cognos?
Answer Posted / pamir
These are the steps -
i. Create a calculated column which contains the
information that the header is to contain, such
as "Report for year 1999" (concatenated text and
date to string sub string extraction).
ii. Highlight the report, and then right-click.
iii. Select Properties, and then click the Headers/Footers
tab.
iv. Clear the Column Title Header check box. This will
remove the headers from your columns.
v. Reinsert the rest of the column headers; insert text
will work.
vi. For the dynamic column, from the Insert menu, click
Data and select the calculated column you created and
insert it into the report.
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
my table having data like this year month revenue 2011 jan 100 2011 feb 200 2011 mar 150 like this i want My report 2011 jan 100 2011 feb 100+200=300 2011 mar 300+150=450 like this for this where we specify the condition how will specify? pls ans me pls...
---------------Describe OLAP Reporting and RDBMS Reporting?
How can I test reports in cagonos?
what are the difficult problem are you involved in cognos report net and 8 and impromptu if any pls share with us
What is looping and how to avoid it in framework manager?
faq's on cognos
What are the advantages of shortcuts?
what is the use of backward drilling in cognos 8?is it possible?whats the uws of it?
Can you explain cognos planning?
HI, If anybody is having C2020-625 - IBM Cognos 10 BI Data Warehouse Developer, kindly send the same to shiju.rajs@gmail.com. Thanks
What do you understand by the term 'aggregate advisor?'
i'm searching on cognos..i want to know real time scenarios..persons having real time exp or undertaking trainings or who searching on cognos...can send me the details...for proper guidence..for project and interview preparation..pls help me out..my mail-id is ammu2india@gmail.com..hope u will respond as soon as possible..thanks..
How can we import Excel data in to FWM?Wt is mean by Ragged dimensions?where can we observe the Regular dimensions & measure dimensions?
what are the limitations of cognos reportnet? What are the enhancements in reportnet ?
Explain the difference between native sql and cognos sql?