Multiple Hierarchies in a Member Formula Refreshed Through ABAP

[Former Member]

Hi SAP Gurus,

I have written an ABAP routine that reads member formulas in BPC 10.1 on HANA - but it does not work when I try to read an Account from Parenth3. I would like to know if there are any reasons why my member formula reading hierarchy three is not working. I have added detail below.

The Member Formulas:

• I have 6 Member Formulas that perform reconciliation checks using IIF statements (e.g. If Account X = Account Y then output a 1, otherwise output a 0).
• All of the member formulas work perfectly when refreshed in Excel.
• 5 of the 6 Member Formulas work perfectly when I refresh them through ABAP.
• The member formula that does not work when refreshed through ABAP contains a reference to a different hierarchy (e.g. [ACCOUNT].[PARENTH1].[X] = [ACCOUNT].[PARENTH3].[Y].
• Even when I change the member formula to be reading a single account from Parenth3 - it does not work in ABAP (it still works in EPM).
• The Member Formulas are stored in Parenth1 (I have put them in Parenth3 too and it still does not work).

The ABAP:

  METHOD read_td_axis_query.
    DATA:
      lr_query    TYPE REF TO cl_ujo_query_base,
      lr_data     TYPE REF TO data,

*----------------------------------------------------------------------------------------

*** Create Query Object
    CREATE OBJECT lr_query EXPORTING i_appset_id = i_appset_id i_appl_id = i_appl_id.

*** Execute Formulas
    lr_query->if_ujo_query~run_axis_query_symm(
           EXPORTING
             i_passby_security = abap_true
             it_axis           = it_axis
             it_slicer         = it_slicer
           IMPORTING
             et_data           = ct_data ).

  ENDMETHOD.

Variables at RunTime:

The Exception:

Many thanks,

Matt

[former_member186338]

Full screenshots of member formulas setup!

Test report screenshot

"The Member Formulas are stored in Parenth1" - what do you mean????

[Former Member]

vadim.kalinin - Might you be able to assist? 🙂