Interested to Buy Any Domain ? << Click Here >> for more details...
give me scenario on cascading prompts&master-detail relation
- 4 Answers
- 18120 Views
- IBM, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / venkee
Cascading Prompt:
Prompts on Country, State and City
Prompt1: Country, Prompt2: State, Prompt3: City
Prompt2 will depend on Prompt1 and Prompt3 will depend on
Prompt1.
ex: Select India in Prompt1, then Prompt2 display only the
states related to India, select AndhraPradesh in Prompt2
then Prompt3 display only cities in Andhrapradesh.
| Is This Answer Correct ? | 13 Yes | 0 No |
Answer / 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 |
Answer / khushbu
Master detail relationship:
drag data items in list and ulock,add another list inside the 1st list add data items which should contain at list one common data item so that link on this item can be created from data menu--->master detail relation ship.
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / ieg.prakasam
Cascading Prompts means geting the value from other prompt,
Master-detail relation means combining two lists with
common query item.
| Is This Answer Correct ? | 1 Yes | 0 No |
how u publish the packages in framework manager
1. What is stiched Query 2. What is loop in Fm 3. Best practices in modeling in FM 4. Three types of SQL 5. Difference between pass-thro and native sql? 6. will usage of pass thro sql will improve the performance? 7. Complex problems fced in your project 8. performance tuning in reports
What is portal page?
at what level u prepared the reports in cognos???? in dataware housing what is the automation tool u r using???
1 Answers Covansys, IBM, Wipro,
how you provide security to reports? How you provide security to packages ?
What is the complex report you faced in real time?
Where do i get Free COGNOS 8 Certification Dumps Downloaded for these codes COG-105, COG-112, COG-122, COG-125, COG-132, COG-135, COG- 142, COG-145, COG-180, COG-200, COG-205, COG-300, COG-310, COG-400, COG-480
17. How can we display tabs in the report Footer (Ex; PAGE 1 2 3 4 5...last)?
What is the use of Tree Prompt? Where it is used?Pls give me a real time example?
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.
1. Differences between Merge and Union In Cognos?
how to create measures and dimensions?
Teradata 
