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 do impact analysis for a change in Database field size which is assigned to a Dimension object and used in 10 universes
What Is The Difference Between Oltp And Olap?
explain in detail about type 3?
Regarding Hyperlinking in Business Objects. We have a few reports in QA environment where a number of hyperlinks are employed using OpenDoc function.In some of the reports,hyperlink is used to move to another tab within the same report.The formula used include "DocID" and ReportName="tab name".This works fine but now,for the PROD move,this will not work as the Doc Ids are subject to change. Is there a way to overcome this?Without DocID,how will move to a particular tab? Thanks in advance
Explain what is the difference between slice and dice and cross tab report?
Explain is there any default username & pwd for bo designer & supervisor?
Explain in detail about type 2(scd),
what is the difference b/w the refresh and buffered data?
WHAT ARE THE META DATA TYPES?WHICH META USING IN BO'S
How much data hold in one universe 336 can any one explain about core dimension, balanced dimension, and dirty dimension?
Can we configure two instances of CMS pointing to two different CMS system databases?
When we use aggregate awareness function in designer?
is it possible to export the webi reports to crystal reports?with out using businessview?
Tell me a business scenario where I can achieve the data through MINUS only not through subquery.
Explain is there any other repository domains rather than universe, security, document?