cancel
Showing results for 
Search instead for 
Did you mean: 

Period data loading - Error " Check that the PERIODID sequence for levels 2 3 is not broken"

Former Member
0 Kudos

Hi Experts, I am new to IBP S&OP, am trying to load Period data with below file but I am getting error " Check that the PERIODID sequence for levels 2 3  is not broken'. Please help how to solve this .I have attached the file I am using .

I have period levels as below in my Time Profile

1 Monthly

2 Quarterly

3 yearly

PERIODIDPERIODSTARTPERIODENDPERIODDESCPARENTID
14102014-10-012014-10-3114-Oct2144
14112014-11-012014-11-3014-Nov2144
14122014-12-012014-12-3114-Dec2144
21442014-10-012014-12-31Q4-20143014
30142014-01-012014-12-31Y-2014
15012015-01-012015-01-3115-Jan2151
15022015-02-012015-02-2815-Feb2151
15032015-03-012015-03-3115-Mar2151
21512015-01-012015-03-31Q1-20153015
15042015-04-012015-04-3015-Apr2152
15052015-05-012015-05-3115-May2152
15062015-06-012015-06-3015-Jun2152
21522015-04-012015-06-30Q2-20153015
15072015-07-012015-07-3115-Jul2153
15082015-08-012015-08-3115-Aug2153
15092015-09-012015-09-3015-Sep2153
21532015-07-012015-09-30Q3-20153015
15102015-10-012015-10-3115-Oct2154
15112015-11-012015-11-3015-Nov2154
15122015-12-012015-12-3115-Dec2154
21542015-10-012015-12-31Q4-20153015
30152015-01-012015-12-31Y-2015

Accepted Solutions (0)

Answers (1)

Answers (1)

Alecsandra
Product and Topic Expert
Product and Topic Expert
0 Kudos

Hi,

Each level of your time hierarchy is made up of periods which are identified by integers (1410, 1411 etc). These integers must form a sequence for each hierarchy level. The error you received indicates that the PERIODID sequence is broken for the monthly and quaterly buckets.


In 2014 the monthly buckets sequence goes until 1412, while in 2015 starts with 1501.

Correct would be that monthly sequence in 2015 to start with 1413 and quaterly with 2145.

Regards

Alecsandra