HI i have a table with 4 columns in back end like sales id,
sales revenue, order id and order amt. Now i have created 2
prompts at query level 1st on sales id and 2nd on order id.
Now if i run the report for 1st prompt it has to display
sales id and sales revenue. Then if i run the report for 2nd
prompt then it has to overwrite the table with Order ID and
order amount. How you will handle this?
- 1 Answers
- 3410 Views
- I also Faced
- E-Mail Answers
Answer / gowthami
Sub Query 1:
Result objects: sales id, sales revenue
Filter: sales id – prompt
Union
Sub Query 2:
Result objects: order id, order amount
Filter: order id – prompt
Now union logic will be applied at query. If you select value for order id it will display the data related to that id, if you select sales id in the filter then sales data will be displayed. Common filters will be displayed to select the data
| Is This Answer Correct ? | 0 Yes | 0 No |
how u link universes of same functional domain ?
2 Answers Business Intelligence Analytics, IBM,
Let me know the things we can do in webi and cannot do it in full client and vice verse for bo6.5?
I have a column contains a data like A,A+,A++,B,B++ how u going to sort ther data?
WHAT IS THE DIFF BETWEEN BO6.5 AND BOXI
What are the types of errors you faced while creating a report from two different data providers
is there any limit for rows and columns in cross tab
Can We customize the Business Object infoview in BO?
What is the merge dimension?
Hi I am starter in BOXIR2.CAn anyone plz tell me the user identification details to be entered at the time of login to designer/deski
What are steps to be taken care to create a good Universe?
Can we use unconnected lookup as dynamic lookup?
generally how do we get information for creating universes and reports
Teradata 
