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
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. |
