Tips for Adding Matrix Columns to a Report
When you choose a Column field to transform your report into a matrix, you should have a general idea of how many columns will be added based on the field you select. If there are too many columns, the report might fail to load. To avoid this, try one of the following options:
Scheduled reports sent as XLS files may be sent successfully regardless of the number of columns. However it is still good practice to minimize the number of columns in a matrix to avoid performance issues when viewing the report in NetSuite.
-
If you know that the selected field will add many columns to the report, add it as a column in the report builder instead. This presents each dimension value as a row in a single column. For more information, see Adding Report Columns.
-
After you select a Column field, click More in the report footer options and manually select only some of the dimensions to includes as columns in the report. You can then run the report, export the partial results, then repeat the process with the next set of columns and merge the results.
-
If you add a persistent matrix column to a custom financial statement, select a (Hierarchy) option in the View Columns By list. This will limit the number of unique columns per dimension. For more information, see Adding Persistent Matrix Columns to Financial Statements.