I was trying to follow the steps in https://support.workiva.com/hc/en-us/articles/360050552311-Extract-Data-from-Oracle-Hyperion-Financial-Management-to-Workiva-as-a-File, and is having some problems with the 'Create File' command.
Below is my initial setting (pay attention to the Name field) and the chain was a success.
However, when I tried to run the chain again (to update the data in the Wdata Table), I get the below error message "duplicate file name".
So to have a 'dynamic' file name that changes whenever the chain is run (I don't want to go back and manually update the file name every time), I switched to using a Runtime variable (in this case: "Chain.ExecutionDateTime") plus '.csv' in the end.
Unfortunately, this didn't work as I had expected, see below.
Could somebody help with this? Ideally, I don't have to modify the Name field or manually delete the file/dataset in the Table whenever I run the chain.
(some additional background: I'm connected to HFM using a GroundRunner and the Create File command is therefore also using the same GroundRunner)