Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 4074 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 can you access your repository with different user profiles?
What is the difference between the public object&schema object?
Hi, difference between loop and trap in business objects ? Thanks in Advance nvsraghu
What is ment by For each For all function. In which case we use the option in BO?
I have Startdate,enddate objects in querypanel and prompt on those objects.how would i get before 2 years data,if i run that query.
How to view Public folder in Infoview for the Non-admin user? (normal user) What is the diff of working DEKI,WEBI in Infoview, and working as Individual start->Business Objects-> Deskto Intelligence, Web Intelligence.
Give some information on report bursting and how to do it in bca as I have to split the report and send diff reports to diff people?
what happens if cardinalities are not resolved?
What are steps to be taken care to create a good Universe?
What is object stores?
Difference between zabo and webi?
CAN ANY BODY TELL WHAT FUTURE CAREER IN BUSINESS OBJECTS?
Teradata 
