Schema Management
In the monitoring WEB application, the schemas tab allows you to access loaded and unloaded schemas/cubes. From there, you can load, reload them. This is the place as well to undeploy schemas : un-deploying a schema means to remove from the server the XML definition file of this schema. Schemas deployed and on error are accessible from the "To Load" tab; the list of errors is available from there as well.
Statistics
For each loaded schema, you'll have access to a bunch of dimensions and cubes statistics (e.g., number of members, number of cells, RAM usage, cube sparsity, etc...).
XMLA Commands
Schemas can be loaded/unloaded using XMLA commands. For the sake of simplicity these commands are regular XMLA <Execute> statements. The return dataset contains a single cell of type string containing the status of the operation. In case of error more details is available through the monitoring WEB interface.
Three commands are currently available:
- LOAD_SCHEMA schema_name
- RELOAD_SCHEMA schema_name
- UNLOAD_SCHEMA schema_name
From which you can expect the following status:
- OK
- ERROR
- ERROR_SCHEMA_LOADED
- ERROR_SCHEMA_LOADING
The XMLA client library is containing an example of these requests. For more details have a look to the class : XmlaSchemasClientExample.
Next chapter: Schema Scheduler is giving an overview of the embedded scheduler features.