Issue in Hierarchy Text Node
I am trying to load Cost Center from BW.
In the BW object there are many junk record which I want to skip.
For Eg: I want to have specific Co Areas in and want to skip all records if they are blank or have other then specified.
In Transformation file
Co_Area=*IF(CO_Area=*STR() then *STR(NA);CO_Area)
In Conversion file i have specified
The issue is that it skips the hierarchial node also since the Controlling area is blank.
Is there some way how i can skip the blank records of Controlling area but does bring the hierarchial node?