Skip to main content

Notifications

Business Central forum
Suggested answer

Is the a way to globally filter data to a specific value of a dimension ?

Posted on by 3
Here is my problem...
We have several purchasers in different departments.
Each of these purchaser has the same functional rights in the system:
  • Create a sales quote
  • Do the reception
  • Create an incoming document
  • ...
We want to limit their vision to their own department (a specific dimension).
 
I know I can create a specific "permission set" and add a filter to it to limit the view.  But, using this method, I need to add a filter on multiple tables in the permission set and repeat the operation by creating a new permission set for each department (~20 differents dimensions).
 
Is there an easy way to globally limit a user's access to a specific dimension?
  • gdrenteria Profile Picture
    gdrenteria 9,387 Most Valuable Professional on at
  • Suggested answer
    Valentin Castravet Profile Picture
    Valentin Castravet 22,129 Super User 2024 Season 2 on at
    Is the a way to globally filter data to a specific value of a dimension ?
    Personally I still recommend using responsibility centers as appropriate for your case, as they are essentially designed for this purpose in the system. With responsibility centers, each user can only view master data, such as vendors and purchase documents, that are linked to their own responsibility center.
     
     
    The only caveat is that you'll need to create responsibility centers that align with your dimensions. Additionally, if you need to restrict a user to their own department for functional areas outside of purchasing, responsibility centers won’t work out of the box and in that case you can keep using dimensions and customize the system. For instance, you might want to limit their view in the general ledger or similar areas.
     
     
     
     
  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 69,510 Super User 2024 Season 2 on at
    Is the a way to globally filter data to a specific value of a dimension ?
    Hi, As far as I know, it is not possible to do it in the standard functions.
    If you don't use Security Filter, you can only consider customization.
     
    Thanks.
    ZHU
  • Suggested answer
    Valentin Castravet Profile Picture
    Valentin Castravet 22,129 Super User 2024 Season 2 on at
    Is the a way to globally filter data to a specific value of a dimension ?
    This is typically accomplished using responsibility centers and not dimensions. You would simply setup responsibility centers that mimic your dimensions. - How to work with responsibility centers - Business Central | Microsoft Learn


Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Anton Venter – Community Spotlight

Kudos to our October Community Star of the month!

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,522 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,441 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans