What is the most complex report you have developed. Explain and how did you overcome???

Please give some examples

Answers were Sorted based on User's Feedback



What is the most complex report you have developed. Explain and how did you overcome??? Please gi..

Answer / babisri

There was a report for me in which I had to show 10 measures in a pie chart.

Solution- I have created a structure in Bex Query and by using the structure I made a new variable in BO which are the 10 sum of 10 measure and used the variable in report to show the 10 measure in pie chart.

Is This Answer Correct ?    0 Yes 0 No

What is the most complex report you have developed. Explain and how did you overcome??? Please gi..

Answer / vikram kumar

In my last project for my client, there were few reports which were highly complex since i have used almost all the components of the WEBI in that.
Starting from the FILTERS, i have applied them at the report level to hide some of the data and along with that i have also used Prompt for the end users.
Moving further i have used variables which were hard coded in the report and created few more variables in the report with the help of WEBI formulas. further i have to add Ranking of the objects and then also created sub reports. In the sub reports i have converted the data to graphical form to represent the data. In the charts i have applied filters and linked the sub reports with the master reports with help of hyper link.
i had also written few free hand SQL in the report. Other then this i had set hierarchies and did some complex calculations. I have applied breaks in few reports and in some i have applied sections. I have used sections much with the charts.
It was a Payroll and HR domain project.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Business Objects Interview Questions

how to improve the performance of the report

3 Answers  


i am using Business Objects 6.1(a) facing a problem. ie when we save report in xls format then in xls sheet pictures are inserted into rep file are not come. Is it a bug. Give me answer as soon as possible. Thanks in Advance

3 Answers   TCS,


Regarding Hyperlinking in Business Objects. We have a few reports in QA environment where a number of hyperlinks are employed using OpenDoc function.In some of the reports,hyperlink is used to move to another tab within the same report.The formula used include "DocID" and ReportName="tab name".This works fine but now,for the PROD move,this will not work as the Doc Ids are subject to change. Is there a way to overcome this?Without DocID,how will move to a particular tab? Thanks in advance

1 Answers  


How can we improve performance?

2 Answers  


What is broad cast agent?

5 Answers  


Hi I am starter in BOXIR2.CAn anyone plz tell me the user identification details to be entered at the time of login to designer/deski

1 Answers  


Can we use unconnected lookup as dynamic lookup?

1 Answers   TCL,


Can we have multiple domains?

3 Answers  


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,


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  


can anybody tell me about issues faced while creating reports

3 Answers   Accenture,


I have 2 structures in universe,but i can't link the structures b'cos no related columns,so what i have 2 do to link dat and if don't link them can i get data of 2 structures in the report that i run?

3 Answers   Wipro,


Categories