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.
BI Query (formery GQL) data warehouses are restricted to staff and faculty.
To obtain access to the BI Query data warehouses, follow these directions:
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.
The BI Query password is dependent on which data warehouse that is being accessed.
Contact the following people for the different data warehouses passwords:
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.