What is the most complex report you have developed. Explain and how did you overcome???
Please give some examples
- 2 Answers
- 3514 Views
- NTT Data, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
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 |
Explain difference between zabo and webi?
What is the difference in creating filters in designer and business objects?
Give some information on report bursting and how to do it in bca as I have to split the report and send diff reports to diff people?
. In production reports, some dimensions are missing. how do you load these dimensions in production
CAN A REPOSITORY CONTAINS REPORTS?
how do you give security to universe ?
2 Answers InfoStep, Tech Mahindra,
I am working on Business Objects-reporting side. Database is Teradata. I have two questions here: 1. We will be working only on Infoview on QA environment. Do I need to add ODBC entries for the QA database server on my machine to be able to create/refresh Infoview reports? I will not be using Desk_I or Web_I rich client. 2. Once reports are developed,Admin team would migrate the reports to Production and make these available to business users. The reports are Refresh on Open. Would the business users need to have the ODBC entries of Production database server in their machines to be able to refresh these reports?
9.what are the multidimensional analyses
How we will see which trap(Chasm trap or Fantrap) was used in the Universe ?
when I am trying to schedule the report its running faster then I tried to run it manually?? why is it so that there is difference of time between scheduling and manual run for report
WHAT IS THE PURPOSE OF TESTING INTEGRITY OF THE UNIVERSE?
How to fix the order of Prompts? How to assign the default value in prompt?
Teradata 
