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 universe null

1997


Can we create universe with no cache??

1966


What is a bo repository?

600


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

1621


Explain what task is 98% of the required work of a business analyst?

612






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?

561


any difficulitis have you phase while creating bo reports and how did u solve it

3006


Tell me a business scenario where I can achieve the data through MINUS only not through subquery.

2622


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

643


please explain me with the real time tables on how aggregate tables are created and how aggregate awareness is addressed to it.

1545


How much data hold in one universe 336 can any one explain about core dimension, balanced dimension, and dirty dimension?

704


What are the steps to be taken to schedule the report?

563


Explain the difference between detect alias and detect context?

637


Is there any other repository domains rather than universe, security, document?

611


Explain how to schedule the report in b.o?

571