Integration Services Shell is a command-line tool that enables you to access Integration Server to perform operations on an Essbase outline and the data in anEssbase database.
With Integration Services Shell, you can perform server operations at the command line in either batch or interactive mode.
Batch mode. To automate routine server maintenance and diagnostic tasks, write a script or batch file and run it from the command line.
Batch mode is convenient if you use a particular series of commands frequently or if the task requires many commands.
Interactive mode. To perform tasks interactively, enter OLAP commands at the command line.
Interactive mode is convenient for short operations that require few commands, such as checking for information on the fly and error checking.
It can be difficult to enter commands correctly when using the command line. The easiest method is to use the Integration Services Console OLAP Metaoutline standard user interface to perform a data or member load, and then choose to create a script file. You can then edit the script file as needed. Run all the commands in a script file by redirecting the standard input to use your command file. See Running OLAP Command Script Files. |