You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Oracle EPM Planning REST API exportdata - 'PovAxisDefinition' not recognized

Hi Folks,

Oracle has recently released the Export Data REST API:

POST /HyperionPlanning/rest/v3/applications/{application}/plantypes/{plantype}/exportdata

While implementing it, I noticed that the payload structure documented in the Oracle documentation did not work in our EPBCS environment.

I started with the documented approach using:


{   
 "exportPlanningData": true,
"gridDefinition": {
"suppressMissingRows": true,
"PovAxisDefinition": {
"dimensions": [dimension1, dimension2],
"members": [dim1_mbr,dim2_mbr]
},
"ColumnAxisDefinition": [
{
"dimensions": ["Account"],
"segments": [["Cost"]]
}
],
"RowAxisDefinition": [
{
"dimensions": [ "Custom1", "Custom2"],
"segments": [[["XYZ"],["ABC"]]]
}
]
}
}

However, the API returned:

This is an invalid request. The following field is not recognized by the system: PovAxisDefinition

After further testing, I found that the API only worked when I changed the axis definition property names from the documented values to the following:

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!