Input Form: Local Members values inside BADI

[Former Member]

Hi Everyone,

Having Employee & Wage Type as my Row & Column respectively.

For an employee, Basic Wage amount will be entered, whereas Housing will be calculated based on Basic Amount (Basic + 10% of Basic).

I've used Local Members for calculating the Housing. Now I want to update the same in my Cube. Basic alone got updated... Any posiblity of sending the Housing value via BADI or Script ???

Any clues???

KR

Gokul.N

[former_member186338 · Accepted solution]

Hi Gokul,

Simple script in the DEFAULT.LGF will do the job:

*WHEN ACCOUNT

*IS BASIC

  *REC(EXPRESSION = %VALUE%*1.1, ACCOUNT="HOUSING")

*ENDWHEN

B.R. Vadim

[Former Member · Accepted solution]

Hi Vadim,

Thanks for you immediate response.

Actually I want to do some other operations based on a entered value.

Below is my Scenario

----------------------------

Basic will be my Actual where it should not be editable  and "%"wil be entered commonly (which is my Merit Increase).

Based on the %, Basic Salary has to be updated and Updated in the Cube for each employee.

I have created a Local Member: BASIC SALARY Merit Increase (Different Account) and applied the formula through Local Member (This is done mainly for the display).

KR

Gokul.N

[Former Member · Accepted solution]

Resolved by cearting Dummy Local Member having EPM Save Forumla

Thanks

Gokul.N

[former_member186338 · Accepted solution]

If users enter % of increase then it's not bad to create a real base member for the increase%. Then the code will be:

*WHEN ACCOUNT

*IS INCREASEPERCENT

  *REC(EXPRESSION = %VALUE%*[ACCOUNT].[BASICSALARY], ACCOUNT="HOUSING")

*ENDWHEN

B.R. Vadim

[former_member186338 · Accepted solution]

P.S. In our system we constantly use this approach. We even create custom Write Back BADI to restrict direct input from input schedule or journal for the members like HOUSING, allowing changes only using DM packages or default.lgf

Vadim