Connecting an Existing Report to a Local Connection File

  1. Create a folder where you would like to store your Analytics reports. In this example, it's a folder on the Desktop called 'Analytics.'
     
  2. In iSalus, navigate to Reports.
     
  3.  Click Billing Analytics (Adv.) if you have both billing analytics models. Otherwise, click Billing Analytics.
     
  4.  A pop up will appear prompting you to save the report – click the down arrow next to Save, and click Save as:

     

  5. In the resulting window, name your file whatever you would like it to be called, then save it to the folder you created in Step 1. In this example, it's called 'Analytics'.
     
     Graphical user interface, application, email

Description automatically generated

  6. Open the report that you’re wanting to connect to the cube on your own machine. At the top of the screen, click Data, then Queries and Connections:
     
     Graphical user interface, application

Description automatically generated

  7. You will see a connection in the right-hand pane. Double-click this connection:
     
     Graphical user interface, text, application

Description automatically generated

  8. In the Definition tab of the Connection Properties, use the Browse button to navigate to where you have saved your local connection file, and select it.
     
     Graphical user interface, text, application, email

Description automatically generated 

  9. Back in the Definition tab, ensure that the Always use connection file and Save password boxes are checked (clicking Yes for confirmation), and click OK:
     
     Graphical user interface, text, application, email

Description automatically generated

  10. At this point you can save your report, preferably in the same folder as the connection file. If you ever move the connection file, you may need to modify the Connection file property in the Connection Properties window shown above.