Execute Summary Query

coll_multidimensional_analysis

Multi-dimensional analysis combining agency, product, and region

Select Cycle *

Select the ingestion cycle to run this summary query against

Run asynchronously (recommended for large queries)

Force recalculation (ignore cached results)

Query Details

Source Table:: evolved_records
Dimensions:: 3
Metrics:: 7
Status:: Active

Execution Information

Dimensions:

coll_agency_code
coll_product_group
coll_region_code

Metrics:

(*) → account_count
(coll_total_due) → total_due_amount
(raw_data.collected_amount) → collected_amount
(coll_recovery_rate) → avg_recovery_rate
(coll_efficiency_score) → avg_efficiency_score
(coll_risk_score) → avg_risk_score
(coll_commission_base_amount) → commission_base_total

© SimSol Technologies and Services Private Limited