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?



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

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  


main purpose of aggregate awareness(not include make possible of use of aggregate tables)

2 Answers   Accenture,


1) How can you use slowly changing dimension type 2 in Universe, Reporting and what would be the build process. 2) How can you identify the users in webintelligence not using the reports past few months. And delete them. 3) How can you move documents from one environment to other environment

3 Answers   Hexaware,


explain about Prompt with example?

4 Answers   CSC,


Its regarding Javascript coding for customization in BI4 reports. We need to have all the options disabled in the report except the option to Export(save the report in computer in Excel/pdf formats). I am able to hide TopBar,TabBar,Left Navigation etc but I need "Export" option to be displayed to the users in Read mode. Can this selective "hiding" be achieved?

0 Answers  






What are the Users and User groups?

2 Answers   Wipro,


From Business Objects Web-I reports, we can link to other BO reports using Opendoc functinality. How do we link to reports in other reporting tool or how to give a link any website?

1 Answers  


What is the Difference b/w Server based Ranking and normal Ranking?

1 Answers  


How to get red line in the graph at some point (value)? Example : In graph at 200000 value

1 Answers   Rolta,


can some body explain how migrate the BoXI r2 to BO 3.x and crystal reports XI r1 to Crystal report 2008 ?

0 Answers  


3.what is alias?

5 Answers   Business Intelligence Analytics, TCS,


Explain is there any tool that can compare two unvs / two rpts , built using bo 5.1 / bo 6.5?

0 Answers  


Categories