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
- 4183 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
How can you first report in Business Objects by using broadcast agent?
Is there any tool that can compare two unvs / two rpts , built using bo 5.1 / bo 6.5?
Explain what are the steps to do to use alerts in bo?
When to use local filter and when to use global filter?
Explain is data mart?
What is top business?
Explain about a task that really tested your analytical abilities?
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)?
Explain about a time when you discovered a more efficient way to do a work task?
how to prepare the documentation in business objects and where to get the requirement?
Explain is there any other repository domains rather than universe, security, document?
In banking domain how many Fact tables,Dimension table are present?
What's the Functional & Architectural Differences between Business Objects & Web Intelligence Reports?
If I have three predefined prompts. In a report it will come randomly. How they will come in a specified format?
How to create a new calendar in CMC? Can u please tell me the process to create the required calendar. Ex:- Year of that calendar to start with Jan-15 and ends with Jan -30 and the Next month to start with Feb-31 and ends with Feb-14.
