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.

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.

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.

Answer / ieg.prakasam

Cascading Prompts means geting the value from other prompt,
Master-detail relation means combining two lists with
common query item.

using of matric studio we can developed to scorecard ... what is the meaning by scorecords

1 Answers  

---

In which types of reports does the page breaks applicable in Cognos...?

1 Answers   IBM,

---

3. Differences between Cognos Sql & Native Sql? What are their Advantages and Disadvantages?

3 Answers   CTD, Wipro,

---

what is the difference b/w mdx and sql?

4 Answers   Cap Gemini, IBM,

---

What is the diff between Drill through reports and Master detail reports?

2 Answers   CSC, TCS,

---

What is Additive function?

0 Answers   IBM,

---

Hi Experts, Can a single package be shared by multiple users?

3 Answers  

---

Name the types of gateway?

0 Answers  

---

what are slowly changing dimensions? Why we are used scd?

0 Answers   IBM,

---

A report is scheduled at 2am in the night... and the report contains 4 value prompts how it is going to be executed without selecting the values....if executed who is going to select the values from the value prompt

1 Answers  

---

drillthrough vs master detaild report,which one is the best by performance?

3 Answers   IBM,

---

what is mean by complex starschema ,star schemagrouping?

0 Answers  

---