Skip to Content
0
Aug 12, 2016 at 10:41 AM

Hard coding of a blank member in BPC transformation file

427 Views

Hi Experts,

I am creating a transformation to map BPC master data with BW cube.

In transformation file, one of the condition for WBS coloumn is:

WBS=*IF(GL(1:5)=*STR(10104) then Assignment;WBS)

In above condition my additional requirement is that if both WBS and Assignment columns are blank (Having no values) then it needs to hard code as "NO_WBS".

Please suggest a way to incorporate this requirement in transformation file.

Thanks,

Karan