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
i have taken quantity on ANx-axis & months on y-axis(months r not in oreder )when i run the reoprt i need months in proper order .how can i do this ?
how many reports do u create in ur project?i don't have real time exp..tell me based on ur exp..for interview pt of view,don't say it depends on ur project and u? thanks in advance..
can we insert all types of charts in a list report? what r the realtime prompts?
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..
Can you define confirmed dimension?
Does anybody have the sample of delivery document of cognos, or provide some link of websites Thanks
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 is a Cube?
Explain is there any comparison available for cognos reportnet vs crystal reports?
Can you define cognos powerplay?
HI, If anybody is having C2020-625 - IBM Cognos 10 BI Data Warehouse Developer, kindly send the same to shiju.rajs@gmail.com. Thanks
Explain the difference between powerplay transformer and power play reports?
Explain informatica architecture?
How do you improve the performance of the Cognos Analytics report
Can you define report item?