Skip to Content

EPM Add-in. How to add members in RowAxisMembers by API

Hi, experts.

There is array with members, which are need to add into row axis (two dimensions in axis).

I was tried add members in VBA cycle by FPMXLClient.EPMAddInAutomation and AddMemberToRowAxis, but if count of members is big (near 1000) the VBA-procedure is not responding.

Is anybody knows another way to create custom row axis or launch guided member recognition by API?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    May 24, 2017 at 02:51 PM

    In general you want to have report with many-to-many relationship between dimension1 and dimension2!

    Please read my blog how to achieve it without VBA:

    https://blogs.sap.com/2017/03/04/report-or-input-form-with-many-to-many-relationship-between-2-dimensions/

    Add comment
    10|10000 characters needed characters exceeded

    • "I'm not sure that this fully solves my problem" - why not?

      In the matrix you can establish all possible relations!

      If you already have property filled you can use script to fill the matrix automatically!

  • May 23, 2017 at 07:22 PM

    Try to enable member recognition by:

    SetSheetOption(ThisWorkbook.Worksheets("Sheet1"),2,True)

    Then fill the cells in a loop.

    Disable member recognition:

    SetSheetOption(ThisWorkbook.Worksheets("Sheet1"),2,False)

    P.S. Strange requirement to add 1000 members in VBA...

    Can you explain the logic you want to achieve?

    Add comment
    10|10000 characters needed characters exceeded