Skip to Content
avatar image
Former Member

BPC reverse sign in database and BADI for LEQ accounts

Hello everyone,

we have a problem with sign for LEQ accounts: in database we have, for example, 321456 but when calling the BADI (in ct_data table), -321456

To solve this issue, we create custom measure (copy of PERIODIC through UJA_MAINTAIN_MEASURE_FORMULA program) and remove negative signs for LEQ and INC accounts. However, when calling BADI through UJKT and setting ZPERIODIC as value of MEASURES parameter, we receive this error:

UJO_READ: MDX declaration error: Cannot use more than one hierarchy per dimension

Someone knows why this occur?

Do we need to configure other settings to solve the reverse signs problem?

Is the only solution multiplying LEQ accounts amount by -1 in BADI?

The EPM version is 10.0 SP 26

Thanks.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Feb 15, 2017 at 11:26 AM

    OK, I will explain with a sample:

    The model is PERIODIC

    ACCOUNT A1 - ACCTYPE LEQ

    In RSA1 you have: 321456

    In EPM report: -321456

    In script logic BADI call:

    If you scope:

    *XDIM_MEMBERSET MEASURES = PERIODIC

    in ct_data: -321456

    If:

    *XDIM_MEMBERSET MEASURES = SIGNEDDATA

    in ct_data: 321456

    If no scope for MEASURES - equivalent to SIGNEDDATA

    in ct_data: 321456

    You don't need any custom measures!

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Vadim Kalinin

      Wow, it works!

      The script code that we were using:

      *XDIM_MEMBERSET MEASURES = PERIODIC
      
      *START_BADI ALLOCATION_FUNDING
      TIME = 2016.04
      *END_BADI
      

      I debug both, with SIGNEDDATA value and without MEASURES parameter and the amount it's what we need!

      Большое спасибо Вадим! (So much thank's Vadim!)

  • Feb 15, 2017 at 09:10 AM

    Ups, strange...

    "in database we have, for example, 321456" - may be not in database but in report?

    INC and LEQ accounts are shown in the report with reverted sign (look on the standard measure formula).

    In database (SIGNEDDATA) you have original signs...

    What do you want to calculate in the badi?

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      With this "in database we have, for example, 321456" I mean the data available in RSA1. Here we have one sign and receive in BADI the reversed (as shown in EPM).

      We need to calculate the amount aggregation for all accounts for every TIME.

      Thanks for answering!