Interested to Buy Any Domain ? << Click Here >> for more details...
What is the most complex report you have developed. Explain and how did you overcome???
Please give some examples
- 2 Answers
- 4453 Views
- NTT Data, I also Faced
- E-Mail Answers
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
Explain is data mart?
How can we do load testing for webi reports? (Example if I have have to test one webi report for concurrent users refreshing report at one time)?
Explain and tell me about a situation where your analysis of a problem was deemed to be incorrect? What would you have done differently?
Please send me BO certification details and question papers? this is my mail id: valsreenivas@gmail.com
please explain me with the real time tables on how aggregate tables are created and how aggregate awareness is addressed to it.
IN THE REPORT I WANNA APPLY HYPERLINK FOR A CELL IN THE COLUMN/ROW HOW TO ACHIEVE THIS? EG: YEAR COLUMN : 2001,2002,2003,2004 I WANNA APPLY FOR 2001 ONLY
Tell me a business scenario where I can achieve the data through MINUS only not through subquery.
What is the difference between the public object&schema object?
How were the reports scheduled and how to resolve unexecuted documents?
Difference between b.o 5.1 and 6.1b?
What is the difference between slice and dice and cross tab report?
Explain how we drill up week to month?
How to execute the plsql procedure from the report by clicking with mouse?
What Is The Difference Between Oltp And Olap?
1)I have createcd a dashboard on Bex query. How to refresh the Dashboard without hitting the bex query? 2)What is Event based scheduling in BO? 3) How to display the BO webi report title using a function? 4) For eg in my webi report iam having a person name like Jhon Peter Adam. But i need to get only the middle name of the person like Peter. What function is used in Webi to get this?
