Skip to Content

Convert FISCPER to 0FICPER3 in a transformation

Hello Experts,

I was creating a transformation from data source to Cube.

The field of data source is FISCPER and fields of Cube is 0FISCPER3 and 0FISCYEAR.

How can I map this??

No info-source is there in between data source and Cube.

Thanks,

Ipsita

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Oct 26, 2017 at 11:53 AM

    Hi,

    Simply create field routines.

    for 0FISCYEAR:

    RESULT = SOURCE_FIELDS-FISCPER(4).

    for 0FISCPER3

    RESULT = SOURCE_FIELDS-FISCPER+4(3).

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 26, 2017 at 01:47 PM

    Hello Experts,

    If I try to map FISCPER(Field of data source) to 0FISCYEAR ,it is showing me a warning that "automatic conversion is not possible".

    But in-spite of the warning if I map it , it is loading correct data. It is taking the year value from the value of FISCPER accordingly.

    Is it the correct process to map it??

    Thanks,

    Ipsita

    Add comment
    10|10000 characters needed characters exceeded