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

[albert_prats]

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

[Former Member]

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

[former_member186338]

Yes, correct! By the way filter with impossible condition will work even without protection!

[Former Member]

Yes..It will work...But does it give any warnings when Click on "Select members". For me its not progressing ahead just nothing happens on clicking!

[former_member186338]

Yes!

Like this:

[former_member186338]

Sorry, possible:

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

[former_member186338]

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 🙂

[former_member186338]

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