How to Add Integer Type Column in User-based Filter Support of Bold BI
Published:
In Row Level Security, we have provided support for dimension columns exclusively as they adequately address the necessary use cases. As a result, only dimension columns are included in the Data Column drop-down menu of the user-based filter window. If you want to utilize an integer type column in a user-based filter, you have the option to convert the necessary integer type column into a string type column using expression column support of Bold BI application.
Step by Step procedure to use integer type column in user-based filter:
- Create a required data source and create an expression column to convert an integer type column into string type column as follows: CAST([Column Name] as Varchar)
- Open User-Based filter window and you can see that the created expression column will be included in Data Column drop-down.
- Now, choose that created expression column from Data Column drop-down and configure the required user-based filter.
Additional Reference:
SM
