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:

PropertyControlDescriptionConfiguration
Nametext boxEnter 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
Labeltext boxEnter a user friendly nameutf-8 md valid characters, including emoji 😀
Typeread onlyAvailable starting with 2023.7.0.
The data type of the source column.
Descriptiontext boxEnter additional information for the column, observable in the column details of the Analyzer.utf-8 md valid characters, including emoji 😀
Source Column/Formula*text boxThe fully qualified name of the source column.Read-only
Note

Formula is a property of a Business Schema View Formula Column.

Column data lineage

Starting with 2023.7.0, you can view the data lineage of columns and formula columns in runtime business views in the Data Lineage Viewer v2 that displays a diagram with the entities referenced in the column (upstream lineage) and entities where the column is referenced (downstream lineage).

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