Sign Up Login


  1. Categories >> Software >> Data Warehouse >> Business Objects
  2. Suggest New Category

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?

Question Posted / suresh kumar


HI i have a table with 4 columns in back end like sales id, sales revenue, order id and order amt...

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

Post New Answer

More Business Objects Interview Questions

How to create Generic TIME CLASS, which includes Objects Year,Month and Qtr?

1 Answers   TCS,

can you use inputbox in BOXI. e.g. checkbox,textbox etc.

1 Answers   ACN, Patni,

i am getting multiple values from prompt like (Value1;Value2;Value3;Value4). how can i place space between values like (Value1; Value2; Value3; Value4)

0 Answers  

can anybody tell me about complicated object you have created

0 Answers  

What is the prm file ? can anybody explain me ?

2 Answers  




What is the pragma?

2 Answers  

10.why we are going to data warehouse?

4 Answers   Satyam, TCS,

What is aggregate table and aggregate fact table ... Any examples of both?

0 Answers  

What are the difference between merge,auto merge and extended merge ?

1 Answers   Cap Gemini,

What is the equivalent oracle operators for following BO Operators where we use in prompt: a. Different from pattern b.Match pattern c. Both and d.Except

2 Answers   Nucleus Software,

hi,in crystal report xI after select stantderd report Data window appear when ever i click Repository folder it ask me system/user name and p/w and when ever i put my info it says:Tranport falier :comunication error,can any body tell me what to do i already reinstall this s/w 3 times(every thing is working with same user name and p/w like xcelsois,webi,deski,desinger,cmc u name it..thanks

0 Answers  

how to overcome overflow of data in a report

6 Answers  

For more Business Objects Interview Questions Click Here
Categories