How to create a dynamic column name in Cognos?
Answer Posted / fernando
I came across this answer because I wanted each column in a
cross tabulation to have a text description different from
the variable (column's) name.
Cognos's gloriously useless documentation says nothing on
how to do this and adding text isn't an allowed action in
page design mode (the error message you get goes beyond
unhelpful).
To have the column titles, row footers, etc., you want:
1)Switch to page structure view in report studio
2) expand the crosstab by clicking the plus signs until
crosstab row levels, crosstab level(variable_name), etc. are
visible
3) from the insertable objects, drag a 'Block' at the level
you'd like to add the text. This takes some experimenting
4) after the block's been added, add into the block a Text
Item from the insertable objects
5) a window will open and you can type in whatever text you
want.
It's no wonder Jim Goodnight has such harshness towards Cognos.
Cheers
| Is This Answer Correct ? | 3 Yes | 6 No |
Post New Answer View All Answers
can anybody explain me about sales project in cognos..wt is the requirement,how u get the requirement..explain me any one based on ur experience as a report developer..how much time u will take to complete one project,single person in a team have to do how many reports..in a real time how much time will take to complete reports ie..one single report.. (simple and complex report)and in real time ur project contains how many fact tables and dimension tables..how many query subjects and query items..wt functional area u worked on.. hope u vl respond as soon as possible ..my mail- id is ammu2india@gmail.com
What is defined as Cognos Impromptu?
How can we Maintain the Cube Security by Category level and Dimension level ?
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!
What is the difference between Section and Section using Master/Detail in Cognos 8 Report Studio? I tried these both options many times on lists and crosstabs, but dint find any difference. So please give the answer in detail with example.
what is online view?
How can we import Excel data in to FWM?Wt is mean by Ragged dimensions?where can we observe the Regular dimensions & measure dimensions?
Explain the different types of views used in cognos.
After applying date prompt and when we run the report we
fet from date and todate prompts..so when we enter
todate What is called materialized view? what is the main advantage of impromptu over cognos reportnet? Explain about scorecarding? How can reports be bursted based on two groups? I want to
schedule to burst a report based on product line and years
and I need the burst report for every product line and
every year. How can this be done? Please help.. What is meant by junk dimension? What is the difference between the standard and metrics folder?