What is the most complex report you have developed. Explain and how did you overcome???
Please give some examples
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 |
How many tables can an universe contain is their any limit to insert tables in the universe?
Explain as a ba (business analyst) approaching a new piece of work, who would you interview and what questions would you ask?
When upgrading from 3.1 to 4.0. Which services need to run ONLY? Do ALL services need to be running?
Hi, How to navigate one report to another report in webi? Thanks in Advance
if there are 2 hierarchies 1 is a-b-c and another one is a- c which hierarchy b.o takes while we use drill mode
BO Security (creating the restriction sets in Universe and applying on selected groups or users) or Database security (Creating the tables in database insrting the user details in that tables and giving conditions in self restricting joins in Universe )Which Security will improve the performance of the reports and for best practices ? I am thinking BO Security will give the better performance, could you please share your thoughts on this please... Thanks...
WHAT IS THE DIFFERENCE BETWEEN OLAP AND DATAWAREHOUSE? WHAT IS MICROCUBE EXACTLY?
What are the general problems that are faced while importing the .biar files and what is the solution to overcome it in business objects?
how do u implement dense rank in bo reports?
8. How much supervision have you typically received in your previous job?
suppose case1:a person buy a car case2: rent a car which is context & which is alias? why?
I have set of reports in BO4.0 and need to use "Hyperlink" functionality. I had to use native hyperlink functionality provided in BO4.0 but looks like it's available only in Rich Client.Currently,we have only Infoview B04.0 Launch Pad.Is OpenDoc the only hyperlink option on BO4.0 Launch Pad? Thank you.