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

Answer / thogari

thanks Sourabh Gosain thats helpful. could u please give an example how to explain for complex report on a retail project.
Thanks in advance.

Answer / maryam

Hi Bouser,

I need some examples of reports in SSRS for insurance company. May I have some of your reports?

Thanks

Answer / fayaz

Thanks sourabh, I need some examples of complex reports which you have created...can you please share it to me.

Answer / priti

Hi same question has been asked by me:
I have given ans: I have developed report which gives me all the employee data in the organisation. If I have given employee name it will show me all the data of employee including there in and out time ans average time they spend in the office for a month.
Pls rate my answer.

Answer / bouser

In my senario i have create a complex report for
insurances is in my product create a report for client
details basically one persons having n number of policyies
i will find out the persons partiular report

Answer / sreenivas27

Hi,

complex reports:

I have created many reports using VB macro like

I had created one control report which is defined many Sales
ares, Plants, Sales repcode..... like i have created control
reports and based these refer to created another report
which is refer to control report and run the each area or ,
sales repcode.... like that i have created and these reports
will be published individually on webi.

I thought that these type of reports are called Complex reports

difference between web intelligence,crystal reports and desktop intelligents

4 Answers  

Can anybody pls provide me Business Objects Certification (SABE201) Study material and dump. Pls. My email id is reshma.toppo@gmail.com......Thanx

4 Answers  

generally how do we get information for creating universes and reports

1 Answers   Satyam,

What is the difference b/w the simple Universe and Complex Universe?

2 Answers  

wat is the difference between full clinet report and thin client report?wat is the difference between desktop intelligence and web intelligence?

3 Answers   Target,

What is metrics?

2 Answers  

every alternative row should be hilighted ? how u can ?

1 Answers  

Can anybody tell me about issues faced while creating universe. thanks in advance

1 Answers   Accenture,

I have 2 doubts regarding the "Input Control" functionality in BI4: 1) Can the Input Controls in BI4 be manipulated? I mean, can we change the IC display as BOLD or change the values from Italics to regular? Or change the colors? 2) How to get hierarchy type control in IC? Let's say my first IC is for Country and second is for State. If I select a particulat country from Ist IC,second one should show me states belonging to selected country. Is that possible? Thanks in advance!!!

0 Answers  

What are the security level used in BO?

6 Answers   Oracle,

explain merge dimensions with real time in DWH?

1 Answers   IBM,

What if a cartesian product pop up block appears when running a report. Does it give wrong values? How to solve this issue?

0 Answers