Hi,
I have a problem when loading the standard text on an infoobject from BW to BPC.
The problem is that the description on the ID contains "-" and "+" in the beginning. For example:
"- Depreciation".
So there is a "minus" or "plus" in front of the text. So in BPC the text becomes "#NAME?" - because excel thinks it a formula.
I now want to add a conversion to my EVDESCRIPTION, but not sure how to add this to my transformation..
I tried the following:
EVDESCRIPTION=*NEWCOL(TEST)
Just to test what the text field is called in SAP BPC. But this doesn't work.
So !
What is the name of the "text" field in BPC (like id is "ID")
What is the text field from SAP BW ? (is it TXTLG ?).
Thanks,
Jdalby
Edited by: Jørgen Dalby Andersen on Jan 6, 2012 1:05 PM
The specific error is "Description is not allowed to be created by mapping "EVDESCRIPTION"". So apperantly I can not map evdescription when loading from BW.
I would prefer not to do a work around and use open hub to "dump" the infoobject text table to a flatfile and then load it into BPC....