How to create a dynamic column name in Cognos?
- 6 Answers
- 36402 Views
- Aditya Birla, Polaris, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / lakshmi
We can use variables for dynamically displaying column name.
In our project we given three dimensions in the prompt
value, user can switch to the dimension that they want to
see in the report.
Consider 3 dimensions A, B and C, Users want to see
measures in the report based on what is the dimension they
have selected in the report prompt having A, B and C
dimensions.
By using the Case Statement we can switch between the
dimensions
Create Dataitem as follows
Case
When ?p_Dimension?=A Then [A] (Directly take from
model)
When ?p_Dimension?=B Then [B] (Directly take from model)
When ?p_Dimension?=C Then [C] (Directly take from model)
End
This will automatically pick up the Dimension query item
names from the model based on User’s selection to display
as column name.
| Is This Answer Correct ? | 11 Yes | 1 No |
Answer / pamir
These are the steps -
i. Create a calculated column which contains the
information that the header is to contain, such
as "Report for year 1999" (concatenated text and
date to string sub string extraction).
ii. Highlight the report, and then right-click.
iii. Select Properties, and then click the Headers/Footers
tab.
iv. Clear the Column Title Header check box. This will
remove the headers from your columns.
v. Reinsert the rest of the column headers; insert text
will work.
vi. For the dynamic column, from the Insert menu, click
Data and select the calculated column you created and
insert it into the report.
| Is This Answer Correct ? | 5 Yes | 0 No |
Answer / omkar b ambulkar
In cognos 8.0, First create a Calculated Data Item, select
the list, associate it with the Query in Which Calculated
Data Item is created, then click on Structure and then List
Header and Footers. Check List Header and make the Box Type
of the Column header as None. Unlock and then drag the
Calculated Data Item into the required header which will
look like a Column Header in the report.
| Is This Answer Correct ? | 7 Yes | 2 No |
Answer / joydeep mukherjee
For making a column name dynamic the only thing that you
have to do is insert a layout calculations from the toolbox
tab in report studio.
| Is This Answer Correct ? | 3 Yes | 3 No |
Answer / nasa
for example i have the date items like 'first name' and
'last name' now i want to display 'full name'. so here 'full
name' became as a dynamic column bcz its not available in
packages.
steps:
report studio->create new report->list-> drag and drop
'firstname' and 'lastname' from staff_names query table.
now drag a QUERY CAL from toolbox and drop next to last
name.
it will ask a column name, give as a FULLNAME
in expression window write expression like firstname|| ' '||
lastname -> ok
save and run it...
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / 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 |
-----------What is member Description?
You get a parsing error when you run a report. What will be your first steps to resolve the error?
Actually we have 500 users when they run the report display the flage image related country user? How its possible?
----------------What is Scopr Relationship?
These are few Interview questions i faced.I hope to get help here. 1.Can we convert a Crosstab to List? 2.How do you approach and who tells you what exactly the way report has to be developed so that i meets the client requirements? 3.Can we link the List and Chart thats created in the same report? 4.Where do you edit sql in cognos8 ? 5.What is the difference between native sql and oracle sql? 6.What is the difference between MOLAP and ROLAP? 7.What is the use of BI in datwarehousing? 8.What are set functions? 9.How do you test a report? 10.What are the variables you find in toolbox? 11.How many types of filters are there in cognos8? All the answers r welcomed .U can reach me at vinod.davala@gmail.com
What is Normalization?
There is any option to delete temp files automatically from temp directory in COGNOS? (without manual)
What is difference between page break and section report?
What is the information present in the cognos configuration file?
Hi, I Want To Display The Report. From MOnday To Friday By Using Date Prompt.PLs Expain To Me...
how you burst the reports? If you are bursted reports is not reached to destination how you identify?when you import data into catalog you have complex columns names.how do you change the name of those columns?
im having a value prompt, in that value prompt im having the values as ABC and CDF, i want to hide the select box in that value prompt? is it possible in cognos?
Teradata 
