Concepts → Business Schema View Column
About a business schema view column
A business schema view column is a data-backed column from a physical schema table. Typically, a business schema view column contributes to a semantic layer in the logical runtime business view by defining standardized business terminology for the organization.
A business schema view column has specific properties:
Property | Control | Description | Configuration |
---|---|---|---|
Name | text box | Enter the column’s name; used in the fully qualified name of the column. | Valid characters: A-Z, a-z, 0-9, $, _ Name must begin with a letter character |
Label | text box | Enter a user friendly name | utf-8 md valid characters, including emoji 😀 |
Description | text box | Enter additional information for the column, observable in the column details of the Analyzer. | utf-8 md valid characters, including emoji 😀 |
Source Column/Formula* | text box | The fully qualified name of the source column in a physical schema table. | Read-only |
Formula is a property of a Business Schema View Formula Column.
Source column property
The Source Column property identifies the referenced source physical schema column.
A referenced column has a fully qualified name. Here are examples of possible referenceable columns in a business schema view column:
- Physical_Schema.Table.Column
- Physical_Schema.Table.Formula_Column
- Physical_Schema.Incorta_Analyzer_Table.Column
- Physical_Schema.Incorta_Analyzer_Table.Formula_Column
Column function and type
The source column in the physical schema table determines the Incorta Function (Key, Measure, or Dimension) for a business schema view column. Similarly, the source column in the physical schema table defines the Incorta Data Type.
In order to change the Incorta Function or Incorta Data Type, consider using a Business Schema View Formula Column.
Business schema view columns in the Analyzer
When using the Analyzer, you can select and inspect business view columns in the Data panel. For a given column, select the Information icon in the right gutter. The Information dialog shows the:
- Column Name
- Source Column/Formula
- Data Type
- Function
- Description
- Sample Data