Hi all,
In our project we have main planning screen. In this view we have a client filter. And according to the selection on the client filter the number of rows on the view is changing. In some cases we list 5 rows, in some cases we list 500+ rows.
95% of the cases we dont have any performance issue. But for the big clients when the number of rows increases sharply we face some performance issues. We face lags and sometimes the browser is locked any you can even do anything for a while.
So we are looking for any possible performance improvements. We cant replicate the exact view on any other tool because it is a merged one. So we are not sure whether it is related to the cube/rule performance or something related to the way that we build the view.
We are open for suggestions. From your past experiences or from your knowhow if you can share the things that I need to check or options to improve the performance really appreciated.
Thanks in advance
Ali
Hi @acandan ,
I have encountered similar situations as you described, below a few things that may help you.
You can probably use Pulse (or TM1Top) to see the sessions running in the Server, to see whether the Performance issue might be in the cube itself.
When you open the UX report with a filter of a “big client”, do you see threads for your user with “api/v1/ExecuteMDX” running for long periods?
If you have 2 or more merged views, you may see multiple threads like below running at the same time…
If it is running for a while to calculate the Cube view, the main performance issue is likely in a rule of the model… you can also see if possible to tune MTQ, etc…
If the execution of the cube Views in the model is fast, then you may need to work on the UX side.
As a side note on that, Keep in mind that the performance of Report pages to render can vary from machine to another, as it is rendering on the local browser… so if the Browser has too many tabs open, or Windows is also doing multiple tasks, and not enough RAM is available, it could be also affecting performance, so keep an eye on the Task manager of the local machine to see if can be related.
Now, assuming that the Cube view is loaded fast on TM1 Server side, and that your machine has the browser running only with the Apliqo UX page (so you have enough capacity to process the Page), you can have a look on a few things on the Report that could be affecting performance:
-
Do you have “a lot” of columns as well? If so, one strategy could be to show more summarized data on the main page at first, and do Pop-ups for more details, instead of having “massive” views with too many columns/rows.
-
Conditional formatting that affects many of the columns/rows. if you have formatting to change/highlight background colors, etc, maybe try removing it first to see if helps on performance, then try limiting the formatting to only certain “main” columns rather than all.
-
Do you have the Option to get all attributes enabled for this report? if so, do you have large Dimensions with a lot of Attributes? that could be affecting the performance as well. you can try disabling to see if it helps.
-
Do you have one or multiple Custom formulas in the report? This for sure would affect performance when having lots of Rows in the views, if that’s the case, maybe should be calculated in the cube instead?
-
Potentially think about this main planning screen differently, this is a more broad approach, and I do not know the details of the model, but maybe you can try breaking it down into more specific sections, starting from summary info, to then show detailed info, after it was filtered, if possible.
You could also make use of the “Workflow” type of report, creating only 1 steps and break the information into 2 or 3 sub-steps.
If you hide the “Next” and “Cancel” buttons, hide the “steps bar”, it looks like 1 report “Book”, with the side tabs. I used it in a couple of cases in the past, Example below:
Hope this helps!
Rodrigo
Hi Rodrigo,
Thank you for your answer.
Unfortunately we dont have pulse. But On arc sessions, I cant see any thread as running.
- We have 37 columns. And we cant decrease it because it is their planning period.
- We dont have conditional formatting.
- “Option to get all attributes enabled” how can I check it?
- We dont have any custom formula.
- Breaking the page is not an option also, because of licensing. Instead we have more filters.
Thanks again for your support.
Hi Ali,
In the Edit mode, on the GUI you can check on Filter bar, All Attributes if it is enabled.
1 Like
