Scenario:
I have a server with many cubes. Half the cubes are used only once or twice a month. Sisense tech support said an elasticube will "keep its data in memory for fast query access". That means I have to provision the server with enough RAM to hold all cubes, even the rarely-used ones.
Goals:
I want to provision RAM for the expected level of use. E.g. I expect 60% of the cubes to be used each day. Also, if I have under-provisioned my server, I don't want it to crash (memory safe mode). Instead, I want rarely-used cubes to slow down until I provide more RAM.
Solution:
There is an existing feature that can help: I can set cubes to unload from RAM if unused for more than one day.
I'd like a better way: When Sisense detects high RAM use, I want it to list cubes by last-queried date and unload the oldest ones.
My way, the unload happens only when necessary, not daily. It "softens" the impact of insufficient RAM by making it slow down the least important cubes instead of crashing.