4.2 Getting Started With Data Models

Once you have created a datasource as described in Defining a Data Source, you can proceed to create queries, data models, and Data Worksheets. Data models are logical abstractions of database schemas, similar to Entity-Relation Models. In Style Intelligence, a full data model includes the following three components:

Physical view: A set of database tables and the joins between them

Logical model: A logical mapping of table fields to meaningful business units

OLAP overlay: A mapping of data model fields to hierarchical dimensions and measures

A basic data model includes just the physical view and the logical model. The following example demonstrates how to create these essential components. For full information on all aspects of data models, see Relational Databases in Data Modeling.

<< 4.1 Defining a Data Source © 1996-2013 InetSoft Technology Corporation (v11.5) 4.2.1 Creating the Physical View >>