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
- 4561 Views
- NTT Data, I also Faced
- E-Mail Answers
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 |
My data source is Excel sheet. How to write the SQL Statement for Excel file in data provider? Is is possible?
4.what is repository? types
how can we join two classes with full outer join.in join dialog box only one outer join check box is checked another on e gone .for this any property is there in universe designer?
How to sort the dynamic objects alphabetically on the Universe based on and SQL Server
How to Analyise 'Join' problem and which method is the best to resolve that ?
Which versions are used in the bo dashboard work?
Can any one say me how i can integrate 3 or more analytics like radio bottons,line chart,pie chart while designing a dash board in xcelsius and i am also facing problem to show one after another values in the same chat at a time..... Please help me out for this....
difference between web intelligence,crystal reports and desktop intelligents
Is it possible to create a user defined Calendar in BOXIR2? If yes, then how? Ex:- I want to create a Calendar where the year starts with the month of Feb-1. Each month is of 28 days. 1st Month as 1-feb to 28-feb. 2nd Month as 29 Feb - 21 Mar. Please help me out to get the answer....
how do we apply sql query on selected variables?
How to do impact analysis for a change in Database field size which is assigned to a Dimension object and used in 10 universes
GENARALLY HOW MANY UNIVERSES ARE CREATE FOR EACH PROJECTS?
Teradata 
