on 05-02-2015 6:30 PM
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
PERIODID | PERIODSTART | PERIODEND | PERIODDESC | PARENTID |
1410 | 2014-10-01 | 2014-10-31 | 14-Oct | 2144 |
1411 | 2014-11-01 | 2014-11-30 | 14-Nov | 2144 |
1412 | 2014-12-01 | 2014-12-31 | 14-Dec | 2144 |
2144 | 2014-10-01 | 2014-12-31 | Q4-2014 | 3014 |
3014 | 2014-01-01 | 2014-12-31 | Y-2014 | |
1501 | 2015-01-01 | 2015-01-31 | 15-Jan | 2151 |
1502 | 2015-02-01 | 2015-02-28 | 15-Feb | 2151 |
1503 | 2015-03-01 | 2015-03-31 | 15-Mar | 2151 |
2151 | 2015-01-01 | 2015-03-31 | Q1-2015 | 3015 |
1504 | 2015-04-01 | 2015-04-30 | 15-Apr | 2152 |
1505 | 2015-05-01 | 2015-05-31 | 15-May | 2152 |
1506 | 2015-06-01 | 2015-06-30 | 15-Jun | 2152 |
2152 | 2015-04-01 | 2015-06-30 | Q2-2015 | 3015 |
1507 | 2015-07-01 | 2015-07-31 | 15-Jul | 2153 |
1508 | 2015-08-01 | 2015-08-31 | 15-Aug | 2153 |
1509 | 2015-09-01 | 2015-09-30 | 15-Sep | 2153 |
2153 | 2015-07-01 | 2015-09-30 | Q3-2015 | 3015 |
1510 | 2015-10-01 | 2015-10-31 | 15-Oct | 2154 |
1511 | 2015-11-01 | 2015-11-30 | 15-Nov | 2154 |
1512 | 2015-12-01 | 2015-12-31 | 15-Dec | 2154 |
2154 | 2015-10-01 | 2015-12-31 | Q4-2015 | 3015 |
3015 | 2015-01-01 | 2015-12-31 | Y-2015 |
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
13 | |
4 | |
3 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.