How to create a dynamic column name in Cognos?

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is Online View?

1572


What are the methods by which it non-durable model could be changed into the durable model?

527


Can you define set to be cardinality?

591


What is the difference between a cascading report and drillthru report? Why do we go for drill thru report?

544


What project,model,parameter maps,namespace and database definitions....... what these are all contains? what are differences b/w them?

1670






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

3107


How to limit the cut,copy and paste operations for an user in reportlevel? Can anyone please send me the steps as i am new to cognos?

2163


Can you define confirmed dimension?

636


what is the main advantage of impromptu over cognos reportnet?

612


----------------Describe DWH Architecture?

1654


i'm searching on cognos..i want to know real time scenarios..persons having real time exp or undertaking trainings or who searching on cognos...can send me the details...for proper guidence..for project and interview preparation..pls help me out..my mail-id is ammu2india@gmail.com..hope u will respond as soon as possible..thanks..

2257


What is dtm?

719


How to do Performence Tunning in Cognos Reports?

2077


After applying date prompt and when we run the report we fet from date and todate prompts..so when we enter todate

1604


Explain informatica architecture?

564