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
------------ Diff b/w MemberCaption and MemberDescription?
What is defined as catalog and types of catalogs in Cognos?
How to join multiple db in catalog?
what is the difference between filter and condition?
What are the ways to import data into catalog?
what is model and say about process how to create model and how to test model?
What is meant by drill down?
7. What is performance tuning?
what are the features in cognos8ui
how to perform back drill through in cognos 8 what is the use of it
All ready we have alias tables for modifications why we are using views if anybody this answer plz reply me
Why is auto-regression used in forecasting used on cognos platform?
What is Online View?
how you burst the reports? If you are bursted reports is not reached to destination how you identify?when you import data into catalog you have complex columns names.how do you change the name of those columns?
What are all the different types of prompt in cognos?