Enable/disable INSERT_MEMBER

[albert_prats]

Hi experts,

Hi have an issue with epm 10.1 INSERT_MEMBER function. I have an inpute shcedule where users must to insert members in column axis. Is possible to disable this option for row axis? And is possible to disable this function for a report?

In oldest versions of BPC, EVDRE in the EXPAND RANGE has an option "INSERT" and you can control this function with this functionality.

It exists on 10.1 version?

Thanks,

Albert

[Former Member]

Its 10.1 Standard BPC Correct?

[albert_prats]

Yes, it is.

[former_member186338]

There is no function in VBA like insertmembers

You have:

AddMemberToColumnAxis(sheet As Worksheet, reportId As String, memberName As String, dynamicRelation As Long)

AddMemberToRowAxis(sheet As Worksheet, reportId As String, memberName As String, dynamicRelation As Long)

But not sure that you will get exactly what you want

[albert_prats]

No, I try to do the functionality with your previous answer.

Thank you very much!

[former_member186338]

With VBA you can add members to axis, but you will have to refresh report to see the new members.

Another VBA solution - to activate member recognition temporary:

Dim blnMemRec As Boolean
blnMemRec = epm.GetSheetOption(ActiveWorkbook.ActiveSheet, 2) 'save Member Recognition state
epm.SetSheetOption ActiveWorkbook.ActiveSheet, 2, True ' activate
ThisWorkbook.Worksheets("Sheet1").Range("A14").Value = 104 'add member to axis
epm.SetSheetOption ActiveWorkbook.ActiveSheet, 2, blnMemRec ' reset member recognition to saved state