Interested to Buy Any Domain ? << Click Here >> for more details...
give me scenario on cascading prompts&master-detail relation
- 4 Answers
- 18110 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 |
What is a Transformer?
How to find out OLTP data OLAP data ? i.e 5 years data is OLTP or OLAP. please anybody help me...
i'm searching on cognos..i want to know real time scenarios..persons having real time exp or undertaking trainings or who searching on cognos...can send me the details...for proper guidence..for project and interview preparation..pls help me out..my mail-id is ammu2india@gmail.com..hope u will respond as soon as possible..thanks..
can you apply grouping on crosstab?
if ur report having report filter save the report.open u r report in cc the report filter doesnt work means it does n't any values what we do for this situation?where we rectify this?please please ans me......
Difference between Express authoring mode and Professional authoring mode?
plz giv ans . user1 developed some repot ,user2 modify the same report and user 3 also some updates in that same report ? how to indentify that report will be modified r not ?
what are burst options you have?
------------- How to identify the Revenue Column in Report?
What is Index?
How to test a cube?
what are the dimensions that you have in your current project?list them?
Teradata 
