Data loading issue .

[Former Member]

Hi,

When i try to load the data from ods to infocube its giving error . i analysed the isue the data is coming up to ods . if i load the ods to infocube its giving error.Actually i have one formula have giving this error if i kept this inital value there is no problem . But i need this formual as per my client requirement.Can any one guide me on this issue.

the formual written like this

DATE_FISCPER( Document Date, 'V3' )

Regards

Rk

[former_member181964 · Accepted solution]

Hi,

DATE_FISCPER( Document Date, 'V3' )

Don't give space after bracket and before ending the bracket and try.

DATE_FISCPER(Document Date, 'V3')

The formula is correct, but check whether you used proper functions or not?. i.e. "(" and ")".

You pick symboles from Functions not from Calculation Buttons.

We used similar function like below, it is working fine.

DATE_FISCYEAR(Billing doc date, 'V3')

Thanks

Reddy

[Former Member · Accepted solution]

Hi,

Thank you very much for your reply . The formula syntax is correct when the data is loading from ods to infocube error is coming . Do you have any alternate solution.

Regards

Rk

[Former Member · Accepted solution]

Hi,

Check the format and type of target and source object.

Check the same for used object on formula. Al should match then only DSO will update cube. While loading DSO from data source these issues do not occur.

I hope it will help.

Thanks,

S

[Former Member]

May be V3 is not valid fiscal year variant or master data for it does not exist.

What it's actually telling in this error message?

[Former Member]

Please check if V3 is existing in the list of variants available in the table T009B

[Former Member]

Hi Experts,

Thank you very much for your reply . Here iam getting this error only one particular period and remaining periods data loading. i Checked this table T009B V3 existing .If i remove this formula data has been loading. even i dont have debugging option from ods to infocube .Here we are going for testing purpose some new company code has been added . the same formula working in prodiuction and this prob only quality system.Do you have any alternate solution.

Regards

Rk

[Former Member]

May be V3 is not valid fiscal year variant or master data for it does not exist.

What it's actually telling in this error message?

[Former Member]

Hi Rama,

Try a routine instead of formula.

use the func module 'DATE_TO_PERIOD_CONVERT' in routine

Good luck,

vijay