Page Comparison

Applies to: Kyvos Enterprise Kyvos Cloud (SaaS on AWS) Kyvos AWS Marketplace

...

Panel

panelIconId	atlassian-note
panelIcon	:note:
bgColor	#DEEBFF

Note

Column masking is not applied to Member Properties, Unknown and Calculated members, and Predefined time type hierarchy.
Currently, column masking does not support the SQL interface.
Partial masking on numerical dimension field is not supported.
Merging of measure values for fully masked only attribute/single level hierarchy is not supported.
The original column data is preserved while masking because numeric data is masked with a number, and a date is masked with a date. You can specify a fixed pattern or a Regex expression for any string data type.
The masked value is displayed while browsing the semantic model on any BI tool with an MDX connection.
If using Tilde (~) for column masking and want to apply a filter on the masked value from Kyvos UI, then you must change the value of the field value separator as the default value of the kyvos.filter.value.separator property is also Tilde (~). Hence, you must change the default value of this property so that column masking with the Tilde character can function.
To apply column masking to a pre-defined hierarchy, you need to select the full name of the hierarchy.
You can create, delete, update, save, and assign column security (masking) rules by using the Security Rest API's.

To apply unconditional column masking for Column Level Security (CLS), perform the following steps.

From the Toolbox, click Semantic Models.
Select the semantic model name from the list and click the Process tab if needed.
Click the Action menu (...) in the work area, then click Data Security.
If the option is not displayed, you must save the semantic model and try again.
Click users or groups that this rule will apply to.
Click the plus sign in the Rules column.
Add a rule name and description.
From the Column Level area, click the Mask Data link, and then select the field on which you want to apply the column masking. By default, the Mask data is applied. This indicates unconditional data mask.
Click the value link, and the Mask with dialog box is displayed. You must enter the required value for unconditional column masking. The available choices vary depending on the data you are using.
1. For any string data type, choose one of the following:
  - Fixed: Use this option to specify a fixed value for column masking. Enter a value that you want to apply for column masking. The entered value is displayed in the Preview area.
    NOTE: You can specify any character or special characters, such as #, *, @. If you keep the field blank, then while semantic model browsing, the field value is displayed as blank.
  - Regex: Use this option to specify a Regex expression for column masking.
    1. Enter a Regex expression that you want to specify for the field value, and then provide a value that you want to use for column masking.
    2. You can also select a Regex expression from the Choose from common expressions list.
    3. To verify whether the Regex expression is successfully masked with the value, enter a relevant value in the Test Value field. The result is displayed in the Preview field. If the expression is not masked successfully, you can modify the expression, as needed.
      NOTE: In an expression, the Delimiter (/) and the flags (g,m,i,u,s,d) are not supported.
Click the plus sign to add additional fields, if required.
Click Add.

Unconditional column masking using the Fixed pattern

...

Conditional masking (Beta)
Anchor
columnmasking
columnmasking

...

From the Toolbox, click Semantic Models.
Select the semantic model name from the list and click the Process tab if needed.
Click the Action menu (...) in the work area, then click Data Security.
If the option is not displayed, you must save the semantic model and try again.
Click users or groups that this rule will apply to.
Click the plus sign in the Rules column.
Add a rule name and description.
From the Column Level area, click Mask Data and select Conditionally mask data, and then select the field on which you want to apply the column masking.
Click the Conditional Mask Data link and click the field link. The field list is displayed. Select the field that you want to conditionally mask.
Click the value link, and the Conditional Mask with dialog box is displayed. You must enter the required value for conditional column masking. The available choices vary depending on the data you are using.
1. For any string data type, choose one of the following:
  - Fixed: Use this option to specify a fixed value for column masking.
    For any string data type, choose one of the following:
    Enter a value that you want to apply for column masking. The entered value is displayed in the Preview area.
    NOTE: You can specify any character or special characters, such as #, *, @. If you keep the field blank, then while semantic model browsing, the field value is displayed as blank.
  - Regex: Use this option to specify a Regex expression for column masking.
    Enter a Regex expression that you want to specify for the field value, and then provide a value that you want to use for column masking.
    You can also select a Regex expression from the Choose from common expressions list.
    To verify whether the Regex expression is successfully masked with the value, enter a relevant value in the Test Value field. The result is displayed in the Preview field. If the expression is not masked successfully, you can modify the expression, as needed.
    NOTE: In an expression, the Delimiter (/) and the flags (g,m,i,u,s,d) are not supported.
Click the field link to select the field on which you want to apply conditional column masking.
Click the plus sign to add additional fields, if required.
Click Add.