Tools → Business Schema Designer

About the Business Schema Designer

The Business Schema Designer allows you to create, edit, and delete runtime business views. There are three types of runtime business views for a business schema:

The Business Schema Designer allows you to manage all types of views. You need to have the suitable permissions and access rights to access the Business Schema Designer and manage runtime business views.

Starting with the 6.0 release, Incorta maintains business schema versions for better collaboration, business schema lifecycle management, and audit capabilities. Additionally, this release enhances the user interface (UI) and improves the look and feel to match other tools in Incorta.

Note

Starting this release, you can now add, edit, and delete business schemas when the Loader Service isn’t available or running.

Business Schema Designer permissions and access rights

A user that belongs to a group with the Schema Manager or the SuperRole role can access the Business Schema Designer. However, the user must own or have Edit access rights to a business schema to be able to use the Business Schema Designer to edit it.

Users with only the Analyze User or Individual Analyzer roles will have limited access to the Business Schema Designer where they can view folders and runtime business views in business schemas shared with them and explore their data without the need to be assigned the Schema Manager role. They can open a shared business schema in Business Schema Designer view mode only.

To access the Business Schema Designer for an existing business schema, you must first open the business schema from the Business Schema Manager:

  • In the Navigation bar, select Business Schema.
  • In the list view, select the business schema.
Note
  • Only the Super User tenant administrator or a user with the Schema Manager or SuperRole roles can create business schemas.
  • By default, a user can edit or delete business schemas that the user has Edit access rights to.
  • A user with the SuperRole role or the Super User can edit or delete any business schema regardless of the assigned access rights if the Enable Super User Mode option is enabled in the Cluster Management Console (CMC) → Tenant Configurations → Security.
  • A user with only the Analyze User or Individual Analyzer roles cannot create, edit, or delete a business schema even if the user is assigned Edit access rights to the business schema.
  • The Business Schema Designer opens by default in view mode.

Business Schema Designer modes

The Business Schema Designer supports two different modes: view mode and edit mode. The Business Schema Designer opens by default in view mode. When you create a new business schema using the Business Schema Manager, the Business Schema Designer automatically opens in edit mode.

View mode

The view mode is the default mode. In the view mode, you can perform the following actions according to the assigned access rights and roles:

  • Search the business schema for a folder, view, or column.
  • Explore the business schema data in the Analyzer.
  • Select to create a new folder or view, if applicable. This opens the Business Schema Designer in edit mode.
  • View the business schema summary.
  • Expand or collapse a folder or view.
  • View runtime business views in a folder.
  • View columns in a runtime business view.
  • Select to access the edit mode.
  • Select to access the Data Lineage Viewer to preview the list and diagram of dependent entities of a column or formula column in a runtime business view.
  • View, export, and restore the business schema versions

Starting with the 6.0, more options, which were available only through the Business Schema Manager, are available in the view mode of the Business Schema Designer. These options include:

  • Create a copy of the business schema.
  • Delete the business schema.
  • Export the business schema.
  • Edit the business schema information.
  • View and manage the business schema share options.

Edit mode

Important

By default, you can access the Business Schema Designer in edit mode only for Business Schemas that you own or have Edit access rights to. However, a user with only the Analyze User or Individual Analyzer roles cannot access a business schema in edit mode even if the user is assigned Edit access rights to the business schema.

Starting with the 6.0 release, when you create a new business schema, the Business Schema Designer opens in edit mode. When you open an existing business schema, it opens in view mode. To access the edit mode, in the Action bar, select Edit.

In the Business Schema Designer edit mode, you can perform the following actions:

  • Create a new folder.
  • Create a business schema view.
  • Create an Incorta Analyzer View.
  • Create an Incorta SQL View.
  • View the business schema description.
  • Save changes and exit the edit mode.
  • Cancel changes and exit the edit mode.
  • Expand or collapse a folder or view.
  • Edit a folder or view.
  • Delete a folder or a view.
  • Manage runtime business views in a folder.
  • Manage columns and formula columns in a runtime business view, as applicable.
  • Use the Data panel to add columns or formula columns to a business schema view.

