Forum Discussion

JKarrick's avatar
JKarrick
Frequent Visitor
2 years ago

Object Level Security that is measure dependent

In a tabular model for analysis services, the lowest level of a shared product dimension needs to be hidden from a a group of users if they select inventory measures, but they can see all product col...
lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
2 years ago

use two copies of the Product Dimension table.  Join the one with the visible materials column  to the invoices and the one with then hidden materials column to the inventory 

JKarrick's avatar
JKarrick
Frequent Visitor
2 years ago

If inventory is joined to the version of the Product dimension with the material column hidden, wouldn't that hide material from all users? Most users should see inventory by material. It's only sales reps that need to have material hidden.

  • lbendlin's avatar
    lbendlin
    Icon for Super User rankSuper User
    2 years ago

    If you have sufficiently diverse audiences then you better create separate reports.

    • JKarrick's avatar
      JKarrick
      Frequent Visitor
      2 years ago

       I'm using Tabular Editor for an Analysis Services cube that is accessed by the entire company in Excel for ad-hoc and some PBI reports. This requirement seems difficult to implement so was hoping some advanced DAX with OLS might make it possible. 

      • lbendlin's avatar
        lbendlin
        Icon for Super User rankSuper User
        2 years ago
         I'm using Tabular Editor for an Analysis Services cube that is accessed by the entire company in Excel for ad-hoc and some PBI reports.

        Would have been nice if you had led with that.

         

        In that case I think you need two cubes.