|
自 2021 年 1 月起，傳統文件類型將不再可用。您可以轉換傳統檔案或下載 PDF。進一步瞭解

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

已回覆
要求演示

Hi,

I'm trying to use the 'Extract Data to File' command in the Oracle HFM BizApps, and received the following error message: 

I'm using a .txt file as my configuration file and it contains the following (12 dimensions are used for the HFM POV). The HFM I'm using is on-premise and a GroundRunner is installed on the same server that houses the HFM application. 

[DATA_SUBSET],SCENARIO,ACTUAL,[MEMBER]
[DATA_SUBSET],YEAR,2020,[MEMBER]
[DATA_SUBSET],PERIOD,P01,[MEMBER]
[DATA_SUBSET],VIEW,Periodic,[MEMBER]
[DATA_SUBSET],ENTITY,32203,[MEMBER]
[DATA_SUBSET],VALUE,CAD TOTAL,[MEMBER]
[DATA_SUBSET],ACCOUNT,INC10005,[MEMBER]
[DATA_SUBSET],ICP,[ICP Top],[MEMBER]
[DATA_SUBSET],CUSTOM1,TOPCUSTOM1,[MEMBER]
[DATA_SUBSET],CUSTOM2,TOPCUSTOM2,[MEMBER]
[DATA_SUBSET],CUSTOM3,TOPCUSTOM3,[MEMBER]
[DATA_SUBSET],CUSTOM4,CYBUDRATE,[MEMBER]

Could someone help with this? How can I correctly extract data from HFM into a file? Many thanks!

Lina

0

評論

4 條評論

日期 投票數
  • 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

請登入寫評論。