If you try to exit the Business Schema Designer edit mode while there are unsaved changes, a warning message appears, allowing you to save these changes. You can save the changes to the current version of the business schema or discard them. Once you save or discard the changes, you are back to view mode.

Business Schema Designer versions

The Business Schema Designer tracks the version history of business schemas. With the proper access rights and permissions, you can restore or export prior business schema versions. Creating or importing a business schema creates the first version of it while the following actions create a new version of the business schema:

  • Adding, editing, or deleting one or more business schema views.
  • Changing the name of one or more business schema views.
  • Importing a business schema that overwrites the existing one.
  • Selecting the Save Changes option, whether you have made any changes or not.
  • Saving a listing table insight as a business view in an existing business schema.
  • Saving a listing table insight as a business view to a new business schema (creates two versions of the new business schema).
  • Restoring a version.

You can specify a name for each version instead of the version timestamp. You can restore any previous version. When you restore a previous version, you not only restore the objects and their states, but you also restore the description and assigned department defined in this version.

Note
  • The Maximum number of versions per entity setting in the Cluster Management Console (CMC) > Tenant Configurations / Default Tenant Configurations > Incorta Labs specifies how many versions to keep for each business schema. It is the same option that governs the number of versions to keep per dashboard or physical schema.
  • Once you name a version, you cannot save changes to it. Any further changes are added to a new version.
  • Restoring multiple versions within a short time interval won't create a new version each time; however, the definition of the latest restored version is applied.

Business Schema Designer anatomy

The Business Schema Designer consists of the following:

  • Action bar
  • Summary section
  • Canvas
  • Data panel
  • Manage Dataset panel

Action bar

The Action bar shows different options depending on the mode.

The following are the options available in the view mode:

  • Search: enter a search term to search for a runtime business view, folder, or column in the business schema. Select an item from the search list to expand the related runtime business view or folder in the Canvas.
  • Explore Data: select to access the Analyzer to explore the business schema data.
  • Edit: select to open the Business Schema Designer in edit mode.
  • More Options (⋮ vertical ellipsis): select to open the more options menu. Available options vary according to the access rights to the business schema.
    • Make a copy: select to create a copy of the current business schema.
    • Edit Information: select to edit the description and department.
    • Export: select to export the current business schema. This is the only option available when you have only view access rights to the business schema.
    • Delete: select to delete the current business schema.
    • Share: select to view and manage the share options of the current business schema. This option, in addition to the Export option, is available when you have only share access rights to the business schema.
    • Version History: select to view and manage the versions of the active business schema.

The following are the options available in the edit mode:

  • +New: select to open the Add New menu. The Add New menu options are:
    • Add New Folder: select to create a new folder in the business schema.
    • Add New View: select to create a business schema view, Incorta Analyzer View, or Incorta SQL View.
  • Save Changes: available when you add or edit a folder or a runtime business view. Select to save the changes you made and exit the Business Schema Designer edit mode.
  • Cancel: select to cancel the changes you made and exit the Business Schema Designer edit mode.

Summary section

The Summary section shows the name and description of the business schema, in addition to the number of folders and views in the Business Schema. Views in folders are not counted in the displayed number.

Canvas

The Canvas shows folders and views in a given business schema.

The Canvas contains the following:

  • Title bar: shows the name of the view or folder and number of items.
  • More Options (⋮ vertical ellipsis): select to open the More Options menu.
  • Folders and views tree.
  • For new views, the Canvas shows the Create In Analyzer and Create Via SQL options to add a new view to the folder using the Analyzer or the Query Editor respectively.
  • For new folders, the Canvas shows the Add View option to add a new view to the folder.

Title bar

The Title bar shows the name of the view or folder. In addition to the name, the Title bar shows the following:

  • For a folder, it shows the number of runtime business views in the folder.
  • For a runtime business view, it shows the number of columns and formula columns in the runtime business view. In the case that the business schema view has a base table, a B icon appears next to the number of columns. Hover over the B icon to view the selected base table.

You can use the Title bar to edit the folder or view name.

More Options menu

