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

[Anonymous]

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.

[olivierrobin]

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 ?

[marcus_sommer]

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