cancel
Showing results for 
Search instead for 
Did you mean: 

APO BW Cube Loading error

Former Member
0 Kudos

Dear All,

I have defined a fiscal year variant and using for my DP Planning.

Also using the same FYV in Info cube also.

Now when i load the data from Excel data source to the cube getting the error as

"Fiscal year variant F2 is not maintained for calendar year 2008"

But in the fiscal year variant definition i have defined for year 2008 and this error is thrown only if i include records for period April 2008 onwards, the records are getting loaded from April2007 to Mar 2008.

See below the FYV definition for Year 2008(year dependant)

Month Day Period Year Shift

1 6 49 -1

1 13 50 -1

1 20 51 -1

1 27 52 -1

1 31 53 -1

2 3 54 -1

2 10 55 -1

2 17 56 -1

2 24 57 -1

2 29 58 -1

3 2 59 -1

3 9 60 -1

3 16 61 -1

3 23 62 -1

3 30 63 -1

3 31 64 -1

4 6 1 0

4 13 2 0

4 20 3 0

4 27 4 0

4 30 5 0

5 4 6 0

5 11 7 0

5 18 8 0

5 25 9 0

5 31 10 0

6 1 11 0

6 8 12 0

6 15 13 0

6 22 14 0

6 29 15 0

6 30 16 0

7 6 17 0

7 13 18 0

7 20 19 0

7 27 20 0

7 31 21 0

8 3 22 0

8 10 23 0

8 17 24 0

8 24 25 0

8 31 26 0

9 7 27 0

9 14 28 0

9 21 29 0

9 28 30 0

9 30 31 0

10 5 32 0

10 12 33 0

10 19 34 0

10 26 35 0

10 31 36 0

11 2 37 0

11 9 38 0

11 16 39 0

11 23 40 0

11 30 41 0

12 7 42 0

12 14 43 0

12 21 44 0

12 28 45 0

12 31 46 0

Can you please suggest?

Thanks

Santhana

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Hope you have maintained the Fiscal year variant till March 2009...Can you try maintaining the FYV for 2009 and try the load.

Please let me know if this works

Former Member
0 Kudos

Hi,

I have maintained fiscal year variant till year 2013.

Thanks,

Santhana.

Former Member
0 Kudos

Hi All,

The problem is fixed. There were gaps in fiscal year variant and for that i have to maintain Shortened Fiscal Years.

Thanks,

Santhana

Former Member
0 Kudos

Hello,

How are you determining fiscal period when you are loading data from excel source to cube? Is there an ABAP routine for determining the fiscal period?

Awaiting your reply.

Warm regds,

Ashutosh

Former Member
0 Kudos

Hi,

Excel sheet has calday as inout parameter. From calday to period, fiscal variant determines the posting period.

Thanks,

Santhana.