How to create a dynamic column name in Cognos?
- 6 Answers
- 37292 Views
- Aditya Birla, Polaris, I also Faced
- E-Mail Answers
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
After applying date prompt and when we run the report we
fet from date and todate prompts..so when we enter
todate
Hi, I have Cognos 7.0 Impromptu reports and these reports have been created with the Mainframe datasource. Now the business needs these reports should be upgraded but with Oracle datasource. So what's the idea, first we should migrate these reports into ReportNet? then in that case what we will do with the Impromptu Catalog? Second, suppose we need to migrate these reports into Cognos 8 (may be 8.4) then how we will do that? do we need to create a FM Model for these reports. Please advice!
1. Explain your project.
Explain what is the difference between microstrategy and cognos reporting tool?
What errors and types of errors you faced in Cognos ReportNet?
Can anyone give me the url for cognos forum which is similar to forumtopics.com/busobj for business objects?
I have 7500 rows. I need all rows in single reports. Which type of prompt we have used retrieving all rows and show in a report? We have dynamical queries q1, q2, q3, q4, q5. If customer selects the particular, query that only show in execution report. In case it may more then one, how do you execute the particular query item in report page? What are the difference bt OLDP and OLAP?
which type of project we r going to snowflake schema
We can use a calculated field to dynamically create the burst recipients in Cognos 8. Can we do the same in Cognos ReportNet 1.1?
What is the difference between Standard and Metrics folder?
dumps needed ASAP for - C2020-180 Cognos IBM Certification
What is the difference between a data mart and a data warehouse?
What do you understand by the cognos?
What are all the different types of prompt in cognos?
How do you Parametermap variables in Quiries?
