Skip to Content

Matrix Security in Standard Edition BPC 10.1

Hi Experts

We have a requirement to setup matrix security for Entity and Category combinations. I understand this feature is only available in Embedded rather than Standard.

Anyone have any ideas as to a solution to address?
For clarity – User 1 would have access to CATEGORY=ACTUAL and Entity 1,2,3 and for Category = WORKPLAN only Entity 2. Etc.

Any ideas?
I saw UJ_VALIDATION rules or limiting in the INPUT forms but this is not restrictive enough as users may use the same form for different categories.

Thanks in advance.


Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on Jul 28, 2016 at 09:15 AM

    Hi Eyal,

    Standard model does not support Matrix security. Validation rules are not a good substitute for authorizations, their purpose is to guide users and to improve data quality. Also, validations don't prevent users from seeing data in a report.

    In case of a matrix organization, the standard workaround is to use a dimension that combines e.g. company and profit center. This approach might not suit your purposes well. Another way, which I really don't like, is to use separate user ID's for different roles. If matrix security is a show stopper, you have one more reason to consider using the Embedded model.


    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.