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 are the limitations of cognos reportnet? What are the enhancements in reportnet ?
how can I test reports in cagnos?
how to perform back drill through in cognos 8 what is the use of it
What is the diff between cognos 8.1 & cognos 8.2 & cognos 8.3? Measn whet are the enhancements are added in new versions(8.2& 8.3)?
write a query to display the departments with no employee?
1)diff between shortcut-key and alias table? 2)what is unit testing? 3)what is scorecard?
What is the deployment requirements used in cognos?
What is the difference between low affinity and high affinity connections?
2. What functional area you worked on.
Is it possible to join multiple Databases in a Catalog?
What is meant by drill down?
WHAT ARE THE DISTNICT VARIABLES?
how can you get the errors in job? when loops are araised we get error?
-----------------What is Direct and Conventional loading?
can you tell me what are the dimension tables are used in project