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 |
WHAT DOES SQL TAB CONTAIN?
I HAVE MONTHS AS DEC,JEN,MAY,APRIL... WHICH PROMPT IS USED TO GET REPORT IN SEQUENCE?
Explain are data mart and dwh normalized or denormalized? Do both of them exist in the same tier?
How to get top 5 rows of a selected column?
what are cascading prompts explain with steps
i am getting multiple values from prompt like (Value1;Value2;Value3;Value4). how can i place space between values like (Value1; Value2; Value3; Value4)
what is casual dimension?
hi,in crystal report xI after select stantderd report Data window appear when ever i click Repository folder it ask me system/user name and p/w and when ever i put my info it says:Tranport falier :comunication error,can any body tell me what to do i already reinstall this s/w 3 times(every thing is working with same user name and p/w like xcelsois,webi,deski,desinger,cmc u name it..thanks
What problems you have faced while creating an universe? tell me an incident and how you went about solving it?
6.what is conformed dimension? R u used?
what is local filter
Can Bo generates the Report from the cubical data Explain?