iQuery - Pull R&A Data to Excel

Navigate to mtu01-ohra-prod.hospitality.oracleindustry.com

Sign into R&A

Navigate to the left options tab and Click on 'Tools' then click on 'iQuery download'

Click on 'Install MICROS iQuery - Office 2007 +' to download the Add-In.

Select a folder of your choosing to save the executable in.

Navigate to where the file was saved and

double click on 'iQuerySetup.exe' to install the Add-In.

Click 'Next' throughout the installation and then 'Close' at the end.

After the installation was successful, open Excel.

Open a new spreadsheet and click on 'Add-Ins' located in the Toolbar.

Click on the 'i' icon located in a red circle to open iQuery.

Enter the following information in the respective fields:

Host Address: mtu1-ohra-iquery.oracleindustry.com

Username: R&A login account name

Company: MFG

Password: R&A login password

Click Login.

Select 'Columns' 

Select the respective columns you wish to view in the spreadsheet.

Navigate down to 'Filters' and select 'Business Date'

Select the range of dates you wish to view.

The other fields should be automatic depending on the account that was used to log in at the start of the Query.

In the vent that they are not automatic:

Navigate to 'Location' and tick the relevant tick boxes.

Navigate to 'Revenue Centre' and tick the relevant tick boxes.

Click on the 'Save' button in order to save the Query to avoid having to manually enter the desired settings each time this Query is run.

Save it to your desired location.

After saving the Query, Click on 'Run' to run the Query to view the report.

After run is clicked, Excel will populate with the columns selected and generate a report similar to the example image.

Format Excel to your preference.