What is the most complex report you have developed. Explain and how did you overcome???
Please give some examples
- 2 Answers
- 4619 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
i want my connection to be dynamic. How can I make it. I mean the username and password should be dynamic. How?
What is the difference between business requirement document and use case document.
I have 2 doubts regarding the "Input Control" functionality in BI4: 1) Can the Input Controls in BI4 be manipulated? I mean, can we change the IC display as BOLD or change the values from Italics to regular? Or change the colors? 2) How to get hierarchy type control in IC? Let's say my first IC is for Country and second is for State. If I select a particulat country from Ist IC,second one should show me states belonging to selected country. Is that possible? Thanks in advance!!!
How much data hold in one universe 336 can any one explain about core dimension, balanced dimension, and dirty dimension?
how many reports have u created ? explain a few.
Explain about a tricky situation for which you found a very simple solution?
How would you format some text using css to be verdana and bold?
What sort of existing documents should business analysts refer to when starting on a new project?
What is aggregate table and aggregate fact table ... Any examples of both?
what is document design in boxi,have u participate in that
explain in detail about type 3?
Explain what is aggregate table and aggregate fact table ... Any examples of both?
Explain about a time when you discovered a more efficient way to do a work task?
What are the data types present in bo? What happens if we implement view in the designer and report?
