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
- 3418 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 |
who r the users in B.O.XIR2?
what r the types of joins universe supports
Did you face any problems while creating reports? Name? Solutions?
CAN WE CREATE VIEW IN BO (NOT DERIVED TABLES)?
What is the link option in the reporting Environment?
Explain the difference between detect alias and detect context?
it is possible to link two universes of separate functional domain ?
1. What is the difference between in creating filters in designer and business objects? 2.How did u give a developed universe to your client? 3.If i want to grant access to a report to a group of users,how do i do?
Example of how the fantraps and chasm traps works?
What are the advantages of Xcelsius & Crystal reports over Infoview?
what is tuning of business reports ?
5 Answers Business Intelligence Analytics, Oracle, TCS,
Example Country Name is like India/UK or ALL In parameter I selected India or UK it should show only perticular country details in BO.If i select ALL in parameter.It should show both country data in different tables.
Teradata 
