Skip to main content
SUBMITTED

Tabular Object-Level Security

  • September 4, 2019
  • 12 replies
  • 117 views

Forum|alt.badge.img

Object-level security was introduced in the launch of Tabular 2017. This feature allows you to hide tables and columns from the end user.  

The ability to hide columns and tables is vital if you need to do something like allow a salesperson to see their total sales, but hide the cost of the sale, which would also exist in the sales fact. Another critical example would be to restrict access to tables or columns that contain PII to managers or HR. In fact, I do not know how you can make a Tabular model GDPR or CCPA compliant without this feature, unless you exclude all PII entirely.

There are hacky workarounds to get a similar effect with row-based security, but they only work with simple, small models. I think anyone who's building a serious enterprise solution with stringent compliance requirements is going to really want this feature.

12 replies

Forum|alt.badge.img

This is definitely required to have GDPR compliant tabular models for broad use. Currently the lack of this functionality forces us to physically separate models for different audiences.

At this point we're even investigating the option to develop the semantic models outside of the discovery hub. That also has major drawbacks, but it does unlock a range of much desired functionality.


  • Starter
  • October 21, 2019

Hi Steven,
we are also checking the option to build the semantic layer inside/outside Discovery Hub.  Which desired functionalities do you actually miss in Discovery Hub ? 

Best regards,

Peter 


  • Explorer
  • October 22, 2019

We too are having to contemplate developing semantic models outside of discovery hub because of this gap, which is a shame.  


peter.jensen
TimeXtender Xpert
Forum|alt.badge.img+3
  • TimeXtender Xpert
  • February 16, 2020

Hi,
we're implementing tabular models more frequently and the need to have object level security (role-based as in Multidim cubes) is a must.

When will this be implemented in Discovery Hub ?

Best regards,
Peter


  • Starter
  • July 22, 2020

Hi,

This feature really needs to be added to TimeXtender to make mature semantic models inside the application.

Best Regards,

Jasper


  • Starter
  • July 23, 2020

Hi,

I agree, this feature is very important to us because we use one large semantic model for the entire organization.

Best regards,

Roy


erik.van.mastrigt
TimeXtender Xpert
Forum|alt.badge.img+3

We have some customers in the need of this functionality as well. Would be great if support for OLS can be added!


  • Starter
  • January 5, 2024

I agree. We currently have a single semantic model covering multiple areas - Procurement, Sales & Production

 

Currently, we are trialling Tabular Editor to manage Object Level Security ( and restrict users to their relevant areas ) … but this is then controlled externally & not visible in TX


Forum|alt.badge.img+2
  • Contributor
  • July 18, 2025

Is there any news on this feature? Would be great if we could use this in Tabular endpoints!


bas.hopstaken
TimeXtender Xpert
Forum|alt.badge.img+5
  • TimeXtender Xpert
  • July 28, 2025

Hi ​@KajEmergo , 

We have a customer who has built a workaround using PowerShell scripts to create Tabular Object Level Security. This solution is based on Perspectives and Roles created in the Semantic Model within TimeXtender. The PowerShell script is also scheduled in TimeXtender, so Object Level Security is applied automatically.

To encourage TimeXtender to support this natively, we had a call a couple of weeks ago with our customer and a TimeXtender developer.

The developer told us that the feature is on their backlog and will likely become part of the current Row Level Security setup wizards. At the moment, it does not have a high priority, but I’ve requested that it be given higher priority. I hope they will act on this in the near future.


erik.van.mastrigt
TimeXtender Xpert
Forum|alt.badge.img+3

Hi,

My customer is also still waiting for this functionality, which becomes more and more urgent. From our side also kind request for higher priority

Thanks,

Erik


rvgfox
Problem Solver
Forum|alt.badge.img+4
  • Problem Solver
  • September 4, 2025

In the middle time, I’m using a C# script in Tabular Editor to apply to the model.