I have written formula at transformations between datasource to infocube to convert lower case values for the field to upper case
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,
asim khan replied
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/