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
How Metrics Studio is better than Report Studio?
What are the other methods working as deployment functionality?
What are all the types of hierarchies?
plsreply to me...im interested to do the cgnos certifications relating to report developer.can you suggest me what kind of certifications andwhere cani get (dumps) previous quetions and answers for the certification........
Cognos Online Training will be provided. prior training with all real time aspects. Comprehensive training will be given in Datawarehousing concepts , cognos 8.4 and cognos 10 versions. Contact kris.cognos25@gmail.com
faq's on cognos
What is called Cognos powerplay?
After applying date prompt and when we run the report we
fet from date and todate prompts..so when we enter
todate ------------- How to identify the Revenue Column in Report?
how the values be passed to prompts in report studio?
when a data item is dragged n dropped in to report, after
the default query generated first which sql will the query
query hit for processing means (native or cognos)?
plz answers to these questions? What are all the types of indexes in Cognos? What is Additive function? What is the use of powerhouse? Which lifecycle we will use for reporting? 1. We have been asked to add summary information to
sales reprasentatives performance report. The report needs
to be grouped by country and city to compare performance
between areas Also we need to include revenue totals for
each city and each country.