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
what are the tables used in health care domain project and columns used in report?
Explain what is aggregate table and aggregate fact table ... Any examples of both?
Explain are data mart and dwh normalized or denormalized? Do both of them exist in the same tier?
what is universe null
What is a fantrap in business objects?
How to create Index to the table in the universe designer and how it improves the Query performence
What is the profile and package?
Hi friends,
I am trying to create OLAP connection in IDT. I am getting
error "error code:405 METHOD NOT ALLOWED"
I am using "http:
what is the difference b/w the refresh and buffered data?
Hi I'm using data federator.I would like to know if it allows select statment in where clause.For example: SELECT Employee, company, orgunit FROM TAB_BIG WHERE employee IN (Select TAB_SMALL.employee FROM TAB_SMALL WHERE flag = X ) bye
Explain how to schedule the report in b.o?
Can we Save (save as) WEBI Doc as DESKI?
Differences between business objects and web intelligence reports?
How to sort the dynamic objects alphabetically on the Universe based on and SQL Server
Explain are data mart and data warehouse normalized or denormalized? Do both of them exist in?