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
- 4106 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
please explain me with the real time tables on how aggregate tables are created and how aggregate awareness is addressed to it.
how to create reports on screech?
Which command using Query Analyzer will give you the version of SQL server and operating system ?
Explain how can we do load testing for webi reports? (Example if I have have to test one webi report for concurrent users refreshing report at one time)?
What three things do you consider to be the most important factors for a manager?
Explain is there any tool that can compare two unvs / two rpts , built using bo 5.1 / bo 6.5?
If there are no indices defined on any of the columns in the above two tables, which columns would you index to speed up the left join query?
Explain what are the measure objects?
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?
Can we create universe with no cache??
What is the difference in creating filters in designer and business objects?
What's the Functional & Architectural Differences between Business Objects & Web Intelligence Reports?
8. How much supervision have you typically received in your previous job?
What is the difference between absolute and relative div positioning?
Differences between business objects and web intelligence reports?
