Define Logical Table Source Data Granularity

Define granularity for the dimension tables and dimension and level information for the fact table joined to the dimension tables. The Oracle Analytics query engine uses this information to find the required level of detail for the requested data.

1. On your home page, click Navigator and then click Semantic Models.
2. In the Semantic Models page, click a semantic model to open it.
3. Click Logical Layer .
4. In the Logical Layer pane, browse for and double-click the dimension table with the table source you want to define data granularity for.
5. In the table's tabs, click Sources.
6. In the table sources list, click the logical table source that you want to define data granularity for and then click Detail view to open the properties pane.
7. Scroll to Data Granularity, click the Defined by field, and choose a level. Repeat this step for other dimension tables as needed.
8. In the Logical Layer pane, browse for and double-click the fact table joined to the dimension tables that you defined data granularity for.
9. In the table's tabs, click the Sources tab.
10. In the logical table sources list table, click the logical table source that you want to define data granularity for and then click Detail view to open the properties pane.
11. Scroll to the pane's Data Granularity section and click Add Level.
12. In the new level's Dimension field, click the dropdown button and choose a dimension table. In the Level field, click the dropdown button and choose a granularity level. Repeat this step for other dimension tables joined to the fact table.
13. Click Save.