The More Options menu for folders and views contains different options.

  • The More Options menu for a folder shows the following options:
    • Edit: Opens the Business Schema Designer edit mode.
    • Empty Folder: Moves all runtime business views from the folder.
    • Add View: Adds a new view to the folder.
    • Delete Folder: select to delete the folder and all its runtime business views.
  • The More Options menu for a runtime business view shows the following options:
    • Edit: Opens the Business Schema Designer edit mode.
    • Edit View Info: Opens the Edit View Info dialog to edit the runtime business view name and description.
    • Create In Analyzer: Opens the Analyzer to create a new Incorta Analyzer View. Available for new views only.
    • Create Via SQL: Opens the Query Editor to create a new Incorta SQL View. Available for new views only.
    • Edit In Analyzer: Opens the Analyzer to edit the Incorta Analyzer View.
    • Edit Via SQL: Opens the Query Editor to edit the Incorta SQL View.
    • Move To Folder: Moves the runtime business view to a selected folder.
    • Move Out of Folder: Moves the runtime business view from a folder.
    • Clear All: Removes all columns in the runtime business view.
    • Set Base Table: Opens the Set Base Table to specify the base table for the business schema view.
    • Change Base Table: Opens Change Base Table to specify another base table for the business schema view.
    • Remove Base Table: Removes the base table specified for the business schema view.
    • Delete: Deletes the runtime business view.

Folders and views tree

The Canvas shows the business schema folders and views as a tree that represents a hierarchy:

–– Folder (if any)

–––– Runtime business view

–––––– Column

You can expand or collapse each folder or view: select > (caret or chevron right icon) or the V (caret or chevron down icon) respectively.

The tree shows the following details for an expanded runtime business view:

  • For a column in a business schema view, it shows the Name, Label, Description, and fully qualified name of the Source Column.
  • For a formula column in a business schema view, it shows the Name, Label, Description, Function, and Formula.
  • For a column in an Incorta Analyzer View or Incorta SQL View, it shows the Name, Label, Data Type, and Function.

You can also preview a list and diagram of dependent entities of columns or formula columns in a runtime business view

When you expand a folder or view while in edit mode, you can perform different actions:

  • When you expand a folder in the tree, you can:
    • Create a runtime business view in the folder.
    • Order runtime business views in the folder.
    • Drag and drop a runtime business view to or from the folder.
  • When you expand a business schema view in the tree, you can:
    • Add columns from the Data panel to the expanded business schema view.
    • Add formulas from the Data panel to the expanded business schema view.
    • Edit column properties:
      • Name
      • Label
      • Description
    • Edit formula column properties:
      • Name
      • Label
      • Description
      • Function
      • Set Formula or Change Formula
    • View column details and sample data for a column in a business schema view.
    • Order columns and formula columns in the business schema view.
    • Delete a column or formula column from a business schema view.
    • Preview dependent entities of columns or formula columns.

Data panel

The Data panel is available in the Business Schema Designer edit mode only. It shows columns in selected physical schema tables to use for business schema views. The Tree in the Data panel represents a hierarchy:

–– Physical schema

–––– Table

–––––– Column

In the Tree, an icon exists next to the column name to indicate the column function.

  • A key icon indicates a key column.
  • The letter A indicates a dimension column.
  • A # symbol indicates a measure column.
  • A clock icon indicates a date/time column regardless of the column function.

Use the Data panel to:

  • Expand all in tree or collapse all in tree.
  • Search for specific tables or columns in one or more schemas.
  • Open the Manage Dataset panel (select Manage Dataset).
  • Collapse and expand the tree of columns.
  • View the details of a column.
  • Preview the data for a column.
  • Add a formula to a business schema view (drag and drop to the view canvas).
  • Add a column to a business schema view (drag and drop to the view canvas).

Manage Dataset panel

Use the Manage Dataset panel to select an entire schema, select a table, or search for a specific table. The Search in the Manage Dataset panel does not support finding specific columns.

Here are some of the options available in the Manage Dataset panel:

  • Select tables or schemas.
  • Search for a table.
  • Tree to select schemas and tables.

Business Schema Designer actions for a business schema

With the Business Schema Designer, you can perform the following actions for a business schema:

You can perform the following actions using the Business Schema Designer view mode:

