MicroStrategy ONE
Platform Analytics Project Configuration Scripts
The Configuration Wizard will apply the appropriate script listed below during the project creation or upgrade process.
New Project Creation
When selecting a MySQL DSN on a new project creation:
Configuration Wizard will apply PlatformAnalyticsConfigurationNew.scp:
Copy
ALTER PROJECT CONFIGURATION USEWHLOGINEXEC FALSE MAXREPORTEXECTIME 3600 MAXSCHEDULEREPORTEXECTIME 3600 MAXNOINTELLIGENTCUBERESULTROWS -1 MAXNOREPORTRESULTROWS -1 MAXNOINTRESULTROWS -1 MAXQUOTAIMPORT 20480 INTELLIGENTCUBEMAXRAM 20480 DATAFETCHINGMEMORY 20480 NULLDISPLAYWAREHOUSE "N/A" NULLDISPLAYCROSSTABULATOR "N/A" IN PROJECT "Platform Analytics";
ALTER PROJECT "Platform Analytics" DESCRIPTION "Platform Analytics (Version 2021 Update 11)";
ALTER DBINSTANCE "Platform Analytics" LOWTHREADS 8;
ALTER VLDBSETTING PROPERTYNAME "Parallel Query Execution" PROPERTYVALUE "2" , PROPERTYNAME "Maximum Parallel Queries Per Report" PROPERTYVALUE "8" FOR PROJECT "Platform Analytics";
ALTER VLDBSETTING PROPERTYNAME "Report Pre Statement 1" PROPERTYVALUE "SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED ;", PROPERTYNAME "Report Post Statement 1" PROPERTYVALUE "COMMIT;" FOR DBINSTANCE "Platform Analytics" ;
ALTER PASTATISTICS BASICSTATS ENABLED DETAILEDREPJOBS FALSE DETAILEDDOCJOBS FALSE JOBSQL FALSE COLUMNSTABLES FALSE IN PROJECT "Platform Analytics";
CREATEIFNOTEXIST SCHEDULE "PlatformAnalytics_Every_Hour_00" STARTDATE 08/01/2017 ENDDATE NEVER TYPE TIMETRIGGERED DAILY EVERY WEEKDAY EXECUTE ALL DAY EVERY 60 MINUTES STARTTIME 00:00;
CREATEIFNOTEXIST SCHEDULE "PlatformAnalytics_Every_Hour_10" STARTDATE 08/01/2017 ENDDATE NEVER TYPE TIMETRIGGERED DAILY EVERY WEEKDAY EXECUTE ALL DAY EVERY 60 MINUTES STARTTIME 00:10;
CREATEIFNOTEXIST SCHEDULE "PlatformAnalytics_Every_Hour_20" STARTDATE 08/01/2017 ENDDATE NEVER TYPE TIMETRIGGERED DAILY EVERY WEEKDAY EXECUTE ALL DAY EVERY 60 MINUTES STARTTIME 00:20;
CREATEIFNOTEXIST SCHEDULE "PlatformAnalytics_Every_Hour_30" STARTDATE 08/01/2017 ENDDATE NEVER TYPE TIMETRIGGERED DAILY EVERY WEEKDAY EXECUTE ALL DAY EVERY 60 MINUTES STARTTIME 00:30;
CREATEIFNOTEXIST CACHEUPDATESUBSCRIPTION "Compliance Telemetry Cube Every Hour_00" FOR OWNER "Administrator" SCHEDULE "PlatformAnalytics_Every_Hour_00" USER "Administrator" CONTENT GUID 0FF99AD811E880872E300080EF45AF4F IN PROJECT "Platform Analytics";
CREATEIFNOTEXIST CACHEUPDATESUBSCRIPTION "Communicator Inbox Messages Cube Every Hour_10" FOR OWNER "Administrator" SCHEDULE "PlatformAnalytics_Every_Hour_10" USER "Administrator" CONTENT GUID 0A5C499011E74AE6000000802F870D74 IN PROJECT "Platform Analytics";
CREATEIFNOTEXIST CACHEUPDATESUBSCRIPTION "Remote Diagnostic Cube Every Hour_20" FOR OWNER "Administrator" SCHEDULE "PlatformAnalytics_Every_Hour_20" USER "Administrator" CONTENT GUID 0C73984111E863782D6F0080EFE5EF4E IN PROJECT "Platform Analytics";
CREATEIFNOTEXIST CACHEUPDATESUBSCRIPTION "Platform Analytics Cube Every Hour_30" FOR OWNER "Administrator" SCHEDULE "PlatformAnalytics_Every_Hour_30" USER "Administrator" CONTENT GUID 7C5CD53E11E529671FB700802FF7BD86 IN PROJECT "Platform Analytics";
TRIGGER SUBSCRIPTION "Platform Analytics Cube Every Hour_30" MANAGE ALL OWNER "Administrator" FOR PROJECT "Platform Analytics";
TRIGGER SUBSCRIPTION "Communicator Inbox Messages Cube Every Hour_10" MANAGE ALL OWNER "Administrator" FOR PROJECT "Platform Analytics";
TRIGGER SUBSCRIPTION "Remote Diagnostic Cube Every Hour_20" MANAGE ALL OWNER "Administrator" FOR PROJECT "Platform Analytics";
TRIGGER SUBSCRIPTION "Compliance Telemetry Cube Every Hour_00" MANAGE ALL OWNER "Administrator" FOR PROJECT "Platform Analytics";
ALTER VLDBSETTING PROPERTYNAME "Intermediate Table Type" PROPERTYVALUE "3" FOR DBINSTANCE "Platform Analytics" ;
ADD ACE FOR DOCUMENT "Object Embedded Dossier" COMBINEACEFORTRUSTEE IN FOLDER "\Public Objects\Templates" GROUP "System Monitors" ACCESSRIGHTS VIEW FOR PROJECT "Platform Analytics";
ADD ACE FOR DOCUMENT "Project Embedded Dossier" COMBINEACEFORTRUSTEE IN FOLDER "\Public Objects\Templates" GROUP "System Monitors" ACCESSRIGHTS VIEW FOR PROJECT "Platform Analytics";
CREATEIFNOTEXIST CACHEUPDATESUBSCRIPTION "Dimensions Cube Every Hour_00" FOR OWNER "Administrator" SCHEDULE "PlatformAnalytics_Every_Hour_00" USER "Administrator" CONTENT GUID 78134AB0464000DF758DCF818AE97491 IN PROJECT "Platform Analytics";
When selecting a PostgreSQL DSN on a new project creation:
Configuration Wizard will apply PlatformAnalyticsConfigurationNew_PostgreSQL.scp:
Copy
ALTER PROJECT CONFIGURATION USEWHLOGINEXEC FALSE MAXREPORTEXECTIME 3600 MAXSCHEDULEREPORTEXECTIME 3600 MAXNOINTELLIGENTCUBERESULTROWS -1 MAXNOREPORTRESULTROWS -1 MAXNOINTRESULTROWS -1 MAXQUOTAIMPORT 20480 INTELLIGENTCUBEMAXRAM 20480 DATAFETCHINGMEMORY 20480 NULLDISPLAYWAREHOUSE "N/A" NULLDISPLAYCROSSTABULATOR "N/A" IN PROJECT "Platform Analytics";
ALTER PROJECT "Platform Analytics" DESCRIPTION "Platform Analytics (Version 2021 Update 11)";
ALTER DBINSTANCE "Platform Analytics" LOWTHREADS 8;
ALTER VLDBSETTING PROPERTYNAME "Parallel Query Execution" PROPERTYVALUE "2" , PROPERTYNAME "Maximum Parallel Queries Per Report" PROPERTYVALUE "8" FOR PROJECT "Platform Analytics";
ALTER PASTATISTICS BASICSTATS ENABLED DETAILEDREPJOBS FALSE DETAILEDDOCJOBS FALSE JOBSQL FALSE COLUMNSTABLES FALSE IN PROJECT "Platform Analytics";
CREATEIFNOTEXIST SCHEDULE "PlatformAnalytics_Every_Hour_00" STARTDATE 08/01/2017 ENDDATE NEVER TYPE TIMETRIGGERED DAILY EVERY WEEKDAY EXECUTE ALL DAY EVERY 60 MINUTES STARTTIME 00:00;
CREATEIFNOTEXIST SCHEDULE "PlatformAnalytics_Every_Hour_10" STARTDATE 08/01/2017 ENDDATE NEVER TYPE TIMETRIGGERED DAILY EVERY WEEKDAY EXECUTE ALL DAY EVERY 60 MINUTES STARTTIME 00:10;
CREATEIFNOTEXIST SCHEDULE "PlatformAnalytics_Every_Hour_20" STARTDATE 08/01/2017 ENDDATE NEVER TYPE TIMETRIGGERED DAILY EVERY WEEKDAY EXECUTE ALL DAY EVERY 60 MINUTES STARTTIME 00:20;
CREATEIFNOTEXIST SCHEDULE "PlatformAnalytics_Every_Hour_25" STARTDATE 08/01/2017 ENDDATE NEVER TYPE TIMETRIGGERED DAILY EVERY WEEKDAY EXECUTE ALL DAY EVERY 60 MINUTES STARTTIME 00:25;
CREATEIFNOTEXIST SCHEDULE "PlatformAnalytics_Every_Hour_30" STARTDATE 08/01/2017 ENDDATE NEVER TYPE TIMETRIGGERED DAILY EVERY WEEKDAY EXECUTE ALL DAY EVERY 60 MINUTES STARTTIME 00:30;
CREATEIFNOTEXIST CACHEUPDATESUBSCRIPTION "Compliance Telemetry Cube Every Hour_00" FOR OWNER "Administrator" SCHEDULE "PlatformAnalytics_Every_Hour_00" USER "Administrator" CONTENT GUID 0FF99AD811E880872E300080EF45AF4F IN PROJECT "Platform Analytics";
CREATEIFNOTEXIST CACHEUPDATESUBSCRIPTION "Communicator Inbox Messages Cube Every Hour_10" FOR OWNER "Administrator" SCHEDULE "PlatformAnalytics_Every_Hour_10" USER "Administrator" CONTENT GUID 0A5C499011E74AE6000000802F870D74 IN PROJECT "Platform Analytics";
CREATEIFNOTEXIST CACHEUPDATESUBSCRIPTION "Remote Diagnostic Cube Every Hour_20" FOR OWNER "Administrator" SCHEDULE "PlatformAnalytics_Every_Hour_20" USER "Administrator" CONTENT GUID 0C73984111E863782D6F0080EFE5EF4E IN PROJECT "Platform Analytics";
CREATEIFNOTEXIST CACHEUPDATESUBSCRIPTION "Platform Analytics Cube Every Hour_30" FOR OWNER "Administrator" SCHEDULE "PlatformAnalytics_Every_Hour_30" USER "Administrator" CONTENT GUID 7C5CD53E11E529671FB700802FF7BD86 IN PROJECT "Platform Analytics";
CREATEIFNOTEXIST CACHEUPDATESUBSCRIPTION "Capacity Planning Cube Every Hour_25" FOR OWNER "Administrator" SCHEDULE "PlatformAnalytics_Every_Hour_25" USER "Administrator" CONTENT GUID 62F592B111E9C8DDAF600080EF15494D IN PROJECT "Platform Analytics";
TRIGGER SUBSCRIPTION "Platform Analytics Cube Every Hour_30" MANAGE ALL OWNER "Administrator" FOR PROJECT "Platform Analytics";
TRIGGER SUBSCRIPTION "Communicator Inbox Messages Cube Every Hour_10" MANAGE ALL OWNER "Administrator" FOR PROJECT "Platform Analytics";
TRIGGER SUBSCRIPTION "Remote Diagnostic Cube Every Hour_20" MANAGE ALL OWNER "Administrator" FOR PROJECT "Platform Analytics";
TRIGGER SUBSCRIPTION "Compliance Telemetry Cube Every Hour_00" MANAGE ALL OWNER "Administrator" FOR PROJECT "Platform Analytics";
TRIGGER SUBSCRIPTION "Capacity Planning Cube Every Hour_25" MANAGE ALL OWNER "Administrator" FOR PROJECT "Platform Analytics";
ALTER VLDBSETTING PROPERTYNAME "Intermediate Table Type" PROPERTYVALUE "3" FOR DBINSTANCE "Platform Analytics" ;
ADD ACE FOR DOCUMENT "Object Embedded Dossier" COMBINEACEFORTRUSTEE IN FOLDER "\Public Objects\Templates" GROUP "System Monitors" ACCESSRIGHTS VIEW FOR PROJECT "Platform Analytics";
ADD ACE FOR DOCUMENT "Project Embedded Dossier" COMBINEACEFORTRUSTEE IN FOLDER "\Public Objects\Templates" GROUP "System Monitors" ACCESSRIGHTS VIEW FOR PROJECT "Platform Analytics";
CREATEIFNOTEXIST CACHEUPDATESUBSCRIPTION "Dimensions Cube Every Hour_00" FOR OWNER "Administrator" SCHEDULE "PlatformAnalytics_Every_Hour_00" USER "Administrator" CONTENT GUID 78134AB0464000DF758DCF818AE97491 IN PROJECT "Platform Analytics";
Project Upgrades
When selecting a MySQL DSN while upgrading the Platform Analytics project:
Configuration Wizard will apply PlatformAnalyticsConfigurationUpgrade.scp:
Copy
ALTER PROJECT "Platform Analytics" DESCRIPTION "Platform Analytics (Version 2021 Update 11)";
ALTER VLDBSETTING PROPERTYNAME "Intermediate Table Type" PROPERTYVALUE "3" FOR DBINSTANCE "Platform Analytics" ;
ALTER PROJECT CONFIGURATION NULLDISPLAYWAREHOUSE "N/A" NULLDISPLAYCROSSTABULATOR "N/A" IN PROJECT "Platform Analytics";
ADD ACE FOR DOCUMENT "Object Embedded Dossier" COMBINEACEFORTRUSTEE IN FOLDER "\Public Objects\Templates" GROUP "System Monitors" ACCESSRIGHTS VIEW FOR PROJECT "Platform Analytics";
ADD ACE FOR DOCUMENT "Project Embedded Dossier" COMBINEACEFORTRUSTEE IN FOLDER "\Public Objects\Templates" GROUP "System Monitors" ACCESSRIGHTS VIEW FOR PROJECT "Platform Analytics";
CREATEIFNOTEXIST CACHEUPDATESUBSCRIPTION "Dimensions Cube Every Hour_00" FOR OWNER "Administrator" SCHEDULE "PlatformAnalytics_Every_Hour_00" USER "Administrator" CONTENT GUID 78134AB0464000DF758DCF818AE97491 IN PROJECT "Platform Analytics";
When selecting a PostgreSQL DSN while upgrading the Platform Analytics project:
Configuration Wizard will apply PlatformAnalyticsConfigurationUpgrade_PostgreSQL.scp:
Copy
ALTER PROJECT "Platform Analytics" DESCRIPTION "Platform Analytics (Version 2021 Update 11)";
CREATEIFNOTEXIST SCHEDULE "PlatformAnalytics_Every_Hour_25" STARTDATE 08/01/2017 ENDDATE NEVER TYPE TIMETRIGGERED DAILY EVERY WEEKDAY EXECUTE ALL DAY EVERY 60 MINUTES STARTTIME 00:25;
CREATEIFNOTEXIST CACHEUPDATESUBSCRIPTION "Capacity Planning Cube Every Hour_25" FOR OWNER "Administrator" SCHEDULE "PlatformAnalytics_Every_Hour_25" USER "Administrator" CONTENT GUID 62F592B111E9C8DDAF600080EF15494D IN PROJECT "Platform Analytics";
TRIGGER SUBSCRIPTION "Capacity Planning Cube Every Hour_25" MANAGE ALL OWNER "Administrator" FOR PROJECT "Platform Analytics";
ALTER VLDBSETTING PROPERTYNAME "Intermediate Table Type" PROPERTYVALUE "3" FOR DBINSTANCE "Platform Analytics" ;
ALTER PROJECT CONFIGURATION NULLDISPLAYWAREHOUSE "N/A" NULLDISPLAYCROSSTABULATOR "N/A" IN PROJECT "Platform Analytics";
ALTER VLDBSETTING PROPERTYNAME "Report Pre Statement 1" DEFAULTVALUE, PROPERTYNAME "Report Post Statement 1" DEFAULTVALUE FOR DBINSTANCE "Platform Analytics" ;
ADD ACE FOR DOCUMENT "Object Embedded Dossier" COMBINEACEFORTRUSTEE IN FOLDER "\Public Objects\Templates" GROUP "System Monitors" ACCESSRIGHTS VIEW FOR PROJECT "Platform Analytics";
ADD ACE FOR DOCUMENT "Project Embedded Dossier" COMBINEACEFORTRUSTEE IN FOLDER "\Public Objects\Templates" GROUP "System Monitors" ACCESSRIGHTS VIEW FOR PROJECT "Platform Analytics";
CREATEIFNOTEXIST CACHEUPDATESUBSCRIPTION "Dimensions Cube Every Hour_00" FOR OWNER "Administrator" SCHEDULE "PlatformAnalytics_Every_Hour_00" USER "Administrator" CONTENT GUID 78134AB0464000DF758DCF818AE97491 IN PROJECT "Platform Analytics";