Get Derived Substitution Variables at the Plan Type Level

You can use REST APIs to retrieve a list of derived substitution variables at the plan type level.

Required Roles

Service Administrator, Power User (with Rule Launch access)

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 8-83 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 8-84 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"
    }]
}