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.

April to March Financial year data load into HFM from SAP TB extract from Jan to December

Parmit Choudhury-DeloitteOct 12 2023 — edited Oct 12 2023

Hi Experts,

We have a peculiar situation and requirement - Client has a universal SAP system where TB can be extracted from SAP/R3 from Jan to Dec. But their financial year in the country where they want to implement hfm is April to March. So in their current manual process in excel they extract three separate TB files from SAP - 1> Jan to Mar YTD TB of last year 2> Jan to December YTD TB of Last Year 3> Jan to Mar YTD TB of current Year. So they manually remove Jan to Mar values in excel of last year & add current year Jan to March values to prepare the TB from April to March for their financial year.

Please can you suggest a way as to how this process can be designed in HFM as client has April to Mar financial year

Any help will be much appreciated

Added on Oct 12 2023

#business-intelligence-applications, #financial-consolidation, #hfm, #hyperion, #performance-management-applications

2 comments

579 views