The power of the Alteryx Analytic Process Automation (APA) Platform combined with the data accessibility of ExoInsight form a seamless integration from Oracle Essbase and Oracle PBCS to Alteryx, enabling the user to focus on the value the data provides while taking full advantage of the Alteryx APA to unify analytics, data science, ML, and process automation.
With Alteryx APA you can easily prepare, blend, and analyze local and cloud data from multiple sources in repeatable workflows. The result is the complete automation of analytic processes by eliminating manual tasks and hand-offs, delivering business outcomes in minutes. Get started with your 14-day free trial of Alteryx Designer.
ExoInsight enables connectivity from Alteryx to Essbase, giving you the ability to access your Oracle Essbase, HFM, PBCS, FCCS data and hierarchies directly from Alteryx. Check out the video for a demo.
The Alteryx SSAS Connector by Casabase Software gives you the ability to access data and hierarchies directly from your tabular and multidimensional Analysis Services cubes in Alteryx. Check out the video for a demo.
With the Oracle Essbase, Oracle HFM, Oracle PBCS, and Oracle FCCS connectivity for Alteryx provided by ExoInsight, you no longer need to create complicated extract processes from the source system to land the data somewhere you can access. There are no extract or report objects to create or maintain within Essbase, HFM, PBCS, or FCCS.
Simply add the plug-in to your Alteryx workflow and you’re off and running pulling in your data and hierarchies.
Easily pull and combine data from different cubes into a singular dataset for downstream processes. Merge your forecast from your people planning cube with actuals from your P&L cube to see how a reorganization is going to impact EBITDA. Pull key drivers from your statistics cube to seed your budget.
The possibilities Alteryx and ExoInsight provide for your data are endless.
Pulling your metadata and hierarchies out of your Essbase, HFM, PBCS, and FCCS data sources has never been easier. Want to see what your relational data would look like against an existing hierarchy? Simply pull your hierarchy from your source and join it with your relational source in Alteryx to start analyzing your data as you’ve never been able to before.
ExoInsight’s proprietary POV String query language makes it easy for anyone to specify the data required from their Essbase, HFM, PBCS, and FCCS data sources.
Whether you’re a seasoned Essbase/HFM/PBCS/FCCS pro or have never logged in at all, you’ll have no problem getting the data you need.