Forum Stats

  • 3,852,891 Users
  • 2,264,146 Discussions


Period Key and Prior Key concept and purpose in FDMEE and Hyperion Planning

JanGLi Member Posts: 650 Bronze Badge
edited Sep 7, 2017 11:50AM in Financial Data Management


I when i am loading data periodically i use to set prior period as the first date of month and period key as the last day of month. But i am not sure why i do this?

My question is when i try to execute data load rule.... will it look for the data against the defined period key or prior key? or will it look for the data against source gl period and gl year? (i am talking about pre-packaged interfacing and custom interfacing both).

As per from oracle documentation i understood that period key and prior key are used if am loading data weekly? this won't be used for monthly.

Global Mapping


Pre-Packaged Source Mapping


Custom Source Mapping





  • Robert Gideon
    Robert Gideon Member Posts: 207
    edited Sep 7, 2017 11:50AM

    Usually, I'll use the first of each month for Prior and Period Key, but the way you are doing it would be very helpful if you ever have to add an additional period in. For example, a BegBalance member in the period dimension. You could use 12/30 - 12/31 for Beg Balance and then 12/31-1/1 for Jan.

This discussion has been closed.