Report Estimates (Efforts & time) for BO Webi Reports

building reports webintelligence
1

Hi

I have to do a Report Estimation(Efforts & time) for BO Reports. I have to create 50 BO Webi Reports in XIR2 and and some universe modifications( 6 objects addition).

I have to use hyperlinks in these reports. to open chilid reports and drill down options.

Does any one have Report estimates(Efforts & time) format for BO Report and universe modifications.

Thanks in advance

sharma

sharma03 :india: (BOB member since 2006-03-25)

2

Possibly the easiest way is to base it on your knowledge of the system.

Work out the following:

How long does it take to add an object into the universe.
Time required to test those objects
Document those changes.

How many objects are going into the report how many conditions are being added in the where clause.
Does the report need to have in report measures/dimensions/details created.
How many tables will go on the report.
How many charts will go on the report.
Does the report require a template applied.
Time required to test the report.
Document the reports.

These are some of the things that you need to consider.

You’ll need to identify all of this and possibly more and then allocate time next to each. You can’t use anybody elses time as they could be slower or faster than you.
So you’ll need to work that part out for yourself, but remember to build in tolerances.

plessiusa :netherlands: (BOB member since 2004-03-22)

3

Hi Sharma,

I agree with plessiusa in that ultimately only you know your own level of BusinessObjects skills and abilities and your systems. A lot also depends on your level of knowledge of the universe in question. If it’s one you’ve built from scratch then adding in 6 new objects will be far quicker than if it’s one you’ve inherited from another universe designer and you’ve got to familiarise yourself with the table layout etc.

Without knowing anything about your systems, I always tend to use the following guidelines when supplying estimates to my users:

  1. One new universe object - 1 hour. This is adding in, testing and documenting
  2. Multiple new universe objects - half a day+, depending on how many they need adding in.
  3. New reports - 1 day per report without seeing any report requirements whatsover. Assuming that once you’ve done one report from a system, you can use the knowledge gained to develop subsequent reports it might take you less time. But I always over-estimate and build in tolerance so that if I get stuck on something I’ve got time built in to google, post a message to the forums or whatever in order to solve the issue.

Hope this helps.

malteser (BOB member since 2006-02-21)

4

Hi Sharma,

Before estimating any report and universe you need to take down few points in mind.

  1. Just find out how many complex report and midium and simple.
    2)How may people are working for this particular work
    3)While doing so also keep in mind if there is any network problem and all.

So keeping evrything in mind you can estimate.

Regards
Bidyadhar Swain

swaib1 (BOB member since 2008-07-03)

5

Hi All,

Thanks for your suggestions. I have estimated the effort & time for each report. I have around 8 set of reports each set contains 7 reports. The reports are simple. All the reports contains Drill filters and Hyperlinks. The only complexity in the report is I have to pass hyperlinks from one report to another based on the selections on drill filter in each report…

This is the first time i am working on Hyperlinks. If i create one set of reports sucessfully, remaining 7 sets are similar to first set.

Creating Parent and six child reports will take around 1 week for me. But I am not sure about the hyperlinks.

Could any one suggest me that how many days will it take to create hyperlinks in parent report and child reports.
Note: The hyperlinks should be created based on the drill filter.

Also please provide me an Report Estimation template.

Thanks in Advance
Sharma.

sharma03 :india: (BOB member since 2006-03-25)

6

When passing information from one report to another using a drill filter, you also have to consider the fact that somebody might select ‘All values’ from the drill filter, and the drill filter itself might be a blank value. I created reports a while ago using drill filters, and most of the effort was in coding the information to be passed from one report to another, and (for us) storing the server name in the universe so it wouldn’t be hard-coded in the reports. Here’s an example of a hyperlink we created:

="<a href="+[Server]+"/businessobjects/enterprise115/Infoview/Scripts/opendocument.aspx?sPath=[BI+Reports],[BI+Dev],[Budget]&amp;sType=wid&amp;sDocName=Budget+by+District&amp;sRefresh=Y&amp;sWindow=New&amp;lsSEnter+Allocation+Year:="+FormatNumber([Year of Allocation Start Date];"####") +"&amp;lsSEnter+Allocation+Name:=" + URLEncode([Allocation Name]) + "&amp;lsSEnter+Region:="+[Region Name]+ ">" + [Allocation Name] +"</a>"

bkaporch :us: (BOB member since 2008-12-02)