This shows the ERD for the Conceptual Model shown above on the left
A Semantic Layer is a business translation layer that sits between the database and the end user.
This means that Users can define their Reporting requirements using familiar business terminology
instead of Data Modeller terms.
For example, 'Customer' instead of 'Party'.
We have also designed :-