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
What are all the types of gateway used in Cognos?
What is a Pivot?
what is the main advantage of impromptu over cognos reportnet?
What is dtm?
When we save a report in report studio with what extn it save?
Can you define cognos powerplay?
-------------How you design DWH?
can you tell me what are the dimension tables are used in project
explain how to create powerplay reports?
What are the steps to import the two data sources in framework manager?
What is looping and how to avoid it in framework manager?
What are the types of folder present in cognos?
Can you define materialized view?
What are the message flows?
A product manager is analysing the sales made for each product, he has requested a report containing data for specific products. To do this we will create a report that includes a prompt page that filters on specific products within specific product subcategory and category.