Interested to Buy Any Domain ? << Click Here >> for more details...
give me scenario on cascading prompts&master-detail relation
- 4 Answers
- 17917 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
Can you define cognos powerplay?
can anybody explain me about sales project in cognos..wt is the requirement,how u get the requirement..explain me any one based on ur experience as a report developer..how much time u will take to complete one project,single person in a team have to do how many reports..in a real time how much time will take to complete reports ie..one single report.. (simple and complex report)and in real time ur project contains how many fact tables and dimension tables..how many query subjects and query items..wt functional area u worked on.. hope u vl respond as soon as possible ..my mail- id is ammu2india@gmail.com
What do you understand by the term 'aggregate cache'?
What is the difference between ‘macro’ and ‘prompt?
hi frnds any body have cognos projects plz send me two(or)three projects to my mail adress ramureddy.reddy4@gmail.com.
Mention the difference between ‘macros’ and ‘prompt’?
hi..i'm searching on cognos.i want to know some real time explanation..persons who have real time exp and who r searching in this field..can u send ur mail-id..my mail-id is dhaanuus@gmail.com..hope u will respond as soon as possible..
Why are meta service important then other services?
-----------------What is Determination Model?
Hi All, Is there any way to check whether a value is selected in a Multi-select tree prompt? I have a tree prompt and want to get to know whetehr which values user has selected,i want to so that values on the top of the report. I Have used that paramDisplayValue('paramername'),But it will display only last selected value. For Example i have tree prompt with one level Region- >country->states If user select region Asia it will dislay the all the Countries in that region and then if user select India it will display the states related to india only Suppose Hierachy look like this: Asia->India->Andhra Pradesh. I want to show this hierachy on the top of the report How it is possible? Can you please help me?
how the values be passed to prompts in report studio? when a data item is dragged n dropped in to report, after the default query generated first which sql will the query query hit for processing means (native or cognos)? plz answers to these questions?
How to create model and how to test model?
What are types of batch available in cognos?
what are the special features in cognos reportnet?
What is the use of powerplay web viewer in cognos?
