Skip to main content

PIQ: Change the connection details in Practice IQ (PIQ) Excel reports

Steps to update the server and database details in your PIQ templates.

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.

  1. Open a PIQ Excel template.

  2. In the Intro tab:

    • Enter the server name in the Server Name field.

    • Enter your OLAP database name in the Database name field.

  3. Click the Update Connection button to update the connection string.

  4. Save the changes.

  5. Repeat the same steps to update all the PIQ templates.


​

Did this answer your question?