Creating Your Initial Data Model From Relational Sources Using Oracle BI Cloud Service Data Modeler
Create a fact table, select aggregation rules for measure columns, and hide and rename columns using Data Modeler. Create a dimension table, hide a column, concatenate two columns, and create a column by copying. Create a join between the fact and dimension tables, and then validate and publish the data model. Create a report in Visual Analyzer to ensure your model is available.