Universe Design (Semantic Layer)
Objective of Semantic Layer

With the increasing number of data sources, one challenge for a BI deployment is to gather data coming from multiple databases. In most situations, a new data mart is usually put in place to synchronize all of the information.


Creating a data mart requires moving data from the various sources to the target source with a data integration process.

  • Setting up the data mart and the integration jobs is often expensive in terms of resources and lengthy in time.
  • That is why; Semantic Layer is designed to provide an easy-to-use interface for non-technical business user from different data sources.


Introduction to Semantic Layer

  • A semantic layer is a business representation of corporate data that helps end users access data autonomously using common business terms.
  • Semantic layer maps complex data into familiar business terms such as product, customer, or revenue to offer a unified, consolidated view of data across the organization.
  • A semantic layer simplifies the complexity of business data. These business terms are stored as objects in a universe, accessed through business views.
  • A semantic layer enables business users to access and analyze data stored in a relational database and OLAP cubes.
← Prev Step

Thanks for contacting us. We'll get back to you as soon as we can.

Please provide a valid name, email, and question.

Powered by LivelyChat