Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
can any body tell me what are tha major causes for poor performance of chart
Hi,
Performance issues in charts is because of
- Huge Calculations in front end instead of doing in script
- Use of Distinct, IF() and Aggr()
- Showing huge data for example all Transactions data, also issues especially araises in Table boxes and Straight and Pivot tables.
- Inadequate RAM and system resources
- Huge file size
etc.
Regards,
Jagan.
(1) Using expressions with Distinct key words
(2) Too many dimensions and expressions
(3) Having dimensions with lowest granularity Ex: Account ID,transaction
(4) using two much set analysis (nested if') and Conditional hide/show
Hi,
Performance issues in charts is because of
- Huge Calculations in front end instead of doing in script
- Use of Distinct, IF() and Aggr()
- Showing huge data for example all Transactions data, also issues especially araises in Table boxes and Straight and Pivot tables.
- Inadequate RAM and system resources
- Huge file size
etc.
Regards,
Jagan.
Add Minicharts to that. If the minichart has a complex expression and spans a number of years/months, then that causes a significant performance hit.