Interested to Buy Any Domain ? << Click Here >> for more details...
give me scenario on cascading prompts&master-detail relation
- 4 Answers
- 18253 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 function of cognos dispatcher?
What is cognos reporting tool?
How can we import Excel data in to FWM?Wt is mean by Ragged dimensions?where can we observe the Regular dimensions & measure dimensions?
What is the model filter?
Name the types of report?
How to a create header dynamically in a crosstab report in cognos 8.1?
Hi experts,Recently I faced one questions in MNC,They having 4 tables in FM ..One fact table CALLING X, Remaining 3 tables are there not fact calling y,z etc...We want to join individually from X to Y..please suggest.
Which studio is used to create reports?
What is Fullouterjoin?
What are all the types of hierarchies?
Hi Buddies...i am lalitha. i am willing to appear for cognos bi-author certification. can anyone of you send me cognos dump. please please help me.
in single column there is india and malaysia and uk canada and dubai,saudi.ok i need using valuable prompt i select asian country will be display india malaysia and i will select eurobe country only display uk canada.pls tell me any how do set this concept using valuable prompt
Mention the difference between ‘macros’ and ‘prompt’?
----------------Diff b/w Dimensional modeling and Relational modeling?
How we check the errors before running the report?
