MicroStrategy ONE
Exporting the results of a script
The results of a script's execution can be viewed in the Results tab of the Script Window. (How?) Those results can be copied into another script, printed, or saved to a file. File options include text, CSV (comma-separated values), Excel format, or XML.
To use the results of a script in another script
-
On the Connection menu, point to Results, and then select a format option.
-
Execute the script whose results you want to re-use. (How?)
-
Open a second Script tab. (How?)
-
In the Results tab of the first script, select the results you wish to reuse in another script.
-
Click and drag those results into the second Script window. Or, right-click in the Results tab, select Copy, and then paste the results into the second Script window.
To print the results of a script
-
On the Connection menu, point to Results, and then select a format option.
-
Execute the script. (How?)
-
On the File menu, choose Print Results. The results are printed.
To save results to a text file
-
On the Connection menu, point to Results, and then select To File.
-
Execute the script. (How?)
-
When the Save Results dialog box opens, choose a location and file name and save the file.
To save results to a CSV (comma-separated values), Excel, or XML file
-
Execute the script. (How?)
-
From the File menu, select Export results to Excel or Export results to XML.
To export to CSV, select Export results to Excel.
-
Choose a location, file name, and file type (Excel, or CSV), and save the file.