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
What is a Datastore in Cognos?
what are the filters in framework manager and report studio?
What is the use of Cognos scenario?
what is the role of cognos comsultant?what actually it means?pls reply
How to select multiple values from type-in prompt?
Can you define drill across?
What is a Pivot?
where you can save the report net documentation in our local system?
How to create a cube in Transformer? What is the process? Please mention process thank u
Please Answer this Questions: 1.In FWM We have to create Hierarchies, Condition is we don't know the correct levels in the Hierarchies, in this case how can we find out the levels (year->Quarters->month->day)in data? 2. In FWM Standalone Filter is for Reusable purpose & Embedded Filter we cant resuse.but is this possible to convert the Embedded filter to standalone filter? 3.What are the differences between Relational Database Model & Multi Dimensional Database? 4.In Drill Down/ Drill Up, How to specify the limits for example in a report there is 6 Drill down is possible, but i want only 3 Drill downs, the report should not allow 4 Th Drill Down.How to make this ? 4. What are the limitations in Select and Search Prompt ?
Can you define confirmed dimension?
What is the difference b/w macros and prompt?
What is drill down and slicing and dicing whats the difference between them?
Can you define cognos powerplay?
what is a prompt value in report studio and variables ?