Explore the business schema data

  • In Business Schema Designer view mode, in the Action bar, select Explore Data.
  • Use the Analyzer to do one of the following according to the assigned access rights and roles:
    • Create an insight referencing columns or formula columns in runtime business views in the business schema and other shared business schemas, in addition to objects in shared physical schemas.
    • Create and save a business schema view (that references columns and formula columns in shared physical schemas) in the current business schema or other shared business schemas (requires the Schema Manager role).

For more information about how to use the Analyzer to create insights or business schema views, refer to Tools → Analyzer.

Edit the business schema

  • In the Action bar, select Edit.
  • Use the Business Schema Designer in edit mode to add or edit runtime business views and folders in the business schema.
  • In the Action bar, select Save Changes.

For more information about the actions that you can perform for a folder, see Business Schema Designer actions for folders.

For more information about the actions you can perform for a runtime business view, see Business Schema Designer actions for runtime business views.

Copy the business schema

  • In the Action bar, select More Options (⋮ vertical ellipsis), and then select Make a copy.
  • In the Make a copy dialog, update the name and other information of the new business schema as required.
  • Select Save.
Important

Validation Rules for a business schema name A business schema name…

  • Must be unique.
  • Must be between 1 and 250 characters in length.
  • Must begin with an alpha character, lower or upper case.
  • After the first alpha character, can contain zero or more alphanumeric characters in lower, upper, or mixed case.
  • After the first alpha character, can contain zero or more underscore (_) or Dollar sign ($) characters.
  • Besides underscore (_) and Dollar sign ($), cannot contain special characters, symbols, or spaces.

Edit the business schema information

  • In the Action bar, select More Options (⋮ vertical ellipsis), and then select Edit Information.
  • In the Edit Information dialog, update the description and department of the business schema as required. You can enter up to 500 alphanumeric characters, including spaces and special characters.
  • Select Save.

Share the business schema

  • In the Action bar, select More Options (⋮ vertical ellipsis), and then select Share.
  • In the Share dialog, you can do the following:
    • Remove an existing user or group.
    • Modify the existing access rights for a user or group.
    • Add a new user or group with the access rights.

Export the business schema

  • In the Action bar, select More Options (⋮ vertical ellipsis).
  • Select Export. The exported business schema .zip file is downloaded to your default Downloads folder.

Delete the business schema

  • In the Action bar, select More Options (⋮ vertical ellipsis), and then select Delete.
  • In the dialog, select Delete.

Business Schema Designer actions for runtime business views

With the Business Schema Designer, you can perform the following actions for runtime business views:

Important

Validation Rules for a runtime business view name

A runtime business view name…

  • Must be unique at the business schema level: no 2 views or more can share the same name; however, a view and a folder can share the same name in the business schema.
  • Must be at least 1 character in length.
  • Must begin with an alpha character, lower or upper case.
  • After the first alpha character, can contain zero or more alphanumeric characters in lower, upper, or mixed case.
  • After the first alpha character, can contain zero or more underscore (_) or Dollar sign ($) characters.
  • Besides underscore (_) and Dollar sign ($), cannot contain special characters, symbols, or spaces.

Create a new business schema view

  • If this is the first view in the business schema, in the Canvas, select Add New View, or in the Action bar, select +NewAdd New View. To create a new business schema view in an existing business schema, in the Action bar, select Edit, and then select +NewAdd New View.
  • In the Business Schema Designer, in the Canvas, do the following:
    • Drag and drop columns from the Data panel to the business schema view, and for each column, specify the column properties as required. For more information, review Concepts → Business Schema View Column.
    • Drag and drop a formula from the Data panel to the business schema view canvas, select the function of the formula column (Dimension or Measure), select Set Formula, and use the Formula Builder to create the formula column. For more information, review Concepts → Business Schema View Formula Column.
    • Hover over a given column or formula column, and then select Delete (trash can icon) to remove it from the business schema view. You can also select one or more columns, and then in the view's title bar, select Delete (trash can icon).
    • Select the view name, edit it, and then select any other place in the Business Schema Designer.
  • In the Action bar, select Save Changes.

