Latest Oracle EPM REST APIs: Part 1 Dimension Details
I will be writing a series of articles about the newest REST APIs available in Oracle EPM Instances. Beginning 26.04 (April 2026), Oracle has started to introduce many more APIs that makes it easy for us to interact with Oracle EPM Applications.
There is no doubt these are geared towards AI Agents, MCP Server and in general making it easy for AI apps to interact with Oracle EPM. This will be Part 1 of the series. I will be making videos as well.
With that lets get strated with the API to get the Dimension Details.
Latest EPM REST APIs
The below are the REST APIs I want to cover in my articles and vidoes.
We will start with Get Dimension Details API.
Get Dimension Details API
I am particularly excited about this one becuse we can get the dimension deails - the hierarchy, parent, children, alias in json format. I don't know about you, but I haven't been this excited about an EPM REST API in a looooong time!!
Ok Lets see how we use this.
API end Point: /HyperionPlanning/rest/v3/applications/{appName}/plantypes/{planType}/dimensions/{dimension}
You need to provide the following details
Application Name
Plan Type / Cube Name
Dimension Name
REST API Response
Let's examine the REST API response.
dimType: The type of dimension this is - Custom / Standard / Attribute
dimName: Projects
density: Sparse
usedIn: the cubes in which the dimension is being used. This an extremely useful information.
Let's look at another screenshot where we take a closer look at the members of the dimension:
It shows you the following information:
Hierarchy in a few different ways: using the Path, Alias Path, parentName, and id and parentId fields
the member level
the alias
cubes in which the member is being used
generation
dataStorage
Conclusion
The new REST API allows us to get all the members and member information of a given dimension. And the best thing is the respose is in JSON format.
I am exicted to show you the other EPM REST APIs soon.
What are your thoughts about the new REST APIs? Let me know your thoughts.
