Data Models in BI Server

Data Models represent a logical grouping of your data to allow for a user-friendly manipulation and customization. In relational database terms, they represent an SQL database. Data models define relationships between Data Tables. These relationships can be used to easily query the data in a model. The data for the tables in a model is cached in memory. An active configuration of a BI Server can host multiple Data Models. Each Data Model is treated independently of any other, and data queries access the data of a single Data Model.

In the following sections we will dive into the required steps and workflows for configuring a fully functional Data Model.

• Creating a Data Model
• Creating a Data Table
• Customizing a Data Table Schema
• Configuring a Data Table Refresh
• Incrementally Loading Data into a Data Table
• Creating Relationships between Tables