Hide UCC from Dialogue Intelligence

Introduction

By default the reports show all UCCs in the database. If you want to limit this you have 2 options:

  1. Do not give access to the reports, but receive data from a subscription. Learn More

  2. Filter the UCC dropdown list with the parameter "Selected_UCCS" on specific UCCs IDs.

Warning Users with enough permissions can change the parameter back.

For full security we recommend splitting the database.

 

Get UCC id

  1. Open SQL Management Studio

  2. Connect to the UCC SQL instance

  3. Run the following query on the database:

    SELECT [id]

    ,[name]

    FROM [UCC_Name]

 

Change default value Selected_UCCS

  1. Navigate to the 'SQL Server Reporting Services'

    Note Based on your version of SSRS the layout will differ, but the actions will have similar names.

  2. (Optional) Open Folder if reports are placed in a Folder

  3. Select the dropdown button of the "Welcome" report.

    Note:If users don't start directly on the Welcome report, then also do these steps on all reports.

  4. Select Manage

  5. Select Parameters

    Note: If you don't see this option, you do not have enough permissions.

  6. Change the value in Default Value of "Selected_UCCS"

    Tip: You can enter multiple rows for multiple UCCs.

  7. Click Apply

The parameter's default value has now been changed.