View Issue Details

IDProjectCategoryView StatusLast Update
0005460CaseTalk ModelerUser Interfacepublic2026-06-06 16:42
ReporterMarco Wobben Assigned To 
PrioritynormalSeverityfeatureReproducibilityhave not tried
Status acknowledgedResolutionopen 
Target Version15.x 
Summary0005460: Selecting OTFTs in diagram: pre-populate roles when adding BTX type
Description

BTX object-fact types (Business Transaction types) now support dimensional modeling metadata directly in the Role Editor.

When editing a BTX type, the root role offers:

  • Operations: the standard Create, Read, Update, Delete checkboxes, plus the ability to add custom operations such as Export, Print, or any domain-specific action.
  • Report use: indicates whether this fact type maps to a Fact table, Aggregate view, or Snapshot in the data warehouse.

For each non-root role (the participating concepts), dimensional properties can be set:

  • Role type: Dimension, Degenerate dimension, Measure, or Exclude — controls how the role contributes to the star schema.
  • Aggregation function: SUM, AVG, COUNT, MIN, MAX, or COUNT DISTINCT — applicable when the role type is Measure.
  • Lookup dimension table: the name of an existing dimension table to reference for conformed dimensions.
  • Change handling: Slowly Changing Dimension type (Type 1 overwrite, Type 2 history, Type 3 previous-value column).
  • Is Date Dimension: marks the role as the time axis of the fact table.

This allows a single BTX fact type to describe both its operational behavior (CRUD, custom actions) and its analytical structure (star schema layout, SCD policy, aggregation rules) without requiring separate documentation.

TagsNo tags attached.
CaseTalk EditionCorporate

Activities

Marco Wobben

Marco Wobben

2026-03-21 13:24

administrator   ~0005854

Structure for both API, Hierarchical Stores, Aggregates and Dimensional Modeling

image.png (70,176 bytes)   
image.png (70,176 bytes)   
Marco Wobben

Marco Wobben

2026-03-23 09:03

administrator   ~0005864

Test note - please ignore

Issue History

Date Modified Username Field Change
2026-03-21 12:47 Marco Wobben New Issue
2026-03-21 13:24 Marco Wobben Note Added: 0005854
2026-03-21 13:24 Marco Wobben File Added: image.png
2026-03-21 22:08 Marco Wobben Description Updated
2026-03-23 09:00 Marco Wobben Status new => acknowledged
2026-03-23 09:03 Marco Wobben Note Added: 0005864
2026-04-26 14:07 Marco Wobben Target Version => 15.0
2026-06-06 16:42 Marco Wobben Target Version 15.0 => 15.x