Datamart Tables Structure & Purpose (Insights Dashboards)

This page explains how the accelerator's Datamart Tables are structured, why each table exists, and how data flows from the configured transaction source into dashboard-facing model tables.

Table	Table Type	Description
`Configurations`	Parameter Table	Runtime control table for model settings.
`Transaction Data`	Model Table	Normalized base table copied from the configured source datamart.
`Customer Rank`	Model Table	Enrichment table.
`Product Rank`	Model Table	Enrichment table.
`Customer L12M Trend`	Model Table	Enrichment table.
`Cross Sell Rolling Period`	Model Table	Serving tables used by dashboards and evaluation logic.
`Customer Rolling Period`	Model Table	Serving tables used by dashboards and evaluation logic.
`Customer Product Rolling Period`	Model Table	Serving tables used by dashboards and evaluation logic.
`Aggregated Transactions`	Model Table	Serving tables used by dashboards and evaluation logic.

Full Datamart Tables Pipeline

Dashboard Consumption View

This view hides most implementation details and shows which tables matter to dashboard queries and configurator inputs.

Datamart Tables Reference

Label	Name	Typical Grain	Primary Purpose	Produced By	Main Consumers
Configurations	`Configurations`	One row per configuration key	Stores model and tab settings as JSON for runtime lookup	`ID_Model_Configuration_Calculation` element `ConfigurationTable`	`ModelConfigurationProviderUtils`, `ConfigurationUtils`, `ConfigManager`, dashboard configurators and calculation logic via configuration utilities
Transaction Data	`TransactionData`	Normalized transaction-level copy from configured source	Creates a model-owned source table with selected transaction, hierarchy, filter, and waterfall fields	`ID_Model_Data_Calculation` elements `SourceTable` and `SourceTableDataLoad`	`SourceTableRollingPeriodFilter`, `CustomerRankTableDataLoad`, `ProductRankTableDataLoad`, `CustomerL12MTrendTableDataLoad`, all serving-table aggregations
Customer Rank	`CustomerRank`	Customer	Assigns revenue-based customer rank used by downstream analytics	`ID_Model_Data_Calculation` elements `CustomerRankTable` and `CustomerRankTableDataLoad`	`CustomerRollingPeriodAggregation`, `CustomerProductRollingPeriodAggregation`, `CrossSellRollingPeriodAggregation`, `AggregatedTransactionsAggregation`
Product Rank	`ProductRank`	Product	Assigns revenue-based product rank used by downstream analytics	`ID_Model_Data_Calculation` elements `ProductRankTable` and `ProductRankTableDataLoad`	`CustomerProductRollingPeriodAggregation`, `CrossSellRollingPeriodAggregation`, `AggregatedTransactionsAggregation`
Customer L12M Trend	`CustomerL12MTrend`	Customer	Precomputes trailing 12-month revenue, profit, and quantity trends	`ID_Model_Data_Calculation` elements `CustomerL12MTrendTable` and `CustomerL12MTrendTableDataLoad`	`CustomerRollingPeriodAggregation`
Cross Sell Rolling Period	`CrossSellRollingPeriod`	Customer-product	Stores cross-sell analytics at customer-product level	`ID_Model_Data_Calculation` element `CrossSellRollingPeriodAggregation`	`ID_Model_Data_Evaluation`; currently not a primary direct dashboard query source
Customer Rolling Period	`CustomerRollingPeriod`	Customer	Stores customer-level KPIs such as health score and trend summaries	`ID_Model_Data_Calculation` element `CustomerRollingPeriodAggregation`	Customer Trends dashboard queries, embedded-table queries, `ID_Model_Data_Evaluation`
Customer Product Rolling Period	`CustomerProductRollingPeriod`	Customer-product	Stores customer-product KPIs such as opportunities, cross-sell, price realization, and margin	`ID_Model_Data_Calculation` element `CustomerProductRollingPeriodAggregation`	Customer Trends, Customers Overview, Customer Performance, embedded tables, `ID_Model_Data_Evaluation`
Aggregated Transactions	`AggregatedTransactions`	Customer-product-month	Stores dashboard-oriented monthly aggregation with customer and product enrichment	`ID_Model_Data_Calculation` element `AggregatedTransactionsAggregation`	All dashboard families, hierarchy selectors, general filters, `ID_Model_Data_Evaluation`

See Also