Hi,
New to HFM and SmartView. We would like to use API to query data out of the HFM database. According to our internal HFM point of contacts, there is no direct connection to HFM due to security in HFM.
- But when doing a internet search, I found there is Java API that we can use to connect to HFM. Is it possible, but not recommended?
- Are data through SmartView not directly from HFM but from a different database? I wonder if we can query that database instead.
- I heard something called Essbase. Is it where the SmartView data are from?
- Also, when creating this post, I saw someone who had asked question about using Jython to get HFM data. Good to know. I thought about asking using Python to get HFM data as well.
- If we create a report using SmartView, would it be possible to find the equivalent MDX query in Excel?
Thank you
Dimani