QPR Knowledge Base


Hide Navigation Pane


Previous topic Next topic No expanding text in this topic  


Previous topic Next topic JavaScript is required for expanding text Mail us feedback on this topic!  

Comments (...)

Revision history:

Introduced in QPR 8.1

Last changed in QPR 8.1 SP1


Set statuses for one or more elements/periods/series.




SCModel.SetStatuses(ElementId, Statuses)




ElementId: Integer. If this is 0, the Statuses array must contain columns for measure symbol and scorecard symbol.

Statuses: Two-dimensional array with either 3 or 5 columns depending on the value of ElementId. The array can contain one or more rows with the following format:

Measure symbol. String. Supplied only if ElementId = 0.
Scorecard symbol. String. Supplied only if ElementId = 0.
Series symbol. String. Symbol of the series for which status is set.
Date. String. Date to determine for which period the status is set. You can define the date in three ways: By period index, by period name, or by date. To define a period index, prefix the value with a #, i.e. "#5" would make the value to be set for the fifth period. To define the target period by the period name, prefix the value with a $, e.g. "$Q3/2009". To define the period by a date, input the date without any special control characters. Date strings are first interpreted using the system locale formatting settings, and in the case that fails, using the ISO standard settings (yyyy-mm-dd hh:mm:ss).
Status: String. Name of the status to set. If this is empty, the existing status is cleared.


Required Rights:


Administrator or Model Administrator rights to the SCModel.


Return Values:

Below are listed the return values that this function can return:












Example Procedure:


iRet = SCModel.SetStatuses(id, arrStatuses)


Comments (...)