HCM Planning in BPC

[inna_maltz2]

A few years ago we rolled out a very basic solution to allow our Finance folks to plan for headcount. They created their own templates and worked with business owners for HCM planning which includes salary, taxes, medical, etc to comprise a fully burdened expense for each employee. It works great except that the input templates and reports are full of very complex Excel formulas which determine the tax amounts based on rates and currency. This slows down the template considerably and periodically crashes the file. We have only a few hundred employees so the file isn't huge. Can anyone give me some suggestions on the best approach to calculating the fully burdened HCM cost for each employee without heavy use of Excel?

[Former Member]

Hi Maltz,

You don't need to manipulate salary calculation through excel formulas.I was worked in Head count  planning where we was use all calculation through BADI.You should create salary calculation either through logic script or Badi logic then run the logic through default logic script.Every time user input the data logic automatically executed and you can see the changes in Head Count Planning Salary report. If salary your calculation are very complex then you can try Badi logic otherwise logic script is best solution.

Thanks

Khokan

[former_member186498]

Hi Khokan,

this is MS version of bpc and Badi function don't exists here, only in NW version.

Redards

     Roberto

[Former Member]

Hi Roberto,

Sorry for mistake.

Regards

Khokan

[former_member186498]

Hi Inna,
if you have a lot of excel formula in bpc input schedules and reports this is a sign the architecture of the appset was not well made.

Excel calculations can be avoided through a good design of the envolved dimensions, especially the dimension's hierarchies , script logics, dimension formulas and properties, eventually with help of stored procedures and business rules (don't search for BADI because in MS version BADI functions don't exist).

There is also aa best practice for NW version but with due care also apply to the MS version, see please http://help.sap.com/saap/sap_bp/BPC_NetWeaver/BBLibrary/html/B62_BPC075_EN_DE.htm

Regards

     Roberto

[Astha_M]

Hi Inna,

HCM Planning can be done in BPC. The calculations will be done through Script Logic / BAdI so the users will input required data based on which calculations can be performed using the logics specified.

The Logics will be executed through the BPC data manager package. Also, data can be converted into multiple currencies based on the currency conversion rules.

Hope it helps.

Thanks

Astha