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


Please Help Members By Posting Answers For Below Questions

what are the limitations of cognos reportnet? What are the enhancements in reportnet ?

626


how can I test reports in cagnos?

648


how to perform back drill through in cognos 8 what is the use of it

2047


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)?

3927


write a query to display the departments with no employee?

1563






1)diff between shortcut-key and alias table? 2)what is unit testing? 3)what is scorecard?

3114


What is the deployment requirements used in cognos?

569


What is the difference between low affinity and high affinity connections?

561


2. What functional area you worked on.

1921


Is it possible to join multiple Databases in a Catalog?

653


What is meant by drill down?

531


WHAT ARE THE DISTNICT VARIABLES?

1759


how can you get the errors in job? when loops are araised we get error?

1668


-----------------What is Direct and Conventional loading?

1659


can you tell me what are the dimension tables are used in project

1895