Interested to Buy Any Domain ? << Click Here >> for more details...
what are the complex reports you have created. Tell me with
example?
- 7 Answers
- 33166 Views
- Insurance, TCS, I also Faced
- E-Mail Answers
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
Explain what task is 98% of the required work of a business analyst?
Can I create a master report in webi having 15 dimensions and 150 kpi's with 100GB of data and store it in cache ,So that I can use Cache for building new reports with less dimensions and Kpi's without hitting database againg just using cache??Please suggest...
Difference between zabo and webi?
What is the difference between the public object&schema object?
What is Indexing? how did u implement indexing?
Are data mart and dwh normalized or denormalized? Do both of them exist in the same tier?
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...
What is aggregate table and aggregate fact table ... Any examples of both?
If 2 tables are joined by Shortcut join, if query is generated based these join, what will be the join type and what will be the generated query? Thanks in advance?
When we use aggregate awareness function in designer?
i want my connection to be dynamic. How can I make it. I mean the username and password should be dynamic. How?
What are the steps to be taken to schedule the report?
how to prepare the documentation in business objects and where to get the requirement?
Explain how can we do load testing for webi reports? (Example if I have have to test one webi report for concurrent users refreshing report at one time)?
What Is The Difference Between Oltp And Olap?
