Fact

Overview

A fact on the dataflow diagram represents measurable business events, balances, or transactions prepared for analytical use. It shows how the fact receives data and how it connects to related dimensions and downstream objects.

Function

A fact appears as a STAR.FACT_* object in the Datamart layer. Its incoming relationships identify the dimensions and upstream objects that contribute to the analytical fact structure.

Context Menu

Right-click the fact rectangle to open its complete context menu. The Fact and Transformation context-menu structures use the same command pattern in the reviewed product version; the descriptions below are written specifically for the selected fact.

Access

Facts are available on the dataflow diagram as Datamart objects. A fact can be opened by double-clicking its rectangle or managed from the object context menu.

How to access

Navigation tree

Use the navigation tree to locate the related fact object outside the diagram.

Toolbar

Fact objects are not opened directly from a dedicated Dataflow Diagram toolbar command.

Diagram

Double-click the fact rectangle to open it, or right-click the rectangle to open the context menu.

Visual element

STAR.FACT_* object in the Datamart layer with incoming analytical relationships.

Screen overview

T STAR.Fact_Orders

Context Menu

ID Command Description
1 Locate in tree Locates the selected fact in the navigation tree.
2 Set filter Sets the selected fact as the current filter for the dataflow diagram.
3 Add to filter Adds the selected fact to the current diagram filter.
4 Refresh Refreshes the selected fact in the dataflow diagram.
5 Add Opens the submenu containing the available options for adding a related object.
6 Duplicate Duplicates the selected fact.
7 Delete Deletes the selected fact.
8 References Opens the submenu containing reference-related options for the selected fact.
9 Locks Opens the submenu containing lock-related options for the selected fact.
10 Object groups Opens options for managing the object groups associated with the selected fact.
11 Import/Export object definition Opens the submenu for exporting the selected fact definition.
12 Customize colors Opens the submenu for customizing the display colors of the selected fact.

Sub menus

ID Submenu group Description
A Add Contains the available options for adding an object related to the selected fact.
B References Contains options for viewing or managing references associated with the selected fact.
C Locks Contains lock-related options for the selected fact.
D Import/Export object definition Contains options for exporting the definition of the selected fact.
E Customize colors Contains options for customizing the colors used to display the selected fact.

A) Add Submenu

ID Command Description
1 Data source Opens options for adding a data source.
2 Import Opens options for adding an import object.
3 Historization Opens options for adding a historization object.
4 Persisting Opens options for adding a persisting object.
5 Transformation Opens options for adding a transformation object.
6 Export Opens options for adding an export object.
7 Data vault hub Opens options for adding a Data vault hub.
8 Data vault satellite Opens options for adding a Data vault satellite.
9 Data vault link Opens options for adding a Data vault link.
10 Calendar dimension Opens options for adding a calendar dimension.
11 Time dimension Opens options for adding a time dimension.
12 Snapshot dimension Opens options for adding a snapshot dimension.

B) References Submenu

ID Command Description
1 Show reference diagram (active) Shows active reference diagrams associated with the selected fact.
2 Show reference diagram (inactive) Shows inactive reference diagrams associated with the selected fact.
3 Show reference diagram (all) Shows all reference diagrams associated with the selected fact.
4 List references Lists references associated with the selected fact.
5 Add reference Adds a reference to the selected fact.
6 Start reference Starts creating a reference from the selected fact.

C) Locks Submenu

ID Command Description
1 Lock object Locks the selected fact.

D) Import/Export object definition Submenu

ID Command Description
1 Export to file Exports the selected fact definition to a file.
2 Export to cloud Exports the selected fact definition to the cloud.

E) Customize colors Submenu

ID Command Description
1 Background Color Changes the background color of the selected fact.
2 Foreground Color Changes the foreground color of the selected fact.

Related topics