Create a new Incorta Analyzer View

  • If this is the first view in the business schema, in the Canvas, select Add New View, or in the Action bar, select +NewAdd New View. To create a new business schema view in an existing business schema, in the Action bar, select Edit, and then select +NewAdd New View.
  • In the Business Schema Designer, in the Canvas, select Create In Analyzer.
  • Use the Analyzer to create and save the new Incorta Analyzer View. For more information about how to use the Analyzer to create an Incorta Analyzer View, review Tools → Analyzer.
  • Select the view name, edit it, and then select any other place in the Business Schema Designer.
  • In the Action bar, select Save Changes.

Create a new Incorta SQL View

  • If this is the first view in the business schema, in the Canvas, select Add New View, or in the Action bar, select +NewAdd New View. To create a new business schema view in an existing business schema, in the Action bar, select Edit, and then select +NewAdd New View.
  • In the Business Schema Designer, in the Canvas, select Create Via SQL.
  • Use the SQL Editor to create and save the new Incorta SQL view.
  • Select Format to format the query, and then select Execute to preview the output.
  • In the Action bar, select Save Changes.
Note

You can test a portion of the query of Incorta SQL views. Select the portion you want, and then select Execute. However, the Business Schema Designer uses the whole script to create the view.

Edit a business schema view

  • In the Action bar, select Edit.
  • In the Canvas, expand the business schema view and make the necessary changes:
    • To add a new column, drag and drop a column from the Data panel to the business schema view. For more information, review Concepts → Business Schema View Column.
    • To add a formula column, drag and drop a formula from the Data panel to the business schema view, select Set Formula, and use the Formula Builder to create the formula column. For more information, review Concepts → Business Schema View Formula Column.
    • To edit the properties of a column or formula, change the name, label, and/or description of the column or formula.
    • To change the formula of a formula column, select Change Formula, and use the Formula Builder to update the formula column. For more information, review Concepts → Business Schema View Formula Column.
    • To change the function of a formula column, for Source Column/Formula, select Dimension or Measure.
    • To order columns or formula columns in the business schema view, drag and drop a given column or formula column to the place you want in the business schema view.
    • To remove a given column or formula column from the business schema view, hover over the row, and then select Delete (trash can icon).
    • To remove one or more columns or formula columns from the business schema view, select them, and then in the view's title bar, select Delete (trash can icon).
  • In the Action bar, select Save Changes.

Edit an Incorta Analyzer View

You can edit an Incorta Analyzer View only in the Analyzer.

  • In the Action bar, select Edit.
  • In the Canvas, for a given Incorta Analyzer View, select More Options (⋮ vertical ellipsis).
  • Select Edit In Analyzer.
  • In the Analyzer, make the required changes, and then select Save.
  • In the Action bar, select Save Changes.

Edit an Incorta SQL View

You can edit an Incorta SQL View only in the SQL editor.

  • In the Action bar, select Edit.
  • In the Canvas, for a given Incorta SQL View, select More Options (⋮ vertical ellipsis).
  • Select Edit Via SQL.
  • In the SQL editor, make the required changes, and then select Done.
  • In the Action bar, select Save Changes.

Rename a runtime business view

  • In the Action bar, select Edit.
  • In the Canvas, for a given view, in the title bar, select the view name, and edit it.
  • Select any other place in the Business Schema Designer.
  • In the Action bar, select Save Changes.

You can also change the name when editing the runtime business view info.

Edit runtime business view info

  • In the Action bar, select Edit.
  • In the Canvas, for a given view, select More Options (⋮ vertical ellipsis).
  • Select Edit View Info.
  • In the dialog, change the name of the view as required, optionally add a description, and then select Save.
  • In the Action bar, select Save Changes.

Move a runtime business view to a folder

  • In the Action bar, select Edit.
  • In the Canvas, for a given view, do one of the following:
    • Select More Options (⋮ vertical ellipsis), select Move To Folder, and then select the folder you want to move the view to.
    • Expand the folder you want to move the view to, and then drag and drop the view to this folder.
  • In the Action bar, select Save Changes.

