Hide UCC from Dialogue Intelligence
By default the reports show all UCCs in the database. If you want to limit this you have 2 options:
Do not give access to the reports, but receive data from a subscription. Learn More
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
Open SQL Management Studio
Connect to the UCC SQL instance
Run the following query on the database:
Change default value Selected_UCCS
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.
(Optional) Open Folder if reports are placed in a Folder
- 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.
- Select Parameters
Note: If you don't see this option, you do not have enough permissions.
- Change the value in Default Value of "Selected_UCCS"
Tip: You can enter multiple rows for multiple UCCs.
The parameter's default value has now been changed.
Did you find this page helpful?
Sorry about that
Why wasn't this helpful? (check all that apply)
Thank you for your feedback.
Thanks for taking the time to give us some feedback.