Skip to main content
Submitted

Add Data Selection Rule and Column Selection to Securable Views

  • August 14, 2019
  • 2 replies
  • 4 views

Forum|alt.badge.img

The securable views are pretty useful, but suffer from a couple of important limitations.  

The first is that each view will contain every record from its source table.  This isn't always desirable - it may be ideal to create a view of a fact that contains only certain kinds of transactions, or a view of a Type II SCD dimension with only the current values.  Right now, the only way to accomplish this is to create physical versions of these tables, which is a clunky solution at best and unviable at worst. 

The other problem is that you can't control what columns end up in these views.  The most obvious problem issue is that this means that all of the system fields will show up in the securable view, which is not desirable because these views are almost always exposed directly to the user.  It also reveals the existence of all the columns in the table to everyone who has access to the view, even if access to those columns is restricted by a security policy.  

If these two features were added, securable views would be considerably more flexible and powerful tools!

2 replies

Forum|alt.badge.img
  • New Participant
  • October 30, 2020

Should also be possible to make a secured view of a view


  • Community Manager
  • February 26, 2021

Thanks for submitting your ideas! Your continued feedback on our product is very important to us.

We will be evaluating your input for future improvements in the product.

At the time of this posting, the current product roadmap is focused on a major evolution in foundational pieces of our software including splitting the development into ODX, MDW, Semantic Layer and User Portal. With this evolution, we will continue to see incredible innovation in the product that may exceed your expectations or make the need for this feature obsolete.

If you have any questions or would like to discuss further, please reach out to me or the dedicated TimeXtender Solution Specialist in you region. Thanks!