Move a runtime business view out of a folder

  • In the Action bar, select Edit.
  • In the Canvas, for a given view that exists in a folder, do one of the following:
    • Select More Options (⋮ vertical ellipsis), and then select Move Out of Folder.
    • Drag and drop the view out of the folder to the root list or to another expanded folder.
  • In the Action bar, select Save Changes.

Remove all columns from a business schema view

  • In the Action bar, select Edit.
  • In the Canvas, for a given view, select More Options (⋮ vertical ellipsis).
  • Select Clear All.
  • In the dialog, select Remove/Clear.
  • In the Action bar, select Save Changes.

Remove a column from a business schema view

  • In the Action bar, select Edit.
  • In the Canvas, expand a given business schema view.
  • For a given column or formula column in the business schema view, hover over the row, and then select Delete (trash can icon).
  • In the Action bar, select Save Changes.

Remove one or more columns from a business schema view

  • In the Action bar, select Edit.
  • In the Canvas, expand a given business schema view.
  • Select the columns and formula columns in the business schema view that you want to remove,
  • In the view's title bar, select Delete (trash can icon).
  • In the Action bar, select Save Changes.

View details and sample data of a column in a runtime business view

You can view the details and sample data of a column in a runtime business view in both view and edit modes.

  • In the Canvas, expand a given business schema view.
  • For a given column in the business schema view, hover over the row, and then select View Details (eye icon).
  • Review the column details and sample data.

Preview column dependencies

You can preview the dependent entities of a column or formula column in a runtime business view in both view and edit modes.

  • In the Business Schema Designer, expand the business view you want.
  • In the columns section, hover over the column you want to preview its dependent entities, and then select the DNA icon.
  • Use the Data Lineage Viewer to review the list and diagram of dependent entities.
  • Optionally, select the download icon to save the dependency list to a CSV file.

Set the base table for a business schema view

You can use the Business Schema Designer to set the base table for a business schema view only. This will enable a default query path for attribute-only queries, where one of the attributes is from the current business schema view.

Here are the steps to set the base table for a business schema view:

  • In the Action bar, select Edit.
  • In the Canvas, for a given business schema view, select More Options (⋮ vertical ellipsis).
  • Select Set Base Table.
  • In the Set Base Table dialog, in Schema, select the physical schema that contains the table that you want.
  • In Base Table, select the base table that you want.
  • Select Set.
  • In the Action bar, select Save Changes.
Note

To set the base table for an Incorta Analyzer View, in the Analyzer, for the measure you want, drag a column from the Base Table to the Measures tray → pill properties panel → AdvancedBase Field.

Recommendation

In the case of using a base table other than a physical schema table, load the object data after defining the base table for the business schema view.

Change the base table for a business schema view

  • In the Action bar, select Edit.
  • In the Canvas, for a given business schema view that has a base table, select More Options (⋮ vertical ellipsis).
  • Select Change Base Table.
  • In the Change Base Table dialog, in Schema, select the physical schema that contains the table that you want.
  • In Base Table, select the base table that you want.
  • Select Change.
  • In the Action bar, select Save Changes.

Remove the base table for a business schema view

  • In the Action bar, select Edit.
  • In the Canvas, for a given business schema view that has a base table, select More Options (⋮ vertical ellipsis).
  • Select Remove Base Table.
  • In the dialog, select Remove Anyways/Remove Base Table.
  • In the Action bar, select Save Changes.

Delete a runtime business view

  • In the Action bar, select Edit.
  • In the Canvas, for a given view, select More Options (⋮ vertical ellipsis).
  • Select Delete.
  • In the dialog, select Delete.
  • In the Action bar, select Save Changes.

Business Schema Designer actions for folders

With the Business Schema Designer, you can perform the following actions for folders:

Important

Validation Rules for a folder name

A folder name…

  • Must be unique at the business schema level: no 2 folders or more can share the same name; however, a view and a folder can share the same name in the business schema
  • Must be at least 1 character in length.
  • Must begin with an alpha character, lower or upper case.
  • After the first alpha character, can contain zero or more alphanumeric characters in lower, upper, or mixed case.
  • After the first alpha character, can contain zero or more underscore (_) or Dollar sign ($) characters.
  • Besides underscore (_) and Dollar sign ($), cannot contain special characters, symbols, or spaces.

