Skip to main content

Posts

Showing posts from December, 2024

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

Since a few releases ago, Oracle has introduced native connectors that link Oracle Analytics to Oracle EPM Applications. This integration enables planning data from Oracle EPM Cloud to be seamlessly retrieved into Oracle Analytics for reporting and analysis. However, this initial step only scratches the surface of the EPM/Essbase ecosystem. Several additional capabilities are needed to fully leverage these data sources, including: Support for EPM Cloud/Essbase data sources in the Semantic Modeler: This feature is not yet available but is expected in the January 2025 release of Oracle Analytics Cloud. Direct import of Substitution Variables with data is not currently supported. However, REST API provides a way to retrieve all substitution variables. Selection Steps, a functionality familiar from "classic" Oracle Analytics (Dashboards and Answers), allows users to select specific hierarchy members and display only their descendants based on hierarchical or similar relation...

My Presentation @ UKOUG 2024

In the beginning of December, I attended UKOUG Annual Conference DISCOVER 2024 in Birmingham. I was presenting there and I am said (or perhaps not) to share this information, but this was my last time I was presenting under Version 1 / Qubix umbrella. Our paths are finally splitting at the end of this year and I will share more in my future posts. Back to my presentation in Birmingham.   Depending on the existing / future architecture OCI users have various option to choose from. The question is which ML approach is the most suitable for a specific user? And among these, some could be quite interesting. For example, which solution could be the best fit if customer still prefers to stay on-premise or what if data is fluent. So, what options have we got in OCI? In my presentation titled  3 Case Studies: Machine Learning in OCI , I am trying to answer some of the questions mentioned about and I am discussing development and deployment options that we have in Oracle Clou...