---
sourceDocument: Brazil Platform Analytics
sourceDocumentLink: https://www.servicenow.com/docs/r/now-intelligence

 Release :

    - brazil

ft:locale :

    - en-US

ft:publication_title :

    - Brazil Platform Analytics

ft:clusterId :

    - par

bundleId :

    - par

workflow :

    - Platform


---

# Collect and manage a matrix of breakdowns

# Collect and manage a matrix of breakdowns {#ariaid-title1}

Release version: Brazil  
Updated February 2, 2023  
![](https://www.servicenow.com/docs/portal-asset/ico-clock) 2 minutes to read  
Collect a matrix of the two-breakdown combinations for an indicator. Exclude unnecessary or meaningless combinations of breakdowns from being collected.

## Before you begin

Breakdowns must be assigned to the indicator. See [Assign and map breakdowns](https://www.servicenow.com/docs/qJZ2dvRRNxgQi3KWh2f5dQ "Select which breakdowns to assign to an indicator. Map which field on the indicator source references the breakdown source. If no appropriate field is available, specify a script to associate the indicator and breakdown sources.").  
Important:  
If you enable Data snapshots for an indicator, you are not limited to two-breakdown combinations and the indicator does not have a breakdown matrix. For more information, see [Data snapshots and multiple breakdowns](https://www.servicenow.com/docs/GM3~SPXJXh2dsqxl8BTMtA "Data snapshots in Platform Analytics allows for multiple breakdowns while analyzing your indicators (KPIs). This architecture uses a change data capture (CDC) process, which captures data changes from configurable tables that are optimized for generating scores and time series at run-time.").

Role required: pa_data_collector, pa_power_user, pa_admin, or admin

## About this task

Sometimes, not all breakdown combinations give useful information. For example, the combination \[Country, Region\] gives the same scores as the breakdown Country. You can prevent the instance from collecting data for these
invalid combinations with breakdown matrix exclusions. These exclusions are not shown in the Analytics Hub, in KPI Details, or in the scoresheet. You also cannot select excluded breakdown combinations when you create widgets or data visualizations.

To prevent performance issues, the property com.snc.pa.dc.max_breakdown_elements_level2_limit limits the number of elements from breakdown connections that are included in data collection. If you exceed this
limit, some of the combinations in your matrix are grayed out. By excluding some breakdown combinations, you can help to avoid exceeding this limit. For more information, see [Performance Analytics properties](https://www.servicenow.com/docs/BSLgXZ8h7TTGwmNNkB64Qw "These system properties control the behavior of Performance Analytics.").  
Note:  
* The scores for individual breakdowns are still collected when the combination of those breakdowns has been excluded.
* Scores that were collected in previous jobs for breakdown combinations are not deleted when those combinations are later excluded. New scores for those combinations are not collected.
* These instructions are for using the graphical tool to manage breakdown matrix exclusions. However, you can also manage them in the Breakdown matrix exclusion tab of the indicator form.
{#configure-breakdown-matrix__ul_qzs_lfj_rdb}

## Procedure

1. Navigate to Automated Indicators.
2. Select the automated indicator for which you want to configure the breakdown matrix.
3. Under Indicator properties, select the Collect breakdown matrix tab.
4. Select the Collect breakdown matrix check box.
5. Click Manage Breakdowns.
6. Click Configure Breakdown Matrix.  
   The matrix shows the number of element combinations for each breakdown pair, calculated by multiplying the number of elements for the two breakdowns. Breakdown pairs with a higher number of combinations are shown in a darker color, to help you spot possible performance bottlenecks at a glance. By default, all combinations are included in data collection. You can select combinations to exclude from data collection.
7. **Optional:** In the Breakdown Matrix pop-up, select breakdown combinations to exclude from Analytics Hub and dashboard widgets.  
   Included combinations are shaded in the breakdown matrix. Excluded combinations are white. If the number of breakdown combinations exceeds the value of com.snc.pa.dc.max_breakdown_elements_level2_limit, some combinations are grayed out. {#configure-breakdown-matrix__step_kqg_w1j_gw}
{#configure-breakdown-matrix__step_kqg_w1j_gw}
8. **Optional:** On the indicator form, open the Breakdown matrix exclusion tab and see which breakdown combinations have been excluded.  
   You can manage which breakdown combinations to exclude in this tab instead of using the graphical tool.
**Previous topic:** [Assign and map breakdowns](https://www.servicenow.com/docs/qJZ2dvRRNxgQi3KWh2f5dQ "Select which breakdowns to assign to an indicator. Map which field on the indicator source references the breakdown source. If no appropriate field is available, specify a script to associate the indicator and breakdown sources.")  
**Next topic:** [Add a collection job to an indicator](https://www.servicenow.com/docs/tP_Vi9qobF4yzviYzOauPg "To collect scores for an automated indicator, add a collection job to that indicator.")