Working on Actual vs consumed report. i have used Fiscal year, however fiscal year variant is compounded with it.
In transformation, I have given fiscal year variant as constant and given it value as V3.
Cube is displaying fiscal year data as 2010, but in report it is reflecting as V3/2010. Now, I need to remove V3/ from V3/2010.
As SAP BW doesn't support string functions, I need to solve it alternate way.
Can anybody help me for same.
Regards,