Removing members from the EPM Context Drop Downs

[Former Member]

Hello All,

I was wondering how I go about removing a context member drop the EPM context drop downs? I have tried a few things but they always show up a selectable. In essence, even though these are valid members of the dimension, I do not want a user to be able to select them. We have been doing this so far with VBA to prevent a refresh or save but I would rather avoid VBA going forward if possible.

I have attached 3 screen caputes to demo what I am trying to remove.

Capture 1 - Shows the EPM Context Bar

Capture 2 - Shows the 2 that I would like to remove

Capture 3 - Shows the EPM Member Selector with the 2 that I want to remove. And yes the first one is the top of the node

Cheersn

[Former Member · Accepted solution]

Hi Chris,

As of now there is no such facility to hide any member from selection from EPM pane, but what can be done is you can control the data entry to specific IDs through security (Data access profile) to make sure that these ID cannot be used by unintended users. Alternatively, u may explore UJ_Validation to put restriction on data entry on these IDs.

Regards,

Kalyan.

[Former Member · Accepted solution]

Thanks Kalyan,

I would like to try this one out.

Cheers,

[Former Member]

Hi Chris,

You can use the context options, and select which dimension should be hidden.

Hope this helps.

[Former Member]

Hi Nilanjan,

I am looking to hide specific members of the dimension on my templates. The issue with context options that I have found so far is that users can overrride what the developer set. As of right now we have not found a way to lock this

Cheers,

[Former Member]

Hi Chris,

In that case, you can have that dimension in your page axis, set to a particular member. Lock the template with some password, so that the users cant change the page axis.

Hope this helps.

[Former Member]

Thanks, sorry for the late reply

[Former Member]

Hi,

In 7.5, Lock the CV memebr againsts selection is available. Not sue in 10. Should be there, Did you see the Workbook options?

Thanks,

Sonti.

[Former Member]

Yes I can do this but users can override this. Unless there is some security that can prevent this. So far even with locking our sheets, the users can still override this

[Former Member]

Hi Chris

Would it be feasible to add a property to the dimensions where these members are being selected from (i.e., Do Not Select Flag).  Then, ensure the items you do not want to select are marked with an 'X' or similar.

Then, in your reports, add a check to the selection to filter out anything where new property = 'X' ?

Ian

[Former Member]

Ian,

This is a possibility, especially if we have members of a dimension that should new be chosen. It least the data is on the dimension itself and can be shared.

Thanks,