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
What is Online View?
What are the methods by which it non-durable model could be changed into the durable model?
Can you define set to be cardinality?
What is the difference between a cascading report and drillthru report? Why do we go for drill thru report?
What project,model,parameter maps,namespace and database definitions....... what these are all contains? what are differences b/w them?
1)diff between shortcut-key and alias table? 2)what is unit testing? 3)what is scorecard?
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?
Can you define confirmed dimension?
what is the main advantage of impromptu over cognos reportnet?
----------------Describe DWH Architecture?
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..
What is dtm?
How to do Performence Tunning in Cognos Reports?
After applying date prompt and when we run the report we
fet from date and todate prompts..so when we enter
todate Explain informatica architecture?