Skip to main content
insightsoftware Documentation insightsoftware Documentation
{%article.title%}
Published:
Was this article helpful?
0 out of 0 found this helpful

Suppress, Restore Rowid Column-Based Master Keys

You can suppress or unsuppress the master keys that are based on rowid columns. The suppressed master keys will not be available in the presentation layer of your reporting tool.

To suppress, restore a rowid column-based master key

  1. On the NoetixViews Workbench home page, click Modify a View. The Modify View page appears.

  2. Select a view, and then click Modify. For more information, see Select a View.

  3. On the Modify View » <view label> page that appears, under View, click Add, modify keys and joins, and then click Next. The Modify View » <view label>» Add, modify keys and joins page appears.

  4. Under Master Keys, select the check box associated with the rowid column-based master key that you want to suppress or unsuppress.

    • To suppress the master key, perform the following:

      1. Click Suppress. The Suppress Master Key dialog box appears prompting you to confirm the action.

        IMPORTANT: If the master key that you are suppressing is being used in existing joins, the dialog box will indicate the number of joins to the master key and caution you that suppressing the master key will affect reports that use these joins.

      2. Click Yes. In the list, the master key will be updated with the suppressed value as "Yes".

    • To restore the suppressed master key, perform the following:

      1. Click Unsuppress. The Unsuppress Master Key dialog box appears prompting you to confirm the action.

      2. Click Yes. In the list, the master key will be updated with the suppressed value as "No".

  5. In the Customization comments box, provide a summary of the customizations that you have performed. The customization comments can contain a maximum of 200 characters.

  6. Click Save.The customizations are saved, and the Modify View» <view label> page appears.

Now, you can choose to perform any other customizations on the same view or go to the home page.

Published:

Suppress, Restore Rowid Column-Based Master Keys

You can suppress or unsuppress the master keys that are based on rowid columns. The suppressed master keys will not be available in the presentation layer of your reporting tool.

To suppress, restore a rowid column-based master key

  1. On the NoetixViews Workbench home page, click Modify a View. The Modify View page appears.

  2. Select a view, and then click Modify. For more information, see Select a View.

  3. On the Modify View » <view label> page that appears, under View, click Add, modify keys and joins, and then click Next. The Modify View » <view label>» Add, modify keys and joins page appears.

  4. Under Master Keys, select the check box associated with the rowid column-based master key that you want to suppress or unsuppress.

    • To suppress the master key, perform the following:

      1. Click Suppress. The Suppress Master Key dialog box appears prompting you to confirm the action.

        IMPORTANT: If the master key that you are suppressing is being used in existing joins, the dialog box will indicate the number of joins to the master key and caution you that suppressing the master key will affect reports that use these joins.

      2. Click Yes. In the list, the master key will be updated with the suppressed value as "Yes".

    • To restore the suppressed master key, perform the following:

      1. Click Unsuppress. The Unsuppress Master Key dialog box appears prompting you to confirm the action.

      2. Click Yes. In the list, the master key will be updated with the suppressed value as "No".

  5. In the Customization comments box, provide a summary of the customizations that you have performed. The customization comments can contain a maximum of 200 characters.

  6. Click Save.The customizations are saved, and the Modify View» <view label> page appears.

Now, you can choose to perform any other customizations on the same view or go to the home page.

For an optimal Community experience, Please view on Desktop
Powered by Zendesk