Is there a way to connect to Hyperion?

erica_tax2019

My input file has Hyperion formulas. Before I utilize Alteryx to extract & join certain data, I need my Hyperion formulas to be refreshed within my input file. Is there a way to connect to Hyperion so that when I run my workflow, all of the Hyperion formulas within my input file are refreshed?

Interface Tools

Accepted answers

All comments

RolandSchubert

Hi @erica_tax2019 ,

are you using the formulas to calculate within Excel or is it just SmartView/HSGetValue? Which Hyperion product do you use? Hyperion Financial Management, Hyperion Planning, Hyperion Essbase?

Best,

Roland

erica_tax2019

I am using Hyperion Financial Management. Within the excel file, I have embedded formulas to pull from Hyperion so that my data is always the most recent. In order to refresh my formulas within the excel file, I usually click on "Smart View" & refresh all worksheets in order to update the excel file.

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15879

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703