'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
-
Try putting the member name in double quotes. For example:
[DATA_SUBSET],SCENARIO,"ACTUAL",[MEMBER]
1
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
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
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댓글을 남기려면 로그인하세요.
댓글
댓글 4개