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.
