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
How to create model and how to test model?
1.WHAT IS XML SPECIFICATION WHAT IS PURPOSE,WHERE YOU ARE GOING TO USE.2 DIFFERENCE BETWEEN RENDER VARIABLE AND CONDITIONAL BLOCK.3.WHAT IS LINK AND SEGMENT.4.WHAT IS CONDITIONAL LAYOUT.5. DIFFERENCE BETWEEN DETAIL FILTER AND SUMMERY FILTER AND HOW YOU ARE GOING DEFINE IN SQL (DETAIL AND SUMMARY FILTER ).. WELL THESE QUESTION I BEEN FACED IN IBM COULD SOMEBODY GET SOLUTIONS PLZ..THANKS IN ADVANCE
What do you understand by the term 'aggregate advisor?'
----------------Diff b/w Dimensional modeling and Relational modeling?
What is a Pivot?
what is stitch query in reportnet?
What is main difference mapplets and mapping?
Can you define metrics designer?
is there any difference between operational database and data base?if yes what r they?
What is difference between content store and content manager?
how to explain health care project and which reports we can create in health care doain?
if ur report having report filter save the report.open u r report in cc the report filter doesnt work means it does n't any values what we do for this situation?where we rectify this?please please ans me......
What is the difference between regular dimension and derminant?
What is the difference between ‘macro’ and ‘prompt?
describe the starschema grouping ?how can i add a new column for existing report ,when it is not present even in model & dataabase?