give me scenario on cascading prompts&master-detail relation

Answers were Sorted based on User's Feedback



give me scenario on cascading prompts&master-detail relation..

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

give me scenario on cascading prompts&master-detail relation..

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

give me scenario on cascading prompts&master-detail relation..

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

give me scenario on cascading prompts&master-detail relation..

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

Post New Answer

More Cognos Interview Questions

Can you define metrics designer?

0 Answers  


What are the differences between Cognos 8 and Cognos 7.x version?

2 Answers  


How to configure the Cognos configurations to work in the Windows 2000 Server machine?

1 Answers   IBM, Infosys,


what is the use of macros&folders&herarchies in frameworkmanger?

1 Answers  


Can u solve a small query on table the problem is whether it is possible to add extra cells for already existed table i.e if table contains 3 rows n 4 cols (3*4) it is possible to add another cell (4*4)

1 Answers  






How to pass multiple values from picklist prompt to sub report filter?

2 Answers   IBM, Infosys,


Q1. We have a crosstab report which is having product, region and Revenue information. Now the requirement is that we need to add a new column with the information 'High' and 'Low' just beside the Revenue column. If Revenue is high is should display as 'High' and if Revenue is low then it should display as 'Low'. Q2. If my Cube size is 2GB, now I have got the requirement to reduce it. What are the parameters I have to follow to reduce the cube size? Q3. How to get the 2nd highest salary of an employee without using any function (I mean without rownum etc.)? Q4. What is the difference between joins and scope relationship?

5 Answers   Mphasis,


faq's on cognos

0 Answers  


Hi is any one having link to download books on datawarehouse tool kit by ralph kimball or any other authors books.

5 Answers  


what is dimention?explain dimentable with example?

3 Answers   Syntel,


How to Reset Pagenumbers in one report.

0 Answers  


What are the differences between cognos 8.2 and cognos 8.4? Please help me..

1 Answers  


Categories