BW ESTIMATION MODEL- Effort Estimate

[Former Member]

Hi Gurus,

As i am creating a BW estimation model I have put the following effort for complexities for differnt tasks. Please suggest if you think the estimation should be differnt to what I have estimated as I am a rookie in these area.

Complexity(in Man Hrs)

Type High Medium Low

Set up Technical Enviroment 16 12 8

Define Source System 24 18 11

Define Extract Structure 24 18 8

Define Info Object 5 2 1

Data Staging 16 12 8

Transformation and Mapping 24 16 8

Build/Activate Data Targets 16 12 8

Define/Update Update Rules 24 16 8

Reports 24 16 8

Process Chains 24 16 8

Thank you so much for your help in advance.

Regards,

Sanjeev

[Former Member · Accepted solution]

Hi Sanjeev,

In my opinion

Define Extract Structure 24 18 8

(refine it whether you are creating a generic extractor or just activating business content datasource, if generic extractor then the complexity could be based on the number of tables, fields)

Build/Activate Data Targets 16 12 8

(segregate based on ODS, Infocube, Multicube)

Process Chains 24 16 8

(may need more time)

For all the above acitivities, are you including the time for design, development, testing, transportation (not as simple as R/3), documentation.

If you have included the time for all the above, I think the time is convservative and based on the activities you should relook at the same by a factor of 1.5 to 2 depending on the object type.

Hope it helps.

Cheers

Anurag

[Former Member]

Hi Sanjeev,

IMHO:

- Define extract structure (I assume that there is datasources building also) - in case of generic DSs 24 hrs is definitely to little. May take several weeks.

- Define info objects - depends on the IOs number - if they are several hundreds then it will take mucn more than 5 hrs.

- Setup tech environment (BW installation?)- takes up to a week.

- Reports - completely depends on the complexity of reports, their number and their formatting - in case of 100+ complex reports in Excel with formatting in VBA - may take several months!

Best regards,

Eugene