Interested to Buy Any Domain ? << Click Here >> for more details...
give me scenario on cascading prompts&master-detail relation
- 4 Answers
- 17923 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 to generate the Catalog in Cognos? Basically all post describing generating the Catalog from cognos impromptu . Is there any way to generate the Catalog using Cognos Administration or Framework Manager?
What is the use of Tree Prompt? Where it is used?Pls give me a real time example?
What is the use of report studio?
What are cognos connection initial page components?
How to create a cube in Transformer? What is the process? Please mention process thank u
Why cognos decision stream is used?
i am having a table having name cust_employee.i use this table in my model after i published that to cognos connection .i generate some reports. after that in my data base cust_employee table is changed to cust_emp.how can i get this table into my report.i again import and published means its time consuming,in simple how can get the changed table in to my model pls pls ans me....
What is the difference between set functions and filter function in dimensional data?
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.
What is the advantage of using shortcuts?
Hi, I got a requirement wehre in in a drill through report , in parent report i have a column of numbers on which i have to apply drill through to child report.The condition is in that column if the number ia not zero the drill through link should appear (i.e., 1 to 9) if its 0 or negative number link should not appear. How ? Help would be appreciated
what is catalog and types of catalogs in cagnos and which is better?
Teradata 
