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 😀
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 in a physical schema table.Read-only
Note

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:

  • Physcial_Schema.Table.Column
  • Physcial_Schema.Table.Formula_Column
  • Physcial_Schema.Incorta_Analyzer_Table.Column
  • Physcial_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