MicroStrategy ONE

Delete Schedule Relation statement

Deletes a relation between a schedule and the combination of report/HTML document, user/group and a project.

Copy
DELETE (SCHEDULERELATIONS [FOR ((LOGIN | GROUP) login_or_group_name | REPORT report_or_doc_name IN location_path | SCHEDULE schedule_name) | SCHEDULERELATION SCHEDULE schedule_name (USER | GROUP) user_or_group_name REPORT report_or_doc_name IN location_path)] FROM PROJECT project_name;

where:

  • login_or_group_name is the login name of the user/group for which one or more schedule relations is to be deleted.
  • report_or_doc_name is the name of the report/HTML document for which one or more schedule relations is to be deleted.
  • location_path is the folder path where the report/HTML document is located in the project, of type string, between double quotes (").
  • project_name is the name of the project that contains the report to be deleted from the schedule relation, of type string, between double quotes (").
  • schedule_name is the name of the schedule for which a schedule relation is to be deleted, of type string, between double quotes (").

This statement can only be executed in a Windows environment.

Examples

Copy
DELETE SCHEDULERELATIONS FOR REPORT "Revenue vs. Forecast" IN "\Public Objects\Reports" FROM PROJECT "MicroStrategy Tutorial";
Copy
DELETE SCHEDULERELATIONS FOR USER "Calvin Rosie" FROM PROJECT "MicroStrategy Tutorial";
Copy
DELETE SCHEDULERELATIONS FROM PROJECT "MicroStrategy Tutorial";