Please enable javascript to view this page in its intended format.

Queen's University
 

Bi Query FAQs


ITServices has gathered a listing of frequently asked questions. If you have a question that is not found on the list, please fill out the Online Support Form or call us at 613 533 6666.


Expand All / Collapse All
  • Q. How do I get access to data warehouses in BI Query?

    BI Query (formery GQL) data warehouses are restricted to staff and faculty.


    To obtain access to the BI Query data warehouses, follow these directions:

    1. Fill out the request form or contact the BI Query data warehouse administrators to be authorized for BI Query.
      • Finance:  contact Terena Grice (note: available only to Financial Services’ employees and finance business officers who have were initially licensed at the time PeopleSoft Go Live in 2009 – post Go-Live data now available via FAST and PeopleSoft Query Viewer)
      • HR: contact Mark Garrah at 78833
      • Research: contact the Office of Research Services at 36081
      • Student: request form is at  http://www.queensu.ca/registrar/facultystaff/studentdata/warehouse.html
    2. Once authorized, the BI Query data warehouses are accessed through a remote access service - see Managed Services for Windows Remote Access for details.
  • Q. How do I log into BI Query?

    BI Query data warehouses contain old data and are restricted to authorized staff and faculty.


    User must be authorized to log into this program. Refer to the email sent by the data warehouse administrators for instructions on logging into the system.

  • Q. Why do I get a connection failure when I try to login?

    Check if


    • The account and/or password is incorrect.  Note that this isn't always the same as your netid account or password.  Check with the data warehouse manager - see next answer.
  • Q. How do I retrieve a lost password?

    The BI Query password is dependent on which data warehouse that is being accessed.


    Contact the following people for the different data warehouses passwords:


  • Q. How do I set set my model to Export data to Excel?

    To set your model to Export data to Excel, go into Tools > Preferences. Click on Export Options. Select Excel for the Application. Click on the ... browse button to find excel.exe. Typically it will be in C:\Program Files\Microsoft Office\Office[]\excel.exe, where [] may be 11, 12 etc. The Service name should be set to Excel. For commands, DDE should be selected and the edit box set to [Paste()]. Click on OK, then go to the File menu and choose Save to update the model with this customization.


Kingston, Ontario, Canada K7L 3N6 613.533.2000