Overview
Data Model Extensions act as the foundation for all the data structures that business users utilize to build reports in Cosmos. An extension can consist of tables and fields from data sources, transformations to clean that data, and then the creation of tables and fields in the reporting database that the data is then mapped to. This article will cover the general concepts of Data Model Extensions and how they are used within Cosmos.
Details
Data Model Extensions can be viewed as the building blocks that make up the overall data available to Cosmos users. While extensions are meant to encompass all the source data and business logic meant to address a specific subject area, such as Sales or Finance, they can be used in a wide variety of ways.
Data Model Extensions were designed to be flexible components that can incorporate the following information into the data model:
- Tables and fields from a data source
- Transformations, such as lookups, calculated fields, and fixed values, which are used to clean up the business data and get it ready for business users
- Creation of tables and fields in the reporting database, or Data Model, that business users will utilize to create reports
- Mapping of source tables and fields, as well as transformations, into this Data Model
There are many pre-built Data Model Extensions that are provided by Cosmos and enable businesses to quickly add content into a data model. These are accessed from the Extension Gallery, and more details on that topic are covered in the article here: Working with the Data Model Extension Gallery. Extension can also be added by anyone that has the Data Model Editor role assigned to them within Cosmos.
Comments
0 comments
Article is closed for comments.