MicroStrategy ONE
Platform Analytics 프로젝트 구성 스크립트
구성 마법사는 프로젝트 생성 또는 업그레이드 프로세스 중에 아래 나열된 적절한 스크립트를 적용합니다.
새 프로젝트 생성
새 프로젝트 생성 시 MySQL DSN을 선택하는 경우:
구성 마법사가 적용됩니다. 플랫폼분석구성New.scp:
복사
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";
새 프로젝트 생성 시 PostgreSQL DSN을 선택하는 경우:
구성 마법사가 적용됩니다. PlatformAnalyticsConfigurationNew_PostgreSQL.scp:
복사
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";
프로젝트 업그레이드
Platform Analytics 프로젝트를 업그레이드하는 동안 MySQL DSN을 선택하는 경우:
구성 마법사가 적용됩니다. PlatformAnalyticsConfigurationUpgrade.scp:
복사
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";
Platform Analytics 프로젝트를 업그레이드하는 동안 PostgreSQL DSN을 선택하는 경우:
구성 마법사가 적용됩니다. PlatformAnalyticsConfigurationUpgrade_PostgreSQL.scp:
복사
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";