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
- 4265 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 toconnect one to one report?
Explain about a tricky situation for which you found a very simple solution?
disadvantages of boxi
can any one say me exactly when and where alias and context are used in resolving a loop. If possible try to give me a scenario also.
whats the Diffrerence between business objects and cognos?
in report level u find from which context u use,why it appears,what is the reason,how u resolve in report level
Can we use unconnected lookup as dynamic lookup?
What is meant by data federator and what is the use of it?
how will you move the universe/report from development to production?
Can master data change???if yes then how it'll change.....please explain with example...... thanx
main purpose of aggregate awareness(not include make possible of use of aggregate tables)
in a database date formate is in dd/mm/yy. In my report I want when I prompt the date coloumn it should be displayed in (yyyy/mmm/dd)format. how could I do this plse send me as soon as possible.
Teradata 
