Hard coding of a blank member in BPC transformation file

[karan_kothari2]

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

[former_member186338]

Like this:

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

Vadim

P.S. Data Transformation Maintenance - SAP BusinessObjects Planning and Consolidation - SAP Library

[Former Member]

Karan, tried using conversion file for this?

Regards,

JP

[Former Member]

refer this thread....BPC Transformations - IF Condition | SCN

try with: WBS=*IF(GL(1:5)=*STR(10104) then Assignment; Assignment+WBS = STR() then STR(NO_WBS);WBS)

Not tested in sytem.....but try with you...

Regards,

JP

[former_member186338]

Incorrect, look on my formula!

in you case if GL(1:5)=*STR(10104) is true but both Assignment and WBS are empty then WBS will be empty

[Former Member]

Right.... I had not seen your reply till then....your formula will work correctly.

JP