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
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_Table.Column
  • Physcial_Schema.Incorta_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

© Incorta, Inc. All Rights Reserved.