give me scenario on cascading prompts&master-detail relation
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 are various types of gateways in cognos?
what is degenerate key in oracle ?whare do we use it?
how can you get the errors in job? when loops are araised we get error?
What is the use of powerhouse?
actually 2 members working in same module.at a time is possible to work on same module? i add some tables,another person also add some tables how the synchronization betn the two in same module? pls ans me and expain to me.....
What do you understand by the term ‘frame manager' in cognos and write all the layers of the framework manager model?
Explain the characteristics of cognos?
how to perform back drill through in cognos 8 what is the use of it
What do you understand by user class in cognos?
What are the steps to import the two data sources in framework manager?
Can you define cognos decision stream?
plsreply to me...im interested to do the cgnos certifications relating to report developer.can you suggest me what kind of certifications andwhere cani get (dumps) previous quetions and answers for the certification........
What is the function of cognos dispatcher?
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?
What is the difference between the content store and content manager?