Skip Navigation
Expand
Output columns limitation in a custom report
Answer ID 10144   |   Last Review Date 03/18/2019

How and how many columns I can add to my custom report?

Environment:

Analytics, Oracle B2C Service all versions
Oracle B2C Service

Resolution:

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 the Online Help User Guide documentation. To access Oracle B2C Service manuals and documentation online, refer to the Documentation for Oracle B2C Service Products.