MicroStrategy ONE
Alter Report Caching statement
Modifies the properties for report caching in a project.
ALTER REPORT CACHING IN [PROJECT]
"project_name"
[(ENABLED | DISABLED)] [CACHEFILEDIR "cache_file_directory"] [MAXRAMUSAGE number_of_MB] [MAXNOCACHES number_of_caches] [RAMSWAPMULTIPLIER
multiplier] [LOADCACHESONSTARTUP
(TRUE | FALSE)] [ENABLEDOCUMENTCACHE (FALSE | ALL | (PDF | HTML
| EXCEL | XML) [, (PDF | HTML | EXCEL | XML[,..]])] [ENABLEPROMPTEDCACHING
(TRUE | FALSE)] [ENABLENONPROMPTEDCACHING (TRUE | FALSE)] [CREATECACHESPERUSER
(TRUE | FALSE)] [CREATECACHESPERDBLOGIN (TRUE | FALSE)] [CREATECACHESPERDBCONN
(TRUE | FALSE)] [CACHEEXP (NEVER | [IN] number_of_hours
HOURS)] [RECORDPROMPTANSWERS
(FALSE | TRUE)] [ENABLEXMLCACHING (TRUE | FALSE)] [FORMATTEDDOCMAXRAMCACHE
number_of_doc_MB] [FORMATTEDDOCMAXNOCACHE
number_of_doc_caches];
where:
-
PROJECT "project_name" is the name of the project in which report server caching is to be altered, of type string.
-
CACHEFILEDIR "cache_file_directory" is the directory for cache files, of type string.
-
MAXRAMUSAGE number_of_MB is the maximum number of megabytes to be used in RAM for report caching, of type integer.
-
MAXNOCACHES number_of_caches is the maximum number of report caches to be stored, of type integer.
Beginning with MicroStrategy 2020 Update 1, this governing setting is being retired. It will remain available, but the setting will not be enforced if set below the default value of 100000.
-
RAMSWAPMULTIPLIER multiplier is the RAM swap multiplier for the caches, of type integer.
-
LOADCACHESONSTARTUP indicates whether to load caches when the project is loaded.
-
ENABLEDOCUMENTCACHE indicates whether to enable document caching.
-
ENABLEPROMPTEDCACHING indicates whether to enable prompted caching.
-
ENABLENONPROMPTEDCACHING indicates whether to enable non-prompted caching.
-
CREATECACHESPERUSER indicates whether to create separate caches for each user.
-
CREATECACHESPERDBLOGIN indicates whether to create separate caches for each DBLogin.
-
CREATECACHESPERDBCONN indicates whether to create separate caches for each DBConnection
-
CACHEEXP indicates when to expire caches:
-
NEVER does not ever expire caches.
-
HOURS number_of_hours is the duration that the report cache is to have, of type integer.
Beginning with MicroStrategy 2020 Update 1, this governing setting is being retired. It will remain available, but the setting will not be enforced if set below the default value of 24.
-
RECORDPROMPTANSWERS indicates whether to record prompt answers with the cache.
-
ENABLEXMLCACHING indicates whether to enable XML caching for MicroStrategy Web.
-
FORMATTEDDOCMAXRAMCACHE number_of_doc_MB is the maximum number of megabytes to be used in RAM for document caching, of type integer.
-
FORMATTEDDOCMAXNOCACHE number_of_doc_caches is the maximum number of document caches to be stored, of type integer.
This statement can only be used with three-tier or four-tier project source names.
Example
ALTER REPORT
CACHING IN PROJECT "MicroStrategy Tutorial" ENABLED CACHEFILEDIR
".\Caches\JSMITH4" MAXRAMUSAGE 100 CREATECACHESPERUSER FALSE
CACHEEXP IN 24 HOURS MAXNOCACHES 10000;