Question:
Hi,
I've a source system which contains a free text field. Field length is not more than 60 characters, but user can enter anything. I've to create a cube for reporting. How should I handle this free text?
Regards
Tarun
Answer:
What is the link between the free text and the cube ?
_________________
When my car stops, I first look at the gasoline's level before dismounting the engine.
Tuly Idiot's fan club active member.
Answer:
Would the extraction of free text fields be handled any differently as other fields ?
Extraction in R3-> Field mapping in BW->extraction into BW cube.
I wouldnt think so. Please correct me if i am wrong. wud love to know.
_________________
Still learning...... Will it ever stop ?
Answer:
Free text field is always a burden since the info you are uploading into BW are supposed to be codified; hence there are well known restrictions about 'special' characters.
You have two ways to handle this :
1) you enlarge you free text acceptance in BW with all possible characters, and consider this free text such as any other field
2) you 'code' this free text in order to load it as "text" for a certain master data, which allows you to keep the restrictions on your special characters, while allowing you to upload any character the user would have typed in the free text field
Ch
_________________
_
There are only 10 types of people in the world :
those who understand binary and those who don't.