Skip to Main Content

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to upload 2 amounts from FDM to HFM in the same Account/diff Custom 1?

user5541589Dec 1 2010 — edited Dec 1 2010
Hi,

We are using Hyperion System 9.3.1 FDM.
In the past, we always upload one amount only per account through FDM into our Custom 1(flows) into closing. Now, we have in the source file (accounting system) not only the closing balance but also the movements in another column.
This means that from now on we will need to upload the closing balance as well as the movement flow through FDM into HFM into the same account but in diferrent Custom 1.

At this point, we succeed to upload one of the amounts into Custom 1 (either closing either movement) but we do not succeed to upload both Custom 1.

source file
------------------------
ENTITY ACCOUNT MOVEMENT CLOSING

x 120000 10 20
y 121000 -3 -17

in HFM
-----------------------
ENTITY ACCOUNT C1-OPENING C1-MOVEMENT C1-CLOSING
(calculated)
x 120000 10 10 20
y 121000 -14 -3 -17

As you see above, what we need is to be able to upload 2 different C1 into the same account.

Could any one help us with this ?
Did anyone had this kind of upload ?

Thank you.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 29 2010
Added on Dec 1 2010
1 comment
209 views