Create a new folder

  • If the business schema doesn't have any views or folders, in the Canvas, select Add New Folder, or select +NewAdd New Folder. To create a new folder in an existing business schema, in the Action bar, select Edit, and then select +NewAdd New Folder.
  • Make any required changes, and then in the Action bar, select Save Changes.

Edit a folder

  • In the Action bar, select Edit.
  • In the Canvas, expand the folder, and make the necessary changes, for example,
    • To add a new view, in the Title bar, select +.
    • To order views in the folder, drag and drop the view to the place you want.
    • To move a view to the folder, drag and drop the view to the folder.
    • To move a view from the folder, drag and drop the view out of the folder.
  • In the Action bar, select Save Changes.

Create a runtime business view in a folder

  • In the Business Schema Designer, in the Action bar, select Edit.
  • In the Canvas, for a given folder, select More Options (⋮ vertical ellipsis), and then select Add View.
  • Do one of the following:
    • Drag and drop columns from the Data panel to the new view to create a business schema view.
    • Select Create In Analyzer to create a new Incorta Analyzer View.
    • Select Create Via SQL to create a new Incorta SQL View.
  • In the Action bar, select Save Changes.

Rename a folder

  • In the Action bar, select Edit.
  • In the Canvas, for a given folder, select the folder name, and edit it as necessary.
  • Select any other place in the Business Schema Designer.
  • In the Action bar, select Save Changes.

Empty a folder

When you empty a given folder, all its runtime business views are moved to the Business Schema root list.

  • In the Action bar, select Edit.
  • In the Canvas, for a given folder, select More Options (⋮ vertical ellipsis).
  • Select Empty/Empty Folder.
  • In the Action bar, select Save Changes.

Delete a folder

When you delete a folder, all runtime business views in this folder are deleted as well.

  • In the Action bar, select Edit.
  • In the Canvas, for a given folder, select More Options (⋮ vertical ellipsis).
  • Select Delete/Delete Folder.
  • In the dialog, select Delete.
  • In the Action bar, select Save Changes.

Business Schema Designer actions for a version

You can use the Business Schema Designer to perform the following actions for business schema versions:

Search or filter the version history

  • In Business Schema Designer view mode, in the Action bar, select More Options (⋮ vertical ellipsis), and then select Version History.
  • In the Version history drawer, specify the filter criteria as required:
    • For Version Date, select a period to search for versions created or restored within this period. You can select a predefined period, such as Yesterday and Last 7 days (including today), or select custom, and then specify the period’s start and end dates.
    • For Modified By, the name of the user who created the version you search for.
    • Enable the Only Show Named Versions toggle to show only named versions.
  • The Saved Versions tab shows the versions that match the filter options you specified.

Name a version

  • In Business Schema Designer view mode, in the Action bar, select More Options (⋮ vertical ellipsis), and then select Version History.
  • In the Version history drawer, optionally, search for the version you want.
  • For a given version, select the version name (by default, the version creation or restore time is the version name).
  • Specify a new name for the version, and then press ENTER or select any other place in the drawer or the Business Schema Designer.
Note

A version name can have alphanumeric or special characters. The length of a version name cannot exceed 50 characters including spaces. You can't add additional changes to a version after you name it; a new version is created when you try to save further changes.

Export a version

  • In Business Schema Designer view mode, in the Action bar, select More Options (⋮ vertical ellipsis), and then select Version History.
  • In the Version history drawer, optionally, search for the version you want.
  • For a given version, select More Options (⋮ vertical ellipsis) → Export. The exported business schema .zip file is saved to the Downloads folder.

Restore a version

When you restore a version of a business schema, a copy of this version becomes the current version. The default name of the copied version is its restore (creation) time. The original version remains as is with its name and creation date. When you restore a previous version, you not only restore the objects and their states, but you also restore the description and assigned department defined in this version.

Here are the steps to restore a version of a business schema:

  • In Business Schema Designer view mode, in the Action bar, select More Options (⋮ vertical ellipsis), and then select Version History.
  • In the Version history drawer, optionally, search for the version you want.
  • For a given version, select More Options (⋮ vertical ellipsis) → Restore.