Skip to Content
0

Enable/disable INSERT_MEMBER

Dec 19, 2016 at 11:35 AM

67

avatar image
Former 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

10 |10000 characters needed characters left characters exceeded
Former Member

Its 10.1 Standard BPC Correct?

0
Former Member
Former Member

Yes, it is.

0
* Please Login or Register to Answer, Follow or Comment.

5 Answers

Vadim Kalinin Dec 19, 2016 at 11:46 AM
0

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

Share
10 |10000 characters needed characters left characters exceeded
Vadim Kalinin Dec 19, 2016 at 11:54 AM
0

Sorry, possible:

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

Show 1 Share
10 |10000 characters needed characters left 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 :)

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

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


insert-member.png (51.4 kB)
Show 3 Share
10 |10000 characters needed characters left characters exceeded

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

0
Former Member
Vadim Kalinin

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!

0

Yes!

Like this:

ins.png (7.9 kB)
1
avatar image
Former Member Dec 19, 2016 at 12:15 PM
0

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

Share
10 |10000 characters needed characters left characters exceeded
Vadim Kalinin Dec 19, 2016 at 12:21 PM
0

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

Show 2 Share
10 |10000 characters needed characters left characters exceeded
Former Member

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

Thank you very much!

0

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
0