- 1 Minute to read
- Print
- DarkLight
- PDF
Reporting Cube Configuration Limitations
- 1 Minute to read
- Print
- DarkLight
- PDF
Reporting Cube Configuration Limitations
Description | Limitation | Suggestions |
---|---|---|
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 |
|
Dynamic Report Limitations
Description | Limitation | Suggestions |
---|---|---|
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’. |