Database Spreadsheets

aP Analytics includes two predefined domains:

• aPriori Ad Hoc Data – Data from your Reporting Database
• Operational Ad Hoc Data – Data from the your Operational Database

To help you understand the schema models for the domains, aPriori provides these spreadsheets:

• Reporting Database spreadsheet – Information about the joins, table structure, and views in your Reporting Database.
• Operational Database spreadsheet – Information about the joins and table structure in your Operational Database and the relevant derived tables in aP Analytics.