Why can't I export a KPI report to Excel when large number of values are selected in a filter?

• Related Articles

• Why do I get an error while exporting a KPI report to Excel with large number of values selected in a filter?

  When a KPI involving large number of values selected in a filter is exported to Excel, the excel file is will not be generated as desired. The reason being: A single cell in MS Excel accepts upto 32,767 characters and within a single cell, it will ...

• Filter Description should reflect for the selected filter values

  There is no implementation in the code for passing the description in the query. To key in the description values in the filter section, please change the below property from "No" to "Yes" and re-cache the changes. arc.show.kpi.desc.export Since most ...

• Unable to export large data to Excel. What could be the reason?

  The Excel report fails to generate if either the columns in the Excel exceed 255 or rows exceed 65,000. When the Excel file crosses this limit, the relevant error message is displayed.

• How to Hide the selected Filter while Publishing the KPI?

  In order to Hide any Filter; from the Modify Analysis, first select the Dimension and then select values for any of the filter under that Hierarchy and click on the "Set Mandatory Fields" option. Against the Level; check the 'Hide' button for the ...

• How do I increase the number of filter values appearing in the filter pop-up page?

  In 'arc.properties' file, set the below configuration and 'Re-cache changes for the changes to take effect': arc.filterpopup.pagination = 1000 (a suitable value)