Meta Model Definition Spreadsheets
Meta Model Definition Spreadsheets¶
Use this document in conjunction with your aPriori Operational Database (DB) and Reporting Database spreadsheets. For more information, download Operational DB spreadsheet and Reporting DB spreadsheet.
Operational Data Database Spreadsheet¶
The Operational Database Spreadsheet (aPrioriaPAnalytics_<version>_Operational-DB.xls) contains information about the joins and table structure within the Operational Database as well as derived tables used in aP Analytics. aP Analytics’s Ad Hoc reporting tool presents data from the Operational Database in the Operational Ad Hoc data domain.
This table includes the names and order of each worksheet tab in the Operational Database spreadsheet.
| Order | Name |
|---|---|
| 1 | Versions |
| 2 | Tables and Joins |
| 3 | Admin Activity |
| 4 | Admin Info |
| 5 | All Activities (derived table) |
| 6 | Costing |
| 7 | Create Comparison |
| 8 | Delete |
| 9 | Edit |
| 10 | Generate Report |
| 11 | Load CAD File |
| 12 | Login |
| 13 | Open |
| 14 | Publish |
| 15 | Refresh Cost |
| 16 | Revert |
| 17 | Save As |
| 18 | Save Comparison As |
| 19 | Set Comparison |
| 20 | User |
| 21 | User License |
| 22 | User Management |
Reporting Database Spreadsheet¶
The Reporting Database spreadsheet (aPrioriaPAnalytics_<version>_Reporting-DB.xls) contains information about the joins, table structure, and views within the Reporting Database. The aP Analytics Ad Hoc reporting tool presents data from the Reporting Database in the aPriori Ad Hoc data domain.
This table includes the names and order of each worksheet tab in the Reporting Database spreadsheet.
| Order | Name |
|---|---|
| 1 | Metamodel definition overview |
| 2 | Tables and Views |
| 3 | all_latest_scenarios |
| 4 | assignee_base |
| 5 | assignee |
| 6 | auth_group |
| 7 | auth_group_attribute |
| 8 | auth_user |
| 9 | auth_user_to_auth_group |
| 10 | child_to_parent |
| 11 | configuration_property |
| 12 | container_object_structure |
| 13 | cost type |
| 14 | costed_by_user_base |
| 15 | costed_by_user |
| 16 | costed_date |
| 17 | created_by_user_base |
| 18 | created_by_user |
| 19 | created_date |
| 20 | dtc_metric |
| 21 | dtc_metric_process_group |
| 22 | DTC Metric List |
| 23 | export_date |
| 24 | export_event |
| 25 | export_event_to_scenario_facts |
| 26 | export_history |
| 27 | export_set |
| 28 | fx_rate |
| 29 | last_saved_by_user_base |
| 30 | last_saved_by_user |
| 31 | last_assigned_date |
| 32 | last_saved_date |
| 33 | latest_export_event |
| 34 | machine |
| 35 | material |
| 36 | material_catalog |
| 37 | operation |
| 38 | operation_custom_output |
| 39 | operation_facts |
| 40 | operation_override |
| 41 | operation_setup_option |
| 42 | process |
| 43 | process_custom_output |
| 44 | process_factes |
| 45 | process_group |
| 46 | process_override |
| 47 | process_setup_option |
| 48 | process_df |
| 49 | quote_reference |
| 50 | scenario |
| 51 | scenario_facts |
| 52 | scenario_override |
| 53 | scenario_thumbnail |
| 54 | schema version |
| 55 | user_defined_attribute |
| 56 | Notes |