Forum Stats

  • 3,767,751 Users
  • 2,252,713 Discussions
  • 7,874,327 Comments

Discussions

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

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

Hi,

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

pastedImage_3.png

Pre-Packaged Source Mapping

pastedImage_4.png

Custom Source Mapping

pastedImage_5.png

Regards

Tagged:

Answers

  • 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.