Interested to Buy Any Domain ? << Click Here >> for more details...
give me scenario on cascading prompts&master-detail relation
- 4 Answers
- 18100 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / pavan kumar
CascadingPrompt-: A Prompt which displays the values from
another prompt is known as cascading prompt.
Master-Detail RelationShip: Two data containers can be
merged using common query item.
Procedure: Add the following query items to the list
ordernumber,ordername,Staffname and revenue.
2.)From tool bar drag the list drop beside the revenue,Add
the following query items to the second list
ordernumber,productname,description and quantity.
3.)From Second list select ordernumber from tool bar click
on cut.
4.)Create a total on quantity.
5.)From Data Menu Select Master-Detail RelationShip click
on new link from Query1 select ordernumber Query2 select
ordernumber.
6.)Create a group on staffname query item, Create a header
on staffname query item.
7.)Delete the staffname header cell,format the header which
is created.
8.)From run menu click on run the report.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What is the difference between Standard and Metrics folder?
what is the use of backward drilling in cognos 8?is it possible?whats the uws of it?
write a query to display the departments with no employee?
How is possible this scenario using in type-in prompt.?
What is defined as data mining?
What is the use of powerplay web viewer in cognos?
Helow, i have a problem with runing-total function when i use it for a calculate row (for example : i need to diplay a running-total of total units ?)
Explain the different types of views used in cognos.
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?
How can I test reports in cagonos?
what is the difference between filter and condition?
what is log in cognos?
What is a Transformer?
Looking for IBM COGNOS Certification C1000-065 , C2020-605 , C2090-621 , C2090-623 Dumps?
Actually we have 500 users when they run the report display the flage image related country user? How its possible?
