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:
1