Hi, I run a finance systems team, and have implemented a tableau deployment, and am in the middle of implementing Oracles cloud based EPBCS Planning (cloud based Hyperion). We want to use Tableau for data visualisation as the dashboard of capabilities in EPBCS are quite basic. It would be good to connect with anyone else who has done this/thinking of doing it to share ideas/ways to integrate. Things on my mind are:
- I have seen mixed responses in the forums and online to if you can connect tableau to cloud based oracle products - I am still not sure how possible it is. I have tried but haven’t had success as of yet.
- I am debating if it would be better to use a .txt to get EPBCS data into tableau, since it will only be updated monthly, and will mean we could retain full tableau functionality vs connecting to a cube - has anyone else done this?
- Use of cube data sources in tableau - i know some of the key functionality is not available with connecting to cubes - it would be good to understand how others have done this and what it is like to use cube data in tableau.
Be good to connect with anyone that can offer some good counsel/ thoughts.
thanks,
Hi,
I supose you can connect directly to the cube using the Oracle Essbase Driver.
I actually have got visualizations connected to Essbase as dataSource (Essbase on premises).
If you use Essbase as DataSource you cannot use Tableau extracts, only live connection.
My advices using Essbase as data source are:
- Make a specific cube to tableau explotation.
- Fill this cube with precalculated data.
- Do not use hierachical structure in the created cube (all members in the same level/generation).
In your specific scenario i have some ideas:
You must create an automatic/periodic export (Using the known Hyperion export options)
1. You can use the EPM Rest API ( https://docs.oracle.com/en/cloud/saas/enterprise-performance-management-co1. mmon/prest/export_data.html )
In case you can get a json output, is possible to create a Tableau Data Web connector.
https://help.tableau.com/current/pro/desktop/en-us/examples_web_data_connector.htm
2. If you get a file (CSV/text), do this inside the tableau server and then you can refresh periodically the extract using TSM commands (cmd script).
https://help.tableau.com/current/online/en-us/to_refresh_extract_commandline.htm
I dont have expirience using Hiperyon on Cloud but im an Essbase Admin and I have done a lot visualizations Essbase based.
There are pros/cons using Essbase/Cube as data source.
Some of them are:
Regards from México City
