Can you please try with Essbase DB connection for the FR Report instead of Planning connection see whether you can able to display alias in the FR Report.
Also refer following KM articles :
Financial Reporting (FR) Reports Display Member Names Instead of Aliases (Doc ID 945476.1)
There is no substring function in FR, you'll have to play with the layout. I've done that by placing a blank text field (just long enough to hide the member name from alias).
If you have member name concatenated to the end, there you are out of luck. Also try to get something which works fine in both PDF and HTML version.
@harish : Thats not what i was looking for.
@calvin : we have MEmber names with uneven lengths so that ruled out.
i have member A,B,C and D with member desc : X,Y,Z,X
so we load alias as AX,BY,CZ,DX so that there it can be loaded.
now client want to see.
is it possible to show that in FR . i tried MemberDescription but it shows only member name.