| |
GeekInterview.com > Interview Questions > Data Warehousing > Cognos
| Print | |
Question: How can I create a dynamic column name in Cognos
Answer: 1.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).
2.Highlight the report, and then right-click.
3.Select Properties, and then click the Headers/Footers tab.
4.Clear the Column Title Header check box. This will remove the headers from your columns.
5.Reinsert the rest of the column headers; insert text will work. For the dynamic column, from the Insert menu, click Data and select the calculated column you created and insert it into the report. |
| January 01, 2008 23:38:03 |
#8 |
| binay.bk |
Member Since: January 2008 Total Comments: 4 |
RE: How can I create a dynamic column name in Cognos
|
Hi Dear
Dynamic column is same as Hiding of a column.
Select the required column in your report.
Go to it's property.
Set the Box Type as "None"
Then you can see that the selected column is hidden.
|
| |
Back To Question | |
