Skip to Content
0
Former Member
Jan 20, 2012 at 12:51 PM

Remove V3 from "V3/2010" in query result

33 Views

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,