MicroStrategy ONE
Testing a procedure against a project source
Once you have written a procedure, you can test it by executing it against a project source. You provide a project source and login information, and values for all the procedure's inputs, and Command Manager executes the procedure.
The login you provide must have the Use Command Manager privilege, and the usual privileges for any system maintenance tasks the procedure performs. For information on user privileges, see the Setting Up User Security chapter of the MicroStrategy System Administration Guide.
To test a procedure
- In Command Manager, compose or open a procedure.
- Select the Test Information tab.
- In the Values column of the Inputs for execution list, enter a value for each input. These values are used when you execute the procedure.
- From the Project Source drop-down list, select the project source you want to test the procedure against.
- In the Login Id and Password fields, enter the user name and password you wish to use to connect to the project source.
- Click Connect to connect to the project source.
- To execute the procedure against this project source, with the specified inputs, from the Connection menu select Execute. The procedure executes.