Archive: Žiga Vaupot's Blog

Clear filter — back to home
Retrieving Substitution Variables from Oracle EPM Planning into OAC using REST API

Retrieving Substitution Variables from Oracle EPM Planning into OAC using REST API

Oracle EPM Cloud's native connectors don't let you pull substitution variables directly into Oracle Analytics — so in this post I show how to bridge that gap using the EPM REST API. I walk through creating a REST API connection, building a dataset from it, and binding a workbook parameter to a substitution variable value like LastYr for dynamic filtering.

Read more