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
describe the starschema grouping ?how can i add a new column for existing report ,when it is not present even in model & dataabase?
WHAT IS METRIC STUDIO?WHAT IS SCORE CARDS HOW TO IMPLEMENT IT AND WHAT IS THE USE OF SCORE CARD?
What are the two types of framework manager?
How is possible this scenario using in type-in prompt.?
What do you understand by the term ‘frame manager' in cognos and write all the layers of the framework manager model?
What do you understand by the term 'dynamic cube'?
Name the types of report?
what is the role of cognos comsultant?what actually it means?pls reply
How can you link a query to a data container manually in Report Studio?
What is a Query Subject?
Is it possible to join multiple Databases in a Catalog?
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..
------------- How to identify the Revenue Column in Report?
What is the difference between static and dynamic conditions?
Define report item?