Skip to Content
0

Workstatus not working on inverse Formula in Analysis of Office

Apr 05 at 11:42 AM

58

avatar image

Hello,

We are on Embedded BPC version.

We have created a RKF and an inverse formula on RFK in input-enabled query.

RKF: A has many selections under it like Category, Info-provider, Audit trail etc. (Hidden and input enabled)

Inverse Formula: B = A*(-1) (Hidden)

Display formula: C = B*(-1) (Input enabled)

Category and Info-provider values are retrieved using customer exit.

The user will input on C (positive value will be written), while Doing SAVE in Analysis of Office , the data will be written back to ACDOCP as Cvalue * (-1). When we refresh or read data back from ACDOCP, C should read as ACDOCP value*(-1).

If i perform work status on C, i get below error(See attachment)

f i perform work status on A, the data gets approved/submitted accordingly.

Thanks and Regards

ws.png (159.1 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Leila Lappin
Apr 05 at 02:46 PM
0

Hello,

Please provide screen prints of your work status configuration, using BPC web client, at BPC environment and model levels.

Best Regards,

Leila Lappin

Show 1 Share
10 |10000 characters needed characters left characters exceeded

Hello,

Please find BPC configurations done.

Thanks.

bpc-config1.png (52.7 kB)
bpc-config2.png (33.9 kB)
0
Leila Lappin
Apr 05 at 05:19 PM
0

Hi,

The error message is suggesting that you do not have a value selected for category (and InfoProvider) when you attempt to set the work status. Please explain what value for category are you selecting. Are you using the same process when you use Account?

Best Regards,

Leila Lappin

Show 2 Share
10 |10000 characters needed characters left characters exceeded

Hello,

When i set workstatus on inverse formula, the category and info-provider are dynamically read using customer exit in ABAP. Even though category and info-provider have single values passed in ABAP the workstatus is unable to interpret it.

The same category and info-provider customer exit logic is applied in RKF and the workstatus works fine here.

Inverse formula is created on top of RKF for following scenario.

The user inputs amount as 100 against profit center and functional area, the moment the save button is executed the amount in ACDOCP should be updated as -100. When the user refreshes the input form against same profit center and functional area, the amount should be read as 100 from ACDOCP.

Thanks and Regards.

0

Hi,

Could you elaborate on what your ABAP code does, how it uses the values passed and what is the significance of inverse formula on how BPC work status should determine the data region to be locked?

Best Regards,

Leila Lappin

0