Difference Between BW Technical and Functional

In general Functional means, derive the funtional specification from the business requirement document. This job normally is done either by the business analyst or system analyst who has a very good knowledge of the business. In some large organizations there will be a business analyst as well as system analyst.

In any business requirement or need for new reports or queries originates with the business user. This requirement will be recorded after discussion by the business analyst. A system analyst analyses these requirements and generates functional specification document. In the case of BW it could be also called logical design in DATA MODELING.

After review this logical desing will be translated to physical design . This process defines all the required dimensions, key figures, master data, etc.

Once this process is approved and signed off by the requester(users), then conversion of this into practically usable tasks using the SAP BW software. This is called Technical. The whole process of creating an InfoProvider, InfoObjects, InforSources, Source system, etc falls under the Technical domain.

What is the role of consultant has to play if the title is BW administrator? What is his day to day activity and which will be the main focus area for him in which he should be proficient?

BW Administartor - is the person who provides Authorization access to different Roles, Profiles depending upon the requirement.

For eg. There are two groups of people : Group A and Group B.

Group A - Manager

Group B - Developer

Now the Authorization or Access Rights for both the Groups are different.

So for doing this sort of activity.........we required Administrator.

Which one is more in demand in SAP Job, ABAP/4 or BW?

In terms of opportunities a career in SAP BW is sounds better.

ABAP knowledge will help you excel as a BW consultant, so taking the training in ABAP will be worth it.

You can shift to BW coming from either an ABAP or functional consultant background. The advantages of the ABAP background is you will find it easier to understand the technical aspects of BW, such as when you need to create additional transfer structures or if you need to program any conversion routines for the data being uploaded, as well as being familiar with the source tables from SAP R/3.

The advantage of coming from a functional consultant background is the knowledge of the business process. This is important when you're modeling new infocubes. You should be familiar with what kind of data/information your user needs and how they want to view/group the data together.