Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Use Multiple Dim property value in script logic

Dear All,

I have one requirement, there is two input schedule both input schedule are almost same. Where input schedule 1 is user input and input schedule 2 has a one special features user want A deletion column is available in the input form2 to enable planner to remove records in the system.  If deletion value of the record is marked with ‘Y’, the record will be removed from the system and no costs will be calculated for the record when form is saved.For that i use if condition in column H,but the logic will overtire the total value not in any particular cell.I want the script will execute for specific cell not whole report.


Is there any way to achieved this.   

Regards

Mayur

IFcondition.PNG (19593 B)
Delete.PNG (12096 B)
Former Member
replied

Property value is a part of master data and you can't change it using input form to enter transactional data (I will not discuss here Master Data on the Fly).

You can use some extra account and for example store value 1 to this account to clear other accounts.

Example: New account - testacc

*XDIM_MEMBERSET ACCOUNT=testacc

*WHEN ACCOUNT

*IS *

*REC(EXPRESSION=(testacc==1) ? 0 : [ACCOUNT].[bankkpi2], ACCOUNT=bankkpi2)

*REC(EXPRESSION=(testacc==1) ? 0 : [ACCOUNT].[bankkpi3], ACCOUNT=bankkpi3)

*REC(EXPRESSION=(testacc==1) ? 0 : [ACCOUNT].[bankkpi4], ACCOUNT=bankkpi4)

*ENDWHEN

Vadim

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question