Classic file types are no longer available for use as of January 2021. You can transition your classic files or download a PDF. Learn More

'Extract Data to File' (Oracle Hyperion Financial Management) command not working

Answered
0

Comments

4 comments

  • Tony Scalese

    Try putting the member name in double quotes.  For example:

    [DATA_SUBSET],SCENARIO,"ACTUAL",[MEMBER]

    1
  • Lina Zhao

    Thanks, Tony, I tried your suggestion, but it's still not working. However, if I copy these directly into the 'config text' field rather than using the 'config file', the command works. Still not sure how to use a 'config file' for this to work though. 

    Lina 

    0
  • Tony Scalese

    Hi Lina,

    The Config File is used to store the POV information in a physical file.  For example, you could use a Chains Workspace Resource to store this config.  Then you would reference the config file from the Variable pane in the Command configuration under the Resources section.  If you store the file locally (C:\directory\file.txt) then the GroundRunner service needs read access to the directory where the file is stored.  I find it easier to use the Resource for this purpose rather than storing it locally. 

    The config text is as you saw used to specify the actual extract parameters as text in the Command configuration.  You can use either approach but many prefer the Resource approach since changes to the Resource do not require the Chain to be republished.

    Hope that helps.

    Tony

    0
  • Lina Zhao

    Thank you so much, Tony!! I uploaded the file to the Resource section and it is totally working now! I'm just getting started with chain building in Wdata, really appreciate your fast help :). 

    Lina

    0

Please sign in to leave a comment.