This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
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?
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.
I think the most simple solution would be to use Excel VBA to execute the "Refresh All" (e.g. using HypMenuVRefreshAll) within the workbook. Then you'll have to create a small VB Script to Open - Calculate - Save to Excel workbook. This could be called using the RunCommand tool in Alteryx. What do you think?
The one tweak that I would suggest you make is instead of using a run command tool in the workflow to execute the VBA script, you would actually use a workflow event to do a run command before workflow run as seen below: