Skip to Content
avatar image
Former Member

Enable/disable INSERT_MEMBER

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

5 Answers

  • Dec 19, 2016 at 11:46 AM

    I don't think it's possible...

    Add comment
    10|10000 characters needed characters exceeded

  • Dec 19, 2016 at 11:54 AM

    Sorry, possible:

    In the report options in Inserted member filtering add member based on impossible filter :)

    Add comment
    10|10000 characters needed characters exceeded

    • For example - you have DIM1 as dimension in rows. To prevent insert member:

      Edit Report -> Member Insertion Filtering:

      Filter members:

      ID=some base member ID

      CALC=Y

      Impossible condition! Save it and try ta add member for this dimension :)

  • avatar image
    Former Member
    Dec 19, 2016 at 11:56 AM

    Hi Albert,

    We cannot disable the Insert Functionality but can restrict the users from inserting the members in Row. You have to first Add Members only to the dimension used in the column from "Edit Report" " Member Insertion Filtering". and Protect the Sheet with password. Then if the user tries to insert a member in the row then he will get a warning.....

    Hope this helps...

    JP

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Dec 19, 2016 at 12:15 PM

    Thanks Vadim and JP. It's very interesting both answers! Vadim, your answer is best for me, because I don't have the members in columns with member only selection. For this, with your methd I can "disable" this function for an axis. Great!

    A last question about this: I know there is a vba function that can make this fuction (insertmembers), but with this code, you can't control what axis are you inserting the members. Exists some vba function that allows me to select what axis and for what report I'll insert the member?

    Thank you very much! I think that your answers can help more people!

    Albert

    Add comment
    10|10000 characters needed characters exceeded

  • Dec 19, 2016 at 12:21 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • 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