Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 2 Next »

Sisense supports executing ElastiCube related commands using the Windows command line.

psm

Available Commands

Build

Build an ecube file or server hosted elasticube

Parameters:

  • filename: defines the ecube filename to be built to the target server.
  • name: defines the name of the elasticube which should be built on the target server.
  • serverAddress: defines the target server address on which the elasticube should be built.
  • mode: defines the mode in which the elasticube should be built, available modes:
  1. mode=restart: Rebuild the ElastiCube from scratch.
  2. mode=full: Rebuild the ElastiCube and accumulate data for tables marked as accumulative. This mode should only be used for accumulative builds.
  3. mode=changes: Rebuild from scratch tables that have changed in the ElastiCube schema.
  4. mode=metadataonly: Update the ElastiCube server with the ElastiCube schema, without building.

Changedatasource

Change the data source behind a psm to another data source.

Parameters:

  • file:  the prism document filename to open and convert.
  • prev: the previous data source to change from.
  • new: the new data source to change to.

Delete

Delete an elasticube from the target server

Parameters:

  • name:  defines the name of the elasticube which should be removed from the target server.
  • serverAddress: defines the target server address from which the elasticube should be removed.

Restart

Restart an elasticube on the target server.

Parameters:

  • name: defines the name of the elasticube which should be restarted.
  • serverAddress: defines the target server address on which the elasticube should be restarted.

Example:

psm ecube build filename=”c:\mycube.ecube” serverAddress=”localhost” mode=restart

Start

Start an elasticube on the target server.

Parameters:

  • name: defines the name of the elasticube which should be started.
  • serverAddress: defines the target server address on which the elasticube should be started.

Stop

Stop a running elasticube on the target server.

Parameters:

  • name: defines the name of the elasticube which should be stopped.
  • serverAddress: defines the target server address on which the elasticube should be stopped.

Attach

Attaches an ElastiCube folder to the local server.

Parameters:

  • path: defines the full path of the folder you want to attach. Example: psm.exe ecube attach path=C:\ProgramData\Sisense\PrismServer\ElastiCubeData\…
  • serverAddress (when working with a remote server): defines the address of a remote serverIf not used, the fallback value localhost will be used. Example: psm.exe ecube attach path=s:\elasticubedata\acheck1 serverAddress=192.168.1.xxx

Detach

Detaches an ElastiCube from the local server.

Parameters:

  • name: defines the name of the ElastiCube you want to detach.
  • serverAddress (when working with a remote server): defines the address of a remote serverIf not used, the fallback value localhost will be used. Example: psm.exe ecube detach name=check1 serverAddress=192.168.1.xxx

psm ex

CubeConverterExe

This command together with an executable file lets you convert ecube files to XML and vice versa. This can be useful for editing ecube parameters such as the data source name and location, table names, dimension names, etc. You can convert the .ecube file to xml, edit the .xml file using any editor, and then simply convert it back to an .ecube file.

Click here to learn more.

On this page

  • No labels