We have major frontend performance issues, which stems from the HIDEROW() and HDECOLUMN() functions are not performing well. However, with the current Jedox functionality, these are key to nice UI, so increasing performance would really help out.
ADMIN RESPONSE
Mar 28, 2024
Thanks for the idea. This feature has been evaluated by us and we will not implement it at this time.
I do not think I have the patience for waiting on this on the other side of 100 hiderows.
I got the recommendation from a Jedox consultant to aviod these whenever possible to gain performance.
Observation: I've notice (while avoiding these functions) that if I use a dynarange, then hiderow directly in the sheet is overridden even if the dynarange is set to not autosizing. This forced me to use the hiderow() function to achive the needed result.
thanks for this idea. In the scenarios you're thinking of, can you roughly quantify on which scale you're using these functions? In an end-user facing report, would you have tens / hundreds or even thousands of rows / columns which are hidden?
Well the performance hit is 10's.
I do not think I have the patience for waiting on this on the other side of 100 hiderows.
I got the recommendation from a Jedox consultant to aviod these whenever possible to gain performance.
Observation: I've notice (while avoiding these functions) that if I use a dynarange, then hiderow directly in the sheet is overridden even if the dynarange is set to not autosizing. This forced me to use the hiderow() function to achive the needed result.
Hi,
thanks for this idea. In the scenarios you're thinking of, can you roughly quantify on which scale you're using these functions? In an end-user facing report, would you have tens / hundreds or even thousands of rows / columns which are hidden?