How and how many columns I can add to my custom report?
Analytics, Oracle Service Cloud all versions
Oracle Service Cloud
There is a non-configurable limitation and each output level can have a maximum of 100 output columns. In addition, the number of tables used in a report is limited to 20.
The procedures to add report columns are the same whether you are adding standard or custom fields from the database, functions, variables, or computed fields. If your column returns information directly from the database, and does not require a complicated expression, you can add the column using the data dictionary. If your column’s expression is complicated, perhaps using several functions, it can be easier to add the column from the Column Definition window.
For additional information, refer to the 'Add an output column to a report' section in online documentation for the version your site is currently running. To access Oracle Service Cloud manuals and documentation online, refer to the Documentation for Oracle Service Cloud Products.