Dynamic Report Limitations

Number of Attributes & Attribute Hierarchies mapped to the reporting cube across all dimensions

8

Number of active scenarios in the reporting cube

15

Delete unused scenario partitions

Number of dimensions with rollup operators applied

1 (Account only)

If roll up operators are applied for non-account dimensions, reports performance will be impacted

Number of Alternative Hierarchies across all dimensions

1 (Account only)

Number of dimensions where Dimension Security is applied

10

Number of lines in a static report row set used in Dynamic Reports

600

Use single member mappings in Reference Account lines

Number of lines in a static report column set used in Dynamic Reports

24

Use substitution variables and Excel-based expressions for improved performance

Number of children under a single parent at any level for Drill Down

500

Number of lines in Drill Through

30000

Size of logo used in report header

64 (height) x 150 (width) pixels

Physical size of logo used in report header

50KB

Up to 2MB is allowed, but 50KB is recommended for best report output.

Formulas

SUMIF, SUMPRODUCT & COUNTIF are not supported in Dynamic Reports

Print Setup

PDF and Microsoft Excel output for Header and Footer

If you apply fit to 1 x 1 or 1 x 2 option in the Dynamic Reports Print Setup and the report has more than 9 columns, the header and footer section are likely to be improperly aligned in the PDF output. This also applies to Excel output when the Header & Footer configuration is set to ‘Header & Footer Section’.