Skip to Content

I have written formula at transformations between datasource to infocube to convert lower case values for the field to upper case

Hi All,

I have written the formula at transformation level between Datasource to DSO to convert lower case values to upper case for one of the field.

After writing formula all the lower case values coming from the source system is converting to upper case in DSO successfully.

But when I load the same data from DSO to Infocube again in infocube I can see lower values, due to that load is getting failed.

Not able to understand why again in infocube lower case values are coming , as already values are converted to upper case at DSO level.

There is a direct mapping between field and no start or end routine.

Thanks In Advance,

Ubaid.

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

3 Answers

  • Best Answer
    Sep 07, 2016 at 12:01 PM

    Hi All,

    Issue is solved, we have to write formula at both level that is Datasouce--- DSO and then DSO---cube. There was some old entries in the change log table with lower case letters that's the reason load was failing . Finally I have written the formula between DSO and Cube it got success.

    Thanks all for the support/

    Regards,

    Asim.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Apr 01, 2016 at 06:22 AM

    Hi Asim,

    please cross check at your DSO, all values are in upper case or not.

    there might be some old data at dso which are in lower case, that might be causing.

    please check your DSO data and find it.

    other wise, time being, you can write formula between DSo and Cube to convert upper and solve it.

    Thanks

    Add comment
    10|10000 characters needed characters exceeded

    • Hi Phani,

      I have written the formula TOUPPER ( ZINFOOBJECT), between transformation of Datasource and DSO.

      Developer missed to select the settings at inoobject level for lower case letters. Now its not possible to marked the infoobject as lower case because already data is loaded, System will give error if we try to mark it as lower case as existing master data will get corrupted.

      Thanks,

      Asim.

  • avatar image
    Former Member
    Apr 01, 2016 at 07:42 AM

    Hi Asim,

    Can you check settings of info object, if the flag is set for Lower case letters or not then upper case and lower case are distinguished when you enter values with screen masks, Otherwise all the letters entered will be converted to upper case when you enter values with a screen mask.

    Thanks,

    Siva

    Add comment
    10|10000 characters needed characters exceeded