topic How can i prevent BI service from running out of server memory!!! in QlikView

How can i prevent BI service from running out of server memory!!!

Anonymous — Fri, 23 Mar 2018 09:09:14 GMT

Hi everyone, my question is as follows:

i have a qvw file, which size is about 500M, and i create a ad hoc table in it , the screenshot as follows:

in this table, there are so many dimensions and kpis, and some expressions of these kpis are very complex. when i publish it on the server, some users like to cross the dimension ，such as the above the screenshot. in such a situation, if the transverse field has so many values (probably thousands of ), it always drained the memory of the server when generating the report, and cause no one to access the bi server again.

So I'd like to ask the gods in the forum, who has good advice to give me, to avoid this situation that "no connection to server", thank you first.

Re: How can i prevent BI service from running out of server memory!!!

olivierrobin — Fri, 23 Mar 2018 16:58:28 GMT

hello

the question i would ask is :

are users able to treat such an amount of data presented that way ?

can't you force them to make some selections before showing that table ?

Re: How can i prevent BI service from running out of server memory!!!

marcus_sommer — Sat, 24 Mar 2018 12:55:09 GMT

I think the only way will be to implement conditions within the object and/or the dimensions and/or the expressions with something like: if(count(distinct Dim1&Dim2&Dim3) > 250, false(), true()). If you apply this within dimensions and expressions you should inform (maybe within the title or a separate textbox) the user that a filter is applied and why to not confuse them more as necessary because the dimensions and expressions may hiding or popup quite unexpectedly for the users.

Therefore it might provide a better usability to use several specialized objects (maybe within a container) which are designed in a way that the max. RAM consumption is limited.

- Marcus