If your Practice IQ (PIQ) Excel reports show the error "Unable to establish connection to the database", you can update the connection details in each template. You'll need your server name and OLAP database name.
Open a PIQ Excel template.
In the Intro tab:
Enter the server name in the Server Name field.
Enter your OLAP database name in the Database name field.
Click the Update Connection button to update the connection string.
Save the changes.
Repeat the same steps to update all the PIQ templates.
