Revenue and Profit Logics
ID_Dashboard_RevenueAndProfit
The core logic for the Revenue And Profit dashboard which defines dashboard's queries and portlets. The purpose of this logic is to provide data queries and render portlets.
Empty elements are separators with the following naming pattern: ___SOME_NAME___.
Element Description
ID_Dashboard_RevenueAndProfit Element Description
|
Element |
Description |
|
|
Separator element. |
|
|
Loads shared configuration constants (labels, keys, structural settings) used by the logic. |
|
|
Separator element. |
|
|
Initializes config manager for model utils. |
|
|
Initializes the Cache Manager for caching query results. |
|
|
Initializes the Warning Manager which handles most of the exceptions thrown. |
|
|
Separator element. |
|
|
Provides shared methods for query and portlets elements. |
|
|
Separator element. |
|
|
Generates Inputs as defined by the Configuration. |
|
|
Standard Abort Input Generation element. |
|
|
Separator element. |
|
|
Retrieves the product color-by field from the configurator inputs, used to assign colors to product categories in charts. Default configuration sets Color Product By to the first level of the product hierarchy. When this is the same as Product Category, the corresponding chart uses a single color for all points. |
|
|
Retrieves the customer color-by field from the configurator inputs, used to assign colors to customer categories in charts. Default configuration sets Color Customer By to the first level of the customer hierarchy. When this is the same as Customer Category, the corresponding chart uses a single color for all points. |
|
|
Queries the Aggregated Transactions DMT for total metrics with the selected filters. |
|
|
Queries the Aggregated Transactions DMT aggregated by month with the selected filters. |
|
|
Queries the Aggregated Transactions DMT aggregated by product category with the selected filters. |
|
|
Queries the Aggregated Transactions DMT aggregated by customer category with the selected filters. |
|
|
Queries the Aggregated Transactions DMT aggregated by product rank with the selected filters. |
|
|
Queries the Aggregated Transactions DMT aggregated by customer rank with the selected filters. |
|
|
Separator element. |
|
|
Renders a Summary Table portlet displaying total metrics. |
|
|
Renders a column and spline type chart displaying changes to revenue and margin % over the selected time period. |
|
|
Renders a scatter type chart displaying Revenue and Margin % for each product category. |
|
|
Renders a scatter type chart displaying Revenue and Margin % for each customer category. |
|
|
Renders a column type chart displaying product count for each product rank. |
|
|
Renders a column type chart displaying customer count for each customer rank. |
|
|
Renders waterfall type chart with drilldown displaying price components information. |
|
|
Separator element. |
|
|
Displays a portlet with link to the model object that is used to query the data shown in this dashboard. |
ID_Dashboard_RevenueAndMargin_Configurator
The configurator logic for the Revenue And Profit dashboard which defines its inputs. The purpose of this logic is to generate inputs for the dashboard.
The empty elements are separators with the following name pattern: ___SOME_NAME___.
Element Description
ID_Dashboard_RevenueAndMargin_Configurator Element Description
|
Element |
Description |
|
|
Separator element. |
|
|
Initializes config manager for model utils. |
|
|
Separator element. |
|
|
Creates a Customers picker input used to filter the Revenue and Profit dashboard by selected customer(s). |
|
|
Creates a Products picker input used to filter the Revenue and Profit dashboard by selected product(s). |
|
|
Creates a Review Period input for selecting the review period (date range) for the dashboard. |
|
|
Creates a General Filter input providing additional common filters for customers, products and other dimensions. |
|
|
Separator element. |
|
|
Creates a Time Period input defining the time aggregation (for example, month) used in time-based charts and tables. |
|
|
Creates a Customer Category input used to filter or group results by customer category. |
|
|
Creates a Customer Color By input defining which customer attribute is used to color customers in relevant charts. Default configuration sets Color Customer By to the first level of the customer hierarchy. When this is the same as Customer Category, the corresponding chart uses a single color for all points. |
|
|
Creates a Product Category input used to filter or group results by product category. |
|
|
Creates a Product Color By input defining which product attribute is used to color products in relevant charts. Default configuration sets Color Product By to the first level of the product hierarchy. When this is the same as Product Category, the corresponding chart uses a single color for all points. |
|
|
Creates a Revenue Axis Scale input allowing configuration of the revenue axis scaling (for example linear vs. logarithmic or range presets) in Revenue and Profit charts. |
|
|
Defines the “More Options” collapsible container grouping advanced inputs such as Time Period, category and color-by options, and axis scale. |
Customers Overview Logics
The core logic for the Customers Overview dashboard which defines dashboard's queries and portlets. The purpose of this logic is to provide data queries and render portlets.
The empty elements are separators with the following name pattern: ___SOME_NAME___.
ID_Dashboard_CustomersOverview
Element Description
ID_Dashboard_CustomersOverview Element Description
|
Element |
Description |
|
|
Separator element. |
|
|
Loads shared configuration constants (labels, keys, structural settings) used by the logic. |
|
|
Separator element. |
|
|
Initializes the Warning Manager that handles most of the exceptions thrown. |
|
|
Initializes the config manager for model utils. |
|
|
Initializes the Cache Manager for caching query results. |
|
|
Separator element. |
|
|
Provides shared methods for query and portlets elements. |
|
|
Separator element |
|
|
Generates Inputs as defined by the Configuration. |
|
|
Standard Abort Input Generation element. |
|
|
Separator element. |
|
|
Queries the Customer Product Rolling Period DMT with the selected filters. |
|
|
Separator element. |
|
|
Queries the Aggregated Transactions DMT aggregated by month with the selected filters. |
|
|
Queries the Aggregated Transactions DMT aggregated by product category with the selected filters. |
|
|
Queries the Aggregated Transactions DMT for total metrics with the selected filters. |
|
|
Separator element. |
|
|
Renders a Summary Table portlet displaying total metrics. |
|
|
Renders a column type chart displaying total metrics. |
|
|
Renders a column and spline type chart displaying changes to revenue and margin % over selected time period. |
|
|
Renders a tree map type chart with drilldown displaying revenue per product category on selected hierarchy level. |
|
|
Renders a table displaying revenue, profit and opportunities by customer category with on click event on customer category displaying |
|
|
Renders a table displaying revenue, profit and opportunities by customer, opened by on click event in |
|
|
Separator element. |
|
|
Displays a portlet with link to the model object that is used to query the data shown in this dashboard. |
ID_Dashboard_CustomersOverview_Configurator
The configurator logic for the Customers Overview dashboard which defines its inputs. The purpose of this logic is to generate inputs for the dashboard.
Element Description
ID_Dashboard_CustomersOverview_Configurator Element Description
|
Element |
Description |
|
|
Separator element. |
|
|
Initializes config manager for model utils. |
|
|
Separator element. |
|
|
Creates a Review Period input for selecting the review period (date range) for the dashboard. |
|
|
Creates a Customer Hierarchy input allowing selection of the Customer Hierarchy filter used across the dashboard. |
|
|
Creates a Customer Rank input used to filter data by customer rank. |
|
|
Creates a Product Hierarchy input allowing selection of the product aggregation level used across the dashboard. |
|
|
Creates a General Filter input providing additional common filters for customers, products and other dimensions. |
|
|
Separator element. |
|
|
Creates a Time Period input defining the time aggregation (for example, month) used in time-based charts and tables. |
|
|
Creates a Customer Category input used to filter or group results by customer category. |
|
|
Defines the “More Options” collapsible container grouping advanced inputs such as Time Period and Customer Category. |
ID_Dashboard_CustomersOverview_EmbeddedTable
The logic is a dashboard logic for the Customers Overview embedded table. It is used as a sub-dashboard that renders the "Revenue and L12M Opportunity by Customer" drill-down table when a user clicks on a customer category row in the parent Customers Overview dashboard.
Element Description
ID_Dashboard_CustomersOverview_EmbeddedTable Element Description
|
Element |
Description |
|
|
Separator element. |
|
|
Standard Abort Input Generation element. |
|
|
Separator element. |
|
|
Initializes config manager for model utils. |
|
|
Initializes the Cache Manager for caching query results. |
|
|
Separator element. |
|
|
Reads inputs and context parameters from the parent Customers Overview dashboard, and provides them to the embedded table. |
|
|
Reads the value of the selected column from the parent portlet and uses it as a filter for the embedded table. |
|
|
Separator element. |
|
|
Queries the Customer Product Rolling Period DMT reusing Customers Overview filters and the selected parent context to retrieve detailed L12M data for the embedded table. |
|
|
Separator element. |
|
|
Renders an embedded table displaying revenue, profit and L12M opportunity by customer, filtered by the row selected in the parent |
ID_Dashboard_CustomersOverview_EmbeddedTable_CustomerOverview_ContextLink
The logic is a context link logic for the Customers Overview embedded table. It provides a link from a customer row in the Customers Overview embedded table to the Customer Performance dashboard, passing the selected customer (and related filters) as context.
Element Description
ID_Dashboard_CustomersOverview_EmbeddedTable_CustomerOverview_ContextLink Element Description
|
Element |
Description |
|---|---|
|
|
Creates a context link definition that opens the Customer Performance dashboard from the Customers Overview embedded table, passing the selected customer(s) (and related filters) as navigation context. |
Customer Performance Logics
ID_Dashboard_CustomerPerformance
The core logic for the Customer Performance dashboard which defines dashboard's queries and portlets. The purpose of this logic is to provide data queries and render portlets.
The empty elements are separators with the following name pattern: ___SOME_NAME___.
Element Description
ID_Dashboard_CustomerPerformance Element Description
|
Element |
Description |
|
|
Separator element. |
|
|
Loads shared configuration constants (labels, keys, structural settings) used by the logic. |
|
|
Separator element. |
|
|
Initializes the Warning Manager which handles most of the exceptions thrown. |
|
|
Initializes config manager for model utils. |
|
|
Initializes the Cache Manager for caching query results. |
|
|
Separator element. |
|
|
Provides shared methods for query and portlets elements. |
|
|
Separator element. |
|
|
Generates Inputs as defined by the Configuration. |
|
|
Standard Abort Input Generation element. |
|
|
Checks if the Inputs are valid, throws an error if not. |
|
|
Determines whether the configured Reference Price field is an extended field available in the Aggregated Transactions DMT, affecting how pricing metrics are queried. |
|
|
Separator element. |
|
|
Queries the Aggregated Transactions DMT for total metrics with the selected filters and customer. |
|
|
Queries the Aggregated Transactions DMT aggregated by month with the selected filters and customer. |
|
|
Queries the Aggregated Transactions DMT aggregated by product hierarchy with the selected filters and customer. |
|
|
Queries the Aggregated Transactions DMT aggregated by product rank with the selected filters and customer. |
|
|
Queries the Customer Product Rolling Period DMT for pricing opportunity metrics by product category for the selected customer. |
|
|
Separator element. |
|
|
Computes year-over-year revenue and profit trends for the selected customer by comparing the current and previous periods. |
|
|
Builds a map of customer hierarchy field values for the selected customer, used in summary display. |
|
|
Separator element. |
|
|
Renders a Summary Table portlet displaying total metrics for the selected customer. |
|
|
Renders a column type chart displaying total metrics for the selected customer. |
|
|
Renders column and spline type charts displaying changes to revenue and margin % over selected time period |
|
|
Renders a tree map type chart with drilldown displaying revenue per product category on selected hierarchy level. |
|
|
Renders a column type chart displaying product count for each product rank. |
|
|
Renders a pie type chart displaying pricing opportunity per product category on selected hierarchy level. |
|
|
Renders a waterfall type chart with drilldown displaying price components information. |
|
|
Renders a table displaying opportunities by product category with on click event on product category displaying |
|
|
Renders table displaying opportunities by product, opened by on click event in |
|
|
Separator element. |
|
|
Displays a portlet with link to the model object that is used to query the data shown in this dashboard. |
ID_Dashboard_CustomerPerformance_Configurator
The configurator logic for the Customer Performance dashboard which defines its inputs. The purpose of this logic is to generate inputs for the dashboard.
The empty elements are separators with the following name pattern: ___SOME_NAME___.
Element Description
ID_Dashboard_CustomerPerformance_Configurator Element Description
|
Element |
Description |
|
|
Separator element. |
|
|
Initializes config manager for model utils. |
|
|
Separator element. |
|
|
Creates a Customer picker input used to filter the dashboard data to selected customer(s). |
|
|
Creates a Review Period input for selecting the review period (date range) for the dashboard. |
|
|
Creates a General Filter input providing additional common filters for customers, products and other dimensions. |
|
|
Creates a Product Hierarchy input allowing selection of the product aggregation level used across the dashboard. |
|
|
Creates a Product Rank input used to filter data by product rank. |
|
|
Separator element. |
|
|
Creates a Time Period input defining the time aggregation (for example, month) used in time-based charts and tables. |
|
|
Creates a Product Category input used to filter or group results by the selected product category. |
|
|
Defines the “More Options” collapsible container grouping advanced inputs such as Time Period and Product Category. |
ID_Dashboard_CustomerPerformance_EmbeddedTable
The logic is a dashboard logic for the Customer Performance embedded table. It is used as a sub-dashboard that renders the Opportunities By Product drill-down table when a user clicks on a product category row in the parent Customer Performance dashboard.
The empty elements are separators with the following name pattern: ___SOME_NAME___.
Element Description
ID_Dashboard_CustomerPerformance_EmbeddedTable Element Description
|
Element |
Description |
|
|
Separator element. |
|
|
Standard Abort Input Generation element. |
|
|
Separator element. |
|
|
Initializes config manager for model utils. |
|
|
Initializes the Cache Manager for caching query results. |
|
|
Separator element. |
|
|
Reads inputs and context parameters from the parent Customer Performance dashboard, and provides them to the embedded table. |
|
|
Reads the value of the selected column from the parent portlet and uses it as filter for the embedded table. |
|
|
Separator element. |
|
|
Queries the Customer Product Rolling Period DMT reusing Customer Performance filters and the selected parent context to retrieve detailed data for the embedded table. |
|
|
Separator element. |
|
|
Renders an embedded table displaying opportunities by product, filtered by the selected parent row and shared filters from Customer Performance. |
Customer Trends Logics
ID_Dashboard_CustomerTrends
The core logic for the Customer Trends dashboard which defines dashboard's queries and portlets. The purpose of this logic is to generate data queries and portlets.
The empty elements are separators with the following name pattern: ___SOME_NAME___.
Element Description
ID_Dashboard_CustomerTrends Element Description
|
Element |
Description |
|
|
Separator element. |
|
|
Loads shared configuration constants (labels, keys, structural settings) used by the logic. |
|
|
Separator element. |
|
|
Initializes the Warning Manager that handles most of the exceptions thrown. |
|
|
Initializes config manager for model utils. |
|
|
Initializes the Cache Manager for caching query results. |
|
|
Separator element. |
|
|
Provides shared methods for query and portlets elements. |
|
|
Separator element. |
|
|
Generates Inputs as defined by the Configuration. |
|
|
Standard Abort Input Generation element. |
|
|
Separator element. |
|
|
Queries the Customer Rolling Period DMT for customer health score data with the selected filters. |
|
|
Queries the Customer Rolling Period DMT aggregated by customer category for rolling period trend metrics. |
|
|
Queries the Aggregated Transactions DMT for total metrics with the selected filters. |
|
|
Queries the Aggregated Transactions DMT aggregated by product hierarchy with the selected filters. |
|
|
Queries the Aggregated Transactions DMT aggregated by month with the selected filters. |
|
|
Retrieves the label of the selected customer category aggregation field for display in table headers. |
|
|
Separator element. |
|
|
Computes year-over-year revenue and profit trends by comparing the current and previous periods across all customers. |
|
|
Separator element. |
|
|
Renders a Summary Table portlet displaying total metrics. |
|
|
Renders a column type chart displaying total metrics. |
|
|
Renders a column and spline type chart displaying changes to revenue and margin % over selected time period. |
|
|
Renders a tree map type chart with drilldown displaying revenue per product category on selected hierarchy level. |
|
|
Renders a bubble chart displaying revenue and profit trends over time, optionally by customer category. |
|
|
Renders a heatmap chart displaying customer health score and rank based on defined KPIs. |
|
|
Renders a table displaying revenue, profit and trend metrics by customer category with on click event opening |
|
|
Renders a table displaying revenue, profit and trend metrics by customer, typically opened from |
|
|
Separator element. |
|
|
Displays a portlet with link to the model object that is used to query the data shown in this dashboard. |
ID_Dashboard_CustomerTrends_Configurator
The configurator logic for Customer Trends dashboard which defines Customer Trends inputs. The purpose of this logic is to generate inputs for the dashboard.
The empty elements are separators with the following name pattern: ___SOME_NAME___.
Element Description
ID_Dashboard_CustomerTrends_Configurator Element Description
|
Element |
Description |
|
|
Separator element. |
|
|
Initializes config manager for model utils. |
|
|
Separator element. |
|
|
Creates a Customer Hierarchy input allowing selection of the CustomerHierarchy filter used across the Customer Trends dashboard. |
|
|
Creates a Customer Rank input used to filter data by customer rank. |
|
|
Creates a Customer Health Score input used to filter customers by their health score range. |
|
|
Creates a Customer picker input used to focus the analysis on selected customer(s). |
|
|
Separator element. |
|
|
Creates a Time Period input defining the time aggregation (for example, month) used in time-based charts and tables. |
|
|
Creates a Customer Category Aggregation Level input defining how customers are grouped into categories (e.g. Industry, Segmentation, Country, City, Customer Group, Customer Class). |
|
|
Defines the “More Options” collapsible container grouping advanced inputs such as Time Period and Customer Category Aggregation Level. |
ID_Dashboard_CustomerTrends_EmbeddedTable
The logic for the embedded table TrendByCustomerTable in the Customer Trends dashboard. This table is accessed by an event in TrendByCustomerCategoryTable.
The empty elements are separators with the following name pattern: ___SOME_NAME___.
Element Description
ID_Dashboard_CustomerTrends_EmbeddedTable Element Description
|
Element |
Description |
|
|
Separator element. |
|
|
Standard Abort Input Generation element. |
|
|
Reads inputs and context parameters from the parent Customer Trends dashboard, providing them to the embedded table. |
|
|
Separator element. |
|
|
Initializes config manager for model utils. |
|
|
Initializes the Cache Manager for caching query results. |
|
|
Separator element. |
|
|
Reads the value of the selected column from the parent portlet and uses it as filter for the embedded table. |
|
|
Separator element. |
|
|
Queries the Customer Rolling Period DMT filtered by the selected customer category and parent dashboard filters, returning per-customer trend metrics. |
|
|
Separator element. |
|
|
Renders an embedded table displaying trends and performance metrics by customer, driven by the selection in the parent |
ID_Dashboard_CustomerTrends_EmbeddedTable_CustomerPerformance_ContextLink
The logic is a context link logic for the Customer Trends embedded table. It provides a link from a customer row in the Customer Trends embedded table to the Customer Performance dashboard, passing the selected customer (and related filters) as context.
Element Description
ID_Dashboard_CustomerTrends_EmbeddedTable_CustomerPerformance_ContextLink Element Description
|
Element |
Description |
|---|---|
|
|
Creates a context link definition that opens the Customer Performance dashboard from the Customer Trends embedded table, passing the selected customer(s) (and related filters) as navigation context. |
Insights Configuration Model Class Logics
ID_Model_Definition_Transactions_Tab
The logic is an evaluation logic of the Insights Dashboards Model Class. It implements the Transactions tab in the Definition step of the model.
Element Description
ID_Model_Definition_Transactions_Tab Element Description
|
Element |
Description |
|
|
Generates Inputs as defined by the Configuration. |
|
|
Standard Abort Input Generation element. |
|
|
Builds the list of selected columns from the configurator inputs, in a structured form used by the preview queries. |
|
|
Returns a ResultPAQuery table labeled “Selected Transactions” showing all transactions from the chosen DS that pass the configured filter, with the columns defined by SelectedColumns. |
|
|
Returns a ResultPAQuery table labeled “Filtered out” showing transactions from the chosen Transactions source that are excluded by the configured filter or scope, using the same column selection as SelectedTransactions. |
ID_Model_Definition_Transactions_Tab_Configurator
The configurator logic for Transactions tab which defines Transactions tab’s inputs. The purpose of this logic is to generate inputs for the tab.
The empty elements are separators with the following name pattern: ___SOME_NAME___.
Element Description
ID_Model_Definition_Transactions_Tab_Configurator Elements Description
|
Element |
Description |
|
|
Separator element. |
|
|
Loads shared configuration constants (labels, keys, structural settings) used by the logic. |
|
|
Separator element. |
|
|
Defines the general / source inputs for the Transactions tab configurator, including Source Name, Filter, and Date. |
|
|
Defines the product‑related inputs taken from the Transactions source: Product, Product Label, Product Hierarchy, and Product Attributes. |
|
|
Defines the customer‑related inputs taken from the Transactions source: Customer, Customer Label, Customer Hierarchy, and Customer Attributes. |
|
|
Defines the transaction‑metric and additional attribute inputs: Additional Attributes, List Price, Reference Price, Revenue, Profit, and Quantity. |
ID_Model_Definition_Products_Tab
The logic is an evaluation logic of the Insights Dashboards Model Class. It implements the Products tab in the Definition step of the model.
Element Description
ID_Model_Definition_Products_Tab Element Description
|
Element |
Description |
|
|
Generates Inputs as defined by the Configuration. |
|
|
Standard Abort Input Generation element. |
|
|
Evaluates the value of the Enable Product Source input and returns a Boolean used as a condition for downstream elements (SelectedColumns, SelectedProducts, FilteredOutProducts). |
|
|
Builds the list of selected columns (defined in Product, Product Hierarchy, and Product Attributes inputs) from the configurator inputs, in a structured form used by the preview queries. |
|
|
When |
|
|
When |
ID_Model_Definition_Products_Tab_Configurator
The configurator logic for Products tab which defines Products tab’s inputs. The purpose of this logic is to generate inputs for the tab.
The empty elements are separators with the following name pattern: ___SOME_NAME___.
Element Description
ID_Model_Definition_Products_Tab_Configurator Element Description
|
Element |
Description |
|
|
Separator element. |
|
|
Loads shared configuration constants (labels, keys, structural settings) used by the logic. |
|
|
Separator element. |
|
|
Creates the configurator entry for the Products tab, defining how the Product‑related inputs (Enable Product Source, Source Name, Filter, Product, Product Hierarchy, and Product Attributes) are rendered and grouped in the UI. |
ID_Model_Definition_Customers_Tab
The logic is an evaluation logic of the Insights Dashboards Model Class. It implements the Customers tab in the Definition step of the model.
Element Description
ID_Model_Definition_Customers_Tab Element Description
|
Element |
Description |
|
|
Generates Inputs as defined by the Configuration. |
|
|
Standard Abort Input Generation element. |
|
|
Evaluates the value of the Enable Customer Source input and returns a Boolean used as a condition for downstream elements (SelectedColumns, SelectedCustomers, FilteredOutCustomers). |
|
|
Builds the list of selected columns (defined in Customer, Customer Hierarchy, and Customer Attributes inputs) from the configurator inputs, in a structured form used by the preview queries. |
|
|
When |
|
|
When |
ID_Model_Definition_Customers_Tab_Configurator
The configurator logic for Customers tab which defines Customers tab’s inputs. The purpose of this logic is to generate inputs for the tab.
The empty elements are separators with the following name pattern: ___SOME_NAME___.
Element Description
ID_Model_Definition_Customers_Tab_Configurator Element Description
|
Element |
Description |
|
|
Separator element. |
|
|
Loads shared configuration constants (labels, keys, structural settings) used by the logic. |
|
|
Separator element. |
|
|
Creates the configurator entry for the Customers tab, defining how the Customer‑related inputs (Enable Customer Source, Source Name, Filter, Customer, Customer Hierarchy, and Customer Attributes) are rendered and grouped in the UI. |
ID_Model_Configuration_General_Tab
The configurator logic for General tab which defines General tab’s inputs. The purpose of this logic is to generate inputs for the tab.
The empty elements are separators with the following name pattern: ___SOME_NAME___.
Element Description
ID_Model_Configuration_General_Tab Element Description
|
Element |
Description |
|
|
Separator element. |
|
|
Loads shared configuration constants (labels, keys, structural settings) used by the logic. |
|
|
Standard Abort Input Generation element. |
|
|
Separator element. |
|
|
Defines the Date Range Option input, including available options such as Last 12 full months, Last year + running year, Last 24 full months, etc., and ensures only data within the selected date range are considered in subsequent aggregations. |
|
|
Defines the Ranks InputMatrix for customer and product ranks: columns Type, Period, Number of Ranks; sets default period (L12M) and validates that Number of Ranks is an integer > 0; drives Customer Rank and Product Rank calculations in the aggregation DMTs and the corresponding rank inputs in dashboards. |
|
|
Defines Product and Customer Hierarchy input matrices that capture the ordered list of hierarchy fields and exclude flags used to build aggregation and filter hierarchies. |
|
|
Defines Health Score-related inputs such as revenue/profit weighting, health score bands and interpolation options used to derive customer health scores. |
|
|
Defines gauge configuration inputs for margin and price realization, including min/max ranges and color thresholds that control how gauge widgets are rendered. |
|
|
Defines the thresholds for trend classification, specifying “down” ( |
ID_Model_Configuration_Waterfall_Tab
The configurator logic for Waterfall tab which defines Waterfall tab’s inputs. The purpose of this logic is to generate inputs for the tab.
The empty elements are separators with the following name pattern: ___SOME_NAME___.
Element Description
ID_Model_Configuration_Waterfall_Tab Element Description
|
|
Separator element. |
|
|
Loads shared configuration constants (labels, keys, structural settings) used by the logic. |
|
|
Separator element. |
|
|
Creates the configurator entry for the Waterfall tab, defining how the Waterfall‑related inputs (Waterfall Definition) are rendered and grouped in the UI. |
ID_Model_Review_Default_Tab
The logic is an evaluation logic of the Insights Dashboards Model Class. It implements the default tab (the only tab) in the Review step of the model.
Empty elements are separators with the following naming pattern: ___SOME_NAME___.
Element Description
ID_Model_Review_Default_Tab Element Description
|
Element |
Description |
|
|
Creates table displaying information about model configuration and calculation (e.g, duplicate fields detected during input selection). |
|
|
Separator element. |
|
|
Returns a ResultPAQuery table labeled “Aggregated Transactions” showing all transactions aggregated by Customer, Product, and Month from the chosen DM and DS(s) that pass the configured filter(s), with the columns defined by user’s inputs and extra columns that later on be used in Insights Dashboards (view Aggregated Transactions (Insights Dashboards) for columns' details). |
|
|
Separator element. |
|
|
Returns a ResultPAQuery table labeled “Customer Rolling Period”, with the columns defined in Customer Rolling Period (Insights Dashboards). |
|
|
Separator element. |
|
|
Returns a ResultPAQuery table labeled “Customer Product Rolling Period”, with the columns defined in Customer Product Rolling Period (Insights Dashboards). |
|
|
Separator element. |
|
|
Returns a ResultPAQuery table labeled “Cross Sell”, with the columns defined in (view Cross Sell Rolling Period (Insights Dashboards). |
ID_Model_Configuration_Calculation
The logic is a calculation logic of the Insights Dashboards Model Class. It runs during the Configuration Calculation phase, before the Data Calculation. Its purpose is to extract and validate all user-provided inputs from the Definition and Configuration steps, persist them into the Configuration DMT, and create the lookup tables (Currency, Configuration Information, Health Score Preview) that are consumed by downstream data calculation and dashboard logics.
Empty elements are separators with the following naming pattern: ___SOME_NAME___.
Element Description
ID_Model_Configuration_Calculation Element Description
|
Element |
Description |
|
|
Separator element. |
|
|
Loads shared configuration constants (labels, keys, structural settings) used by the logic. |
|
|
Provides shared methods for extracting model inputs into configuration maps, populating the Configuration DMT, validating inputs across all tabs, and detecting duplicate labels between user-selected fields and reserved DMT fields. |
|
|
Separator element. |
|
|
Creates and registers the Configuration Information parameter table in the model. This table stores informational and warning messages generated during configuration validation (e.g. duplicate field labels). |
|
|
Reads all user inputs from the Definition and Configuration steps (Transactions, Products, Customers, General, and Waterfall tabs), validates them, detects duplicate labels, populates the Configuration DMT with JSON-encoded processed inputs, and writes any validation messages to the Configuration Information parameter table. |
|
|
Creates and registers the Currency parameter table in the model. This table stores the currency name and its symbol, used by dashboards for consistent currency display. |
|
|
Creates and populates the Health Score Preview parameter table in the model. This table stores the Health Score Definition configured in the General tab as a matrix. This table is only a readable preview of the JSON-based configuration of the Health Score Definition stored in Configuration table above. |
ID_Model_Data_Calculation
The logic is a calculation logic of the Insights Dashboards Model Class. It runs during the Data Calculation phase, after the Configuration Calculation. Its purpose is to read the validated configuration, load the raw transaction data from the configured Datamart (joining with Customer and Product data sources), compute all derived fields (for example: ranks, trends, health scores, etc.), and populate the output DMTs (Source Table, Customer Rank, Product Rank, Customer L12M Trend, Cross Sell Rolling Period, Customer Rolling Period, Customer Product Rolling Period, and Aggregated Transactions) that are consumed by the dashboards.
Empty elements are separators with the following naming pattern: ___SOME_NAME___.
Element Description
ID_Model_Configuration_Calculation Element Description
|
Element |
Description |
|
|
Separator element. |
|
|
Initializes the config manager for model utils. |
|
|
Separator element. |
|
|
Loads shared configuration constants (labels, keys, structural settings) used by the logic. |
|
|
Retrieves the configured Customer ID field name from the model's configuration. |
|
|
Retrieves the configured Product ID field name from the model's configuration. |
|
|
Retrieves the configured Customer Name (label) field name from the model's configuration. |
|
|
Retrieves the configured Product Name (label) field name from the model's configuration. |
|
|
Retrieves the configured Quantity field name from the model's configuration. |
|
|
Retrieves the transaction Datamart source table reference from the configured source name. |
|
|
Queries the transaction Datamart to discover extended fields available in the source, and returns the list of extended field names. |
|
|
Retrieves the configured Profit field name from the model's configuration. |
|
|
Retrieves the configured Revenue field name from the model's configuration. |
|
|
Retrieves the configured List Price field name from the model's configuration. |
|
|
Retrieves the configured Reference Price field name from the model's configuration. |
|
|
Determines whether the configured Reference Price field is an extended transaction field by checking if it appears in the |
|
|
Retrieves the configured Date field name from the model's configuration. |
|
|
Derives the Month field name by appending "Month" to the configured Date field name. |
|
|
Derives the Quarter field name by appending "Quarter" to the configured Date field name. |
|
|
Derives the Year field name by appending "Year" to the configured Date field name. |
|
|
Queries the transaction Datamart to find the latest (most recent) transaction date, used as the reference point for date range and rolling period calculations. |
|
|
Retrieves the configured customer hierarchy field definitions from the model's configuration and generates a sorted list of field configurations used for customer hierarchy groupings in DMTs and dashboards. |
|
|
Retrieves the configured product hierarchy field definitions from the model's configuration and generates a sorted list of field configurations used for product hierarchy groupings in DMTs and dashboards. |
|
|
Retrieves the configured customer attributesfield definitions from the model's configuration, used to build additional customer-dimension attributes in aggregation queries. |
|
|
Retrieves the configured product attribute field definitions from the model's configuration, used to build additional product-dimension attributes in aggregation queries. |
|
|
Retrieves any additional (non-customer, non-product) filter field definitions from the model's configuration, used to build supplementary filters in aggregation queries. |
|
|
Retrieves the configured waterfall component field definitions from the model's configuration, resolves their source Datamart references, and generates the field configuration list used to include waterfall price components in aggregation DMTs. |
|
|
Retrieves the configured waterfall component field definitions that are calculated (not sourced from a Datamart field) and generates a field configuration list for computed waterfall components (e.g. derived margins or spreads). |
|
|
Builds the field mapping dictionary that maps standard internal field keys (CUSTOMER_ID, PRODUCT_ID, REVENUE, PROFIT, DATE, etc.) to the actual configured Datamart field names, including handling of extended vs. standard Reference Price fields. |
|
|
Resolves the configured date range option (e.g. Last 12 full months, Last 24 full months) against the latest transaction date to compute the start and end dates, and saves the computed time range period to the model's configuration. |
|
|
Builds the composite query filter expression from the user-defined transaction filter configuration (e.g. exclusions by customer, product, or other criteria defined in the Transactions Tab), applied to the source data load query. |
|
|
Retrieves the configured number of product ranks from the model's configuration, used to assign product rank buckets in the Product Rank DMT. |
|
|
Retrieves the configured number of customer ranks from the model's configuration, used to assign product customer buckets in the Customer Rank DMT. |
|
|
Retrieves the configured health score definitions (revenue/profit weightings, bands, and interpolation settings) from the model's configuration, used during Customer Rolling Period aggregation to compute customer health scores. |
|
|
Retrieves the configured revenue share percentage from the model's configuration, used to weight revenue vs. profit contributions in health score and opportunity calculations. |
|
|
Separator element. |
|
|
Provides a utility method that validates DMT field templates by appending a "(PFX)" suffix to any reserved field label that collides with a user-selected attribute or hierarchy label, preventing column name conflicts in output DMTs. |
|
|
Separator element. |
|
|
Detects duplicate labels between user-selected fields (hierarchies, filters, attributes) and reserved DMT field templates across all output tables, returning the set of conflicting labels so that |
|
|
Creates and registers the Source Table DMT in the model. This intermediate table stores the joined and mapped transaction data (with customer/product hierarchies, filters, and waterfall components) before aggregation. |
|
|
Creates and registers the Customer Rank Table DMT in the model, which stores the computed customer rank assignments. |
|
|
Creates and registers the Product Rank Table DMT in the model, which stores the computed product rank assignments. |
|
|
Creates and registers the Customer L12M Trend Table DMT in the model, which stores last-12-months trend metrics per customer used for trend classification. |
|
|
Creates and registers the Cross Sell Rolling Period Table DMT in the model, which stores cross-sell opportunity metrics per customer-product combination. |
|
|
Creates and registers the Customer Rolling Period Table DMT in the model, which stores rolling period aggregated metrics per customer including health scores. |
|
|
Creates and registers the Customer Product Rolling Period Table DMT in the model, which stores rolling period aggregated metrics per customer-product combination including pricing opportunities. |
|
|
Creates and registers the Aggregated Transactions Table DMT in the model, which stores the final aggregated transaction data by customer, product, and month. |
|
|
Separator element. |
|
|
Loads raw transaction data from the configured Datamart, joins with Customer and Product data sources to enrich with hierarchy and filter fields, applies the configured transaction filter and date range, maps all fields using |
|
|
Validates that |
|
|
Prepares a rolling period filter for Source Table DMT by computing the L12M date range from the latest transaction date and marks/filters the Source Table rows that fall within the rolling period window, preparing the data for rolling period aggregations. |
|
|
Queries the Source Table to compute customer revenue rankings within the configured date range, assigns each customer to a rank bucket based on the configured number of customer ranks, and loads the results into the Customer Rank Table DMT. |
|
|
Queries the Source Table to compute product revenue rankings within the configured date range, assigns each product to a rank bucket based on the configured number of product ranks, and loads the results into the Product Rank Table DMT. |
|
|
Queries the Source Table to compute L12M trend metrics per customer (comparing current and previous 12-month periods for revenue and profit), and loads the results into the Customer L12M Trend Table DMT. |
|
|
Separator element. |
|
|
Aggregates Source Table data by customer-product combination within the rolling period, joins with Customer Rank and Product Rank data, computes cross-sell opportunity metrics, and loads the results into the Cross Sell Rolling Period Table DMT. |
|
|
Aggregates Source Table data by customer within the rolling period, joins with Customer Rank and L12M Trend data, computes health scores based on configured revenue/profit weightings, and loads the results into the Customer Rolling Period Table DMT. |
|
|
Aggregates Source Table data by customer-product combination within the rolling period, joins with Customer Rank, Product Rank, and Cross Sell data, computes pricing opportunity metrics (using the configured realization rate), and loads the results into the Customer Product Rolling Period Table DMT. |
|
|
Aggregates Source Table data by customer, product, and month, joins with Customer Rank and Product Rank data, computes per-period metrics (revenue, profit, quantity, margin, waterfall components), and loads the results into the Aggregated Transactions Table DMT. |
ID_Model_Configuration_Evaluation
The logic is an evaluation logic of the Insights Dashboards Model Class. It runs during the Configuration step to present read-only previews of the persisted configuration tables (Configuration, Currency, and Configuration Information) so the user can verify the model's configuration state before proceeding to calculation.
Element Description
ID_Model_Configuration_Evaluation Element Description
|
Element |
Description |
|
|
Delegates to |
|
|
Delegates to |
|
|
Delegates to |
ID_Model_Data_Evaluation
The logic is an evaluation logic of the Insights Dashboards Model Class. Its sole purpose is to read the aggregated DMTs (which are Cross Sell, Customer Rolling Period, Customer Product Rolling Period, and Aggregated Transactions) and expose them in a structured way to other logics and external consumers. It plays the role of an API for configuration data, not a UI tab.
Element Description
ID_Model_Data_Evaluation Element Description
|
Element |
Description |
|
|
Delegates to |
|
|
Delegates to |
|
|
Delegates to |
|
|
Delegates to |
ID_Model_Approval_WorkFlow
The logic is a workflow formula logic for the Insights Dashboards Model Class (workflowType: model). It is referenced in the InsightsDashboards Model Class definition via workflowFormulaName and controls the approval workflow for model instances.
Element Description
ID_Model_Approval_WorkFlow Element Description
|
Element |
Description |
|
|
Standard Abort Input Generation element. |
|
|
Retrieves the model object by its unique name, resolves the workflow type from |
Library Logics
ID_Lib_Model
The logic is a library logic that provides reusable utility classes and configuration constants for the Insights Dashboards model.
Element Description
ID_Lib_Model Element Description
|
Element |
Description |
|
|
Loads shared configuration constants (labels, keys, structural settings) used by the logic. |
|
|
Provides utility methods for model evaluation logics, including PA query building for DMT table previews and result formatting. |
|
|
Provides utility methods for creating, registering, and retrieving DMT tables within the model (Configuration, Currency Lookup, Configuration Information Lookup, Source Table, Customer Rank, Product Rank, Customer L12M Trend, Cross Sell Rolling Period, Customer Rolling Period, Customer Product Rolling Period, and Aggregated Transactions). |
|
|
Provides utility methods for reading and writing model state (configuration inputs, calculated values), and for tracking the model's lifecycle phases. |
|
|
Provides general-purpose utility methods for model operations (e.g. model lookup, field resolution, source table reference resolution). |
|
|
Provides utility methods for building model selector inputs in dashboard logics, allowing users to select which computed model instance to use for a dashboard. |
|
|
Provides utility methods for the Definition step, including building configurator filter expressions from user inputs and resolving Datamart source references. |
|
|
Provides utility methods for the Configuration step, including extracting and validating user inputs, populating the Configuration DMT, and detecting duplicate labels across tabs. |
|
|
Provides utility methods for working with input matrix configurator inputs, including modification detection (cell changes, row additions/removals, reordering, duplicate button clicks), cell value manipulation, and ordering management. |
|
|
Provides utility methods for building configurator input columns from configuration maps, combining and formatting warning messages, and adding section-level warning messages to configurator entries. |
|
|
Provides utility methods for formatting section messages (labels, descriptions) with HTML formatting and line separators for display in configurator entries. |
|
|
Provides utility methods for calendar and date operations, including month name resolution, date range computation, and rolling period boundary calculation. |
ID_Lib_Processing
The logic is a library logic that provides reusable utility classes and configuration constants for the Insights Dashboards dashboard rendering and data processing. These utilities are used across all four dashboards (Revenue & Profit, Customers Overview, Customer Performance, Customer Trends), their embedded tables, as well as the model's calculation.
Element Description
ID_Lib_Processing Element Description
|
Element |
Description |
|
|
Loads shared configuration constants (labels, keys, structural settings) used by the logic. |
|
|
Provides style-related configuration constants (CSS-like styling maps for charts, tables, gauges, and summary portlets) used for consistent visual presentation across all dashboards. |
|
|
Provides utility methods for building dashboard configurator inputs (customer/product selectors, hierarchy dropdowns, rank filters, date range pickers, time period options, general filter builders) from model configuration. |
|
|
Provides mathematical utility methods for dashboard calculations (percentage computation, safe division, rounding, weighted averages). |
|
|
Provides date utility methods for dashboard processing (date range parsing, period label formatting, month/quarter/year extraction from date strings). |
|
|
Provides data processing utility methods (query result extraction, row filtering, column mapping, data aggregation, sorting, and null-safe value access from Datamart query results). |
|
|
Provides formatting utility methods for dashboards (number formatting with currency, percentage formatting, color resolution, label truncation, and HTML content generation for summary tables). |
|
|
Provides utility methods for building ResultMatrix objects from query results, used for rendering sortable/filterable data tables in dashboard portlets. |
|
|
Provides utility methods for building context links between dashboards and embedded tables, including extracting row click context values and constructing navigation parameters. |
|
|
Provides utility methods for querying model DMTs (Aggregated Transactions, Customer Rolling Period, Customer Product Rolling Period, Cross Sell, Customer Rank, Product Rank), including building filtered and aggregated PA queries with the correct field selections and joins. |
|
|
Provides utility methods for reading and parsing the model's Configuration DMT, extracting processed configuration settings (field mappings, hierarchy configurations, waterfall components, filter definitions, health score definitions, gauge thresholds) into structured Maps consumed by dashboard logics. |
ID_Lib_Manager
The logic is a library logic that provides reusable manager classes for the Insights Dashboards accelerator. These managers are instantiated across dashboard logics, model calculation logics, and embedded table logics to centralize configuration access, caching, and error handling.
Element Description
ID_Lib_ManagerElement Description
|
Element |
Description |
|
|
Provides the Warning Manager class, which centralizes exception handling and warning message collection. Used by model calculation and dashboard logics to catch, store, and display errors and warnings without aborting the entire calculation. |
|
|
Provides the Cache Manager class, which caches query results and computed values during a single logic execution. Prevents redundant queries when multiple elements in the same logic need the same data (e.g. same DMT table queried for different chart portlets). |
|
|
Provides the Configuration Manager class, which reads the model's Configuration DMT and exposes a structured interface for accessing all model configuration settings (field mappings, date range, ranks, health score definitions, waterfall components, hierarchy fields, etc.). Used by all dashboard and embedded table logics. |