Skip to Content
avatar image
Former Member

Workstatus not working on inverse Formula in Analysis of Office

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)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Apr 05 at 02:46 PM

    Hello,

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

    Best Regards,

    Leila Lappin

    Add comment
    10|10000 characters needed characters exceeded

  • Apr 05 at 05:19 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • 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