Sample Data Model For Oracle Analytical Cloud

You can use the Data Modeler in Oracle Analytical Cloud to model Oracle Field Service data in a way that reflects the structure of your business. You can use the sample data model as a quick start reference to build complex business data models in Oracle Analytical Cloud.

Important: This information only applies to Oracle Field Service environments. You can verify whether you've Oracle Field Service or Oracle Fusion Field Service, by signing in and checking on the About page.

You can download the sample data model from Oracle Technology Network (OTN) and use it directly in Oracle Analytical Cloud, or extend it further based on your business requirements. You can also use the sample data model as a reference to build your own data models as required by your business

Here are the components of sample data model:

Data Model	Use this Data Model to:	Fact and Dimension Tables:
Activity data model This image shows activity data model and its components:	Represent Activity related business data in reports and dashboards.	Fact table: Activities Dimensions: Time [ Total, Year, Quarter, Month, Day.] Activity Type [ Total ] Work Zone [ Total ] Provider [ Total ] Geography [ Total, State, City, Zip ] Status [ Total ]
Message data model	Represent Messages business entity and its related business analysis.	Fact table: Messages Dimensions: Time [ Total, Year, Quarter, Month, Day.] Message Type [ Total ] Activities [ Total, Activities, Provider ] Result [ Total ]
User data model This image shows activity data model and its components:	Represent the User business entity and its related business analysis.	Fact table: User Dimensions: Time [ Total, Year, Quarter, Month, Day.] Provider [ Total ]
Collaboration Data Model	Represent Collaboration related data in Oracle Analytical Cloud.	Fact table: Chat Dimensions: Chat Participant Chat Message

Note: Oracle Business Intelligence Cloud Service (BICS) is deprecated from Oracle Field Service.