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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

creating a closing balance in FDM

786797Jun 2 2014 — edited Jun 5 2014

Hi,

the IT department is only able to provide periodic transaction from their GL.

While it is not a problem to load periodic values for a P&L account, it is for a Balance Sheet one.

now i managed to import all data into the first year last period to create a closing (last period first year) and subsequently opening balance (first period, second year).

so what is left is to create (meaning import) following closing balance.

one idea is would be to collect the previous period (by account and dimensions, not transaction) and add the current transaction to that, in a Befimport script.

so my question is as following: would it be possible to retrieve, maybe from the tdataseg table, a sum by HFM dimension of the previous period? or would it potentially create performance issue?

or is there any other smart way / best practice to do this?

thanks for any help

This post has been answered by 786797 on Jun 5 2014
Jump to Answer

Comments

1048869

Any help on this?

1 - 1
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Jul 3 2014
Added on Jun 2 2014
3 comments
1,582 views