Since a few releases ago, Oracle has introduced native connectors that connect Oracle Analytics to Oracle EPM Application. That way, planning data from Oracle EPM Cloud can be retrieved into Oracle Analytics for reporting and analysis. However, this was just a first step in to EPM/Essbase world. There are several others required as well, for example: Support for EPM Cloud/Essbase data sources in Semantic Modeler: this hasn't been provided yet, however we can expect it in January 2025 release of Oracle Analytics Cloud. Substitution Variables can not be imported directly with the data. But there is an option to use REST API to get all of these variables. Selection Steps is a functionality known from "classic" Oracle Analytics (Dashboards and Answers) where users can select specific member of the hierarchy and display only its descendants based on hierarchy or similar relationship (ie. leaves of hierarchy). This post is about retrieving Substitution Variables using R...
Oracle Analytics & Data Science