Workflow to Build a Semantic Model
Here are the common tasks for creating and building a semantic model.
Use can these LiveLab workshops to help you create and develop your semantic model:
LiveLabs Sprint - Model Your Data With
Semantic Modeler - Part 1
LiveLabs Sprint - Model Your Data With
Semantic Modeler - Part 2
Task | Description | More Information |
---|---|---|
Understand Semantic Modeler |
Use Semantic Modeler to create a semantic model and build its physical, logical, and presentation layers. |
|
Request Permissions to Use Semantic Modeler |
Ask your administrator to give you the BI Data Model Author application role. To check you if have permission to use Semantic Modeler, navigate to the Home page, click Create, and look for the Semantic Model option. If you don't see the Semantic Model option, then you don't have the BI Data Model Author application role. If you plan to set up one or more data source connections for your semantic model, ask your administrator to give you the DV Content Author application role. Ask your administrator to grant you the Create and Edit Datasets permission if you want the Tiles view to display when you inspect a physical table or alias table's data. |
|
Confirm that your data source is supported |
Understand which data sources Semantic Modeler supports. Before you import a semantic model from Model Administration Tool, confirm that Semantic Modeler supports the model's data source. Be sure to remove or replace any unsupported data sources in the semantic model before migration. The import fails if a semantic model contains an unsupported data source. |
|
Create the Semantic Model |
Create the semantic model in one of the following ways:
|
|
Build the Physical Layer |
Define the semantic model's data sources and the relationships between physical databases and other data sources that the Oracle Analytics query engine uses to process multiple data source queries. Define other attributes of the physical data sources, such as join relationships, that might not exist in the data source metadata. Tasks include:
|
Build a Semantic Model's Physical Layer Work with Multidimensional Data Sources in the Physical Layer |
Build the Logical Layer |
Define one or more business model objects that contain the business model definitions and the mappings from logical to physical tables. Create logical tables (fact and dimension) containing logical columns. Tasks include:
|
|
Build the Presentation Layer |
Structure the logical layer's objects to be presented to users as subject areas that they'll use to build visualizations and analyses. Tasks include:
|
|
Test and Validate the semantic model |
Check the semantic model for errors. Deploy the semantic model. Test the semantic model by creating visualizations and analyses and verifying the results. Tasks include:
|