|
Klasyczne typy plików nie są już dostępne od stycznia 2021 r. Możesz przenieść swoje klasyczne pliki lub pobrać plik PDF. Dowiedz się więcej

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

Udzielono odpowiedzi
Zamów wersję demonstracyjną

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

Komentarze

Komentarze: 4

Data Głosy
  • 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

Zaloguj się, aby dodać komentarz.