what are the complex reports you have created. Tell me with
example?
Answer Posted / sourabh gosain
i have created many complex reports in Business Objects as
well as Crystal Reports. Here are few examples of them.
BO
I have made a report which give activated and deactivated
user for all application of client. for that i created sys
security Universe . Later on i created Free hand sql which
required many derived tables to achieve the functionality.
Finally after getting data on report i created another sub
reports. which were linked to main report. I did this in
webi by passing parameters to reports. That way i created
one main report which had hyperlinks for another reports.
In main report I put one graph which represented final
figures in Pie.
Crystal.
I created a complex report which gave opening and closing
balances for Business. I made formula for defining data in
custom manner. I introduced on demand sub reports for each
business units. I inserted Xcelsius flash object. That
object used feature of drill down. I made pie chart which
gave variances between opening / closing balance and
transactions. For each legal entity When user wanted to see
opening and closing , all he needed is to click the pie
section and an adjacent graph would show data for opening /
closing balance for selected legal entity.
I have many examples with me but due to constraint of
writing much in forums I am mentioning few only .
Is This Answer Correct ? | 7 Yes | 0 No |
Post New Answer View All Answers
How to create a new calendar in CMC? Can u please tell me the process to create the required calendar. Ex:- Year of that calendar to start with Jan-15 and ends with Jan -30 and the Next month to start with Feb-31 and ends with Feb-14.
Explain and tell me about a situation where your analysis of a problem was deemed to be incorrect? What would you have done differently?
Explain what are the measure objects?
Explain is there any tool that can compare two unvs / two rpts , built using bo 5.1 / bo 6.5?
What are the steps to be taken to schedule the report?
What is thumbnail?
Please send me BO certification details and question papers? this is my mail id: valsreenivas@gmail.com
Can you please send me the migration related issues .
How to execute the plsql procedure from the report by clicking with mouse?
Explain in detail about type 1?
What is the dense rank?
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?
What are the join problems comes appart from loop,chasm & fan Traps
Explain about a tricky situation for which you found a very simple solution?
Explain about an assignment you worked on in which you had to amass a huge amount of data, and then analyze it?