Oracle Hospitality Reporting and Analytics Advanced enables you to retrieve high-level guest check information and transaction-level information from the system.
To retrieve high-level information, use Check Query to retrieve basic check information. For example, you can search for check totals less than $10.00 for a date range from a specific location.
To retrieve transaction-level information, use Audit & Analysis to query the system. Audit & Analysis enables you to build custom queries by applying filters. You can use the query results to identify trends that require research, such as a high number of error corrections or voided transactions. The following table describes the Audit & Analysis queries you can create. Your role or user type determines the queries you can create.
| Type | Description |
|---|---|
|
Transaction Detail |
Retrieves transaction-level data. For example, you can query transactions for specific menu item purchases at a location. |
|
Transaction Summary |
Retrieves summary-level data. For example, you can query transactions for a tender media type such as credit card purchases for a customer. |
|
Non-Check Transaction |
Retrieves data for non-check transactions. For example, you can query training transactions for workstations at a location. |
|
Authorization |
Retrieves data for transactions that require authorization. For example, you can query voided service charges from a round for a revenue center. |