Skip to Content
Aug 28, 2019 at 10:33 AM

Multiple Hierarchies in a Member Formula Refreshed Through ABAP


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).


  METHOD read_td_axis_query.
      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
             i_passby_security = abap_true
             it_axis           = it_axis
             it_slicer         = it_slicer
             et_data           = ct_data ).


Variables at RunTime:

The Exception:

Many thanks,



it-axis.png (36.0 kB)
it-slicer.png (97.8 kB)
it-axis1.png (71.8 kB)
it-axis2.png (90.8 kB)
it-axis3.png (68.7 kB)
caught-error.png (480.1 kB)