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


Please Help Members By Posting Answers For Below Questions

What is the dense rank?

679


Give some information on report bursting and how to do it in bca as I have to split the report and send diff reports to diff people?

549


What is the difference between condition & filter?

609


What is the difference in creating filters in designer and business objects?

591


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...

1725






How to do impact analysis for a change in Database field size which is assigned to a Dimension object and used in 10 universes

1973


How to Explain about BO projects in interviews?(in Banking,insurance,Manufacturing domains)

4324


is it possible to export the webi reports to crystal reports?with out using businessview?

1822


i want my connection to be dynamic. How can I make it. I mean the username and password should be dynamic. How?

1614


webI report not showing Barcode in PDF format, i have used BC39 font,but barcode is shown in HTML but not in PDF, please any solutions??

3926


How to restrict password to a user while sending a document in .pdf format

1865


1. 101 vinay hyderabad 123 naresh usa 152 singh delhi 101 vinay usa 123 naresh mumbai 156 raju chennai From the above data we need to retrive current data in a report ? how and explain in detail ?

5975


Explain in detail about type 1?

659


Explain which versions are used in the bo dashboard work?

635


What is the difference between slice and dice and cross tab report?

607