Leagan Gaeilge   Text Version   Display: Zoom (-) (+)   View ( Normal High contrast ) Printer Friendly  A to Z  Sitemap

•   Important Links
• Staff eMail
• StudentMail
• Blackboard
• Print Credit
• Service Desk Ticketing System

information solutions and services, Quercus, Discoverer

   

Using Discoverer Version 4

In order to access Discoverer V4 you need to go to this URL http://www.mis.nuigalway.ie/staff/.
Under Administrative Staff click on Discoverer Reporting Tool.
This will bring you to the following screen.

N.B. Do NOT tick to ’Skip this page in future’
Then Click on Next and Start. 

Enter your username, password and database. For the first time only when you use Discoverer click on Cancel and go to
Tools/Options. Under Query Governor de-tick ’Limit retrieved query data to’.

Then Under Advanced tick Disable Fan-Trap detection and click on OK.

Then re-connect as the user again using File and Connect to Database. You should now be able to run all reports without any errors occurring. On the Discoverer Toolbar there are a few icons you will use:

Open
Refresh
Export to Spreadsheet

Running Reports

When logged in as the user, click on Open and Database. From the list of reports highlight the report you want to run and click on Open. If there is a parameter e.g. academic session then enter the year that you need this report for and click OK.

There may be several parameters attached to a report so, in order to run it, you need to fill all parameters e.g. academic year and status. Note the Status ’ R’must be in single quotes and uppercase as otherwise it will not run correctly. Any parameter that has single quotes around it must have the quotes retained when the user inputs it.

Another example is when the user puts the academic year and course instance in.

Again ensure that the details are in uppercase and enclosed in single quotes.

As the number of rows is limited to 25 rows per page, there may be several pages to go through. Use the left and right arrows on the bottom left of the screen in order to go forward or back through the pages. The total number of pages is also displayed.
To close the report click on file and Close.

To Choose from a list on Page Items e.g. Country – click on the black down-arrow to the right of Country and then choose which country you are interested in.

All lists which have a black down-arrow on the right have a list from which to choose.  If you have multiple sheets in a report, click on the sheet for which you require the information e.g. this report has a number of sheets. 
 

To get a list of all the sheets click on on the far right-hand corner and it will show the list available.

Then highlight the one you need to run and it will produce the report for you.  You may sometimes get a message to say that the query will take a long time to run but just ignore this as it may take a lot less time than it states.
 

It will usually tell you how it is progressing.

When exporting from Discoverer V4 to Excel, you may find that the security level of access is set too high for you to use this option. You need to start Excel and go to Tools/Macros/Security and change from high to Medium.

Including Extra Items in Page Items

If you want to include extra items from a report in page items to help filter data you
need to go to Sheet/Edit Sheet or click on Edit Worksheet.  This is the screen that you will be presented with.

Choose Table La (Table Layout) option. For example if you wanted to choose courses by department: all you need to do is drag Dept Description from the Body of the Report to Page Items.

When you click OK to run the report you will now see a black down-arrow, which allows you to click on a department, and get the details associated with it.


Again when closing do not save the report.

    

• Disclaimer
• Privacy
• Copyright
• Accessibility