Deletion of values of process instance-independent data series

You can delete values of process instance-independent data series in the PPM system using the command line program runpikidata. To do so, use the command line arguments -mode delete and -pikicube <cube name>[,<cube name>,...] to specify the data series from which you want to delete values.

By default, all values of the specified PIKI cubes are deleted.
You can limit the data rows of a data series to be deleted by specifying a paramset that contains a filter on a referenced dimension of the data series, for example. To do this, enter the name of the paramset file using the -ps parameter.

If the delete paramset contains dimension filters that are not included as referenced dimensions in the definition of the specified data series an error message is output when you run the program. The PPM user performing the operation requires the Data import function privilege.

Example

You want to delete import values of the data series with the internal identifier PC_SALES (PIKI cube Sales) in the time period of the 1st quarter in 2009.
In the analysis, set a delete paramset with the corresponding time filter and export it to a local XML file. Then call up the runpikidata command line program as follows:

runpikidata -client <ppmclient> -user <username> -password <password> -pikicube PC_SALES -mode delete -ps <deleteparamset>.xml