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
- 4146 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 |
What is scope of analysis ?
How to link two different universes ?
How to make alternative rows red and green in WebI Report?
CAN ANY BODY PROVIDE DESCRIPTION OF ONE COMPLEX UNIVERSE AND ONE COMPLEX REPORT IN BOS 6.5 TO SRINIVASBO@YAHOO.CO.IN
What is a universe?
HI, can anybody explain me how performence will decrease if we create objects using derived tables ?
u drag 2 sources from 2 diff dataproviders,how we take these 2 sources into 1 single report, how we give the link these 2 sources
how do we schedule reports in WEBI? i want to schedule 3 reports consicutively....how can i achieve this
what is prompt? Cascading prompt? Syntax
how to increase the perfomance in ur designer & reporting? how to reduce the refershing time & what precations would u take ?
how to coneect to a server in a business objects
how to find the size of the report
Teradata 
