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
- 4076 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 we drill up week to month?
Explain is there any default username & pwd for bo designer & supervisor?
Explain when we use aggregate awareness function in designer?
Then how to select the source by using webi or deski reports into crystal reports? i think main source is Businessview. where u import the datasource ?
WHAT ARE THE META DATA TYPES?WHICH META USING IN BO'S
What is the difference between absolute and relative div positioning?
Hi, I would like to know how is the integration if we want to use Oracle Essbase as the Cube Engine, and present the Cube by Business Objects Presentation Layer? Can Oracle Essbase be integrated with Business Objects? Thanks,
If I have three predefined prompts. In a report it will come randomly. How they will come in a specified format?
What Is Snow Flake Schema?
Explain difference between zabo and webi?
What are the join problems comes appart from loop,chasm & fan Traps
U r project in which stage in implementation?
What are the general problems that are faced while importing the .biar files and what is the solution to overcome it in business objects?
What are all difference between business objects 6.5 and xi r2?
What are the steps to do to use alerts in bo?
