Essbase Cache Settings with MaxL
Summary
Essbase Cache Settings with MaxLContent
Good Morning -
I run the following MaxL script to set the cache on one of my Essbase cubes:
alter system load application $4;
alter application $4 load database $5;
execute calculation $4.$5.'All';
alter database $4.$5 set data_cache_size 2500000000;
alter system unload application $4;
alter system load application $4;
logout;
However, it gets reverted back to a much smaller number when completed, it doesn't 'stick.' Can someone go over that process with me? Can the cache only bet set with a number that's available? Regardless of how high you set cache, will it revert back to a level that can be set?
0