Get Derived Substitution Variables at the Plan Type Level

Can be used to retrieve a list of derived substitution variables at the plan type level.

Rest Resource

GET       /HyperionPlanning/rest/{api_version}/applications/{application}/plantypes/{plan}/substitutionvariables?q={"derivedValues":true}

Request

Supported Media Types: application/json

Parameters

The following table summarizes the client request.

Table 5-75 Parameters

Name Description Type Required Default
api_version Version of the API you are developing with Path Yes None
application The name of the application Path Yes None
plantype Name of the plan type for which to get substitution variables Path Yes None
q Options for returning derived values, as described in the following row Query No  
derivedValues

If set to true, the derived list shows all variables available at run time to be used against the plan type. This includes variables defined at the application level and at the plan type level.

If a substitution variable with the same name is defined both at the plan type level and at the application level, the plan type level is returned.

Query No derivedValues = true when getting derived substitution variables

Example URL

https://<SERVICE_NAME>-<TENANT_NAME>.<SERVICE_TYPE>.<dcX>.oraclecloud.com/HyperionPlanning/rest/v3/applications/Vision/plantypes/Plan1/substitutionvariables?q={"derivedValues":true}

Response

Supported Media Types: application/json

Parameters

The following table summarizes the parameters.

Table 5-76 Parameters

Name Description
items Collection of information about the resource
name Name of the substitution variable, such as CurrYear
value Value of the substitution variable, such as FY16
planType Name of the plan type, such as Plan1, or ALL for all plan types

Example of Response Body

The following shows an example of the response body.

{
    "items": [{
        "name": "CurrYear",
        "value": "FY16",
        "planType": "ALL"
    }, {
        "name": "CurrPeriod",
        "value": "Jan",
        "planType": "Plan1"
    }]
}