Error: Either the user, <username>, does not have access to the Infinity_DEMO_RPT_BBDW_UDM database, or the database does not exist when opening or refreshing an OLAP Excel report

When attempting to open or refresh an Excel OLAP report, the error: Either the user, <username>, does not have access to the Infinity_DEMO_RPT_BBDW_UDM database, or the database does not exist when opening or refreshing an OLAP Excel report is returned.
We’re currently evaluating this issue for a fix in a future release.

Workaround: Manually edit the connection string information in Excel to point to the correct UDM database.

Steps to Duplicate

1. Navigate to Analysis and select OLAP Excel reports.
2. Highlight a report (Appeal Analysis, for example) and select 'Create workbook'.
3. Open the report in Excel and select 'Enable editing', and then 'Enable content'.
4. Receive the error: Either the user, <username>, does not have access to the Infinity_DEMO_RPT_BBDW_UDM database, or the database does not exist.

Environment

 Blackbaud CRM
 4.0

Was this article helpful?