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


Please Help Members By Posting Answers For Below Questions

-------------What is Coditional Prompting?

1581


What is model filter?

620


What you mean by drill across?

604


How can create users and permissions in cognos?

551


What is the diff between cognos 8.1 & cognos 8.2 & cognos 8.3? Measn whet are the enhancements are added in new versions(8.2& 8.3)?

3911






What is the difference between low affinity and high affinity connections?

544


What do you understand by ‘ibm predictive maintenance and quality’?

558


Looking for IBM COGNOS Certification C1000-065 , C2020-605 , C2090-621 , C2090-623 Dumps?

640


Can the expiration parameter of 365 in the cognos 8 configuration how to increase common symmetric key lifetime in days

3142


what are the dimensions that you have in your current project?list them?

1594


Name the types of gateway?

589


Can you explain the advantage of using shortcuts?

603


WHAT ARE THE DISTNICT VARIABLES?

1739


What is meant by alternate drill down with ex?

614


what are the features in cognos8ui

1551