What is the most complex report you have developed. Explain and how did you overcome???
Please give some examples
Answer Posted / 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 View All Answers
How to generate the report from excel sheet?
Explain about a tricky situation for which you found a very simple solution?
Give some information on report bursting?
What is the difference in creating filters in designer and business objects?
What are the general problems that are faced while importing the .biar files and what is the solution to overcome it in business objects?
What is a bo repository?
Explain what if a cartesian product pop up block appears when running a report. Does it give wrong values? How to solve this issue?
What sort of existing documents should business analysts refer to when starting on a new project?
Explain what is the difference between business requirement document and use case document.
What is the difference between the public object&schema object?
What is difference between webi and infoview?
Difference between zabo and webi?
In banking domain how many Fact tables,Dimension table are present?
Explain the difference between union and group?
Which command using Query Analyzer will give you the version of SQL server and operating system ?