cancel
Showing results for 
Search instead for 
Did you mean: 

SAP BPC: Replace Initial value.

Former Member
0 Kudos
89

Hi,

How do I replace an initial value (blank) with another value in my conversion file ?

My problem is the load of GL account from SAP BW. Here I have a value "X" if the account is a balance account, but if it is a P&L account the value is initial (blank).

I tried like this in the conversion file:

External = *

Internal = CLS

But nothing happens.

Thanks,

jdalby

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi,

Do you mean that in BW, you have # values. And you want to convert this to some member?

In that case, you can use # in the internal field and use a member in the external column.

Hope this helps.

Former Member
0 Kudos

Hi,

it's when I load masterdata from 0account to a BPC dimension (attribute = ratetype).

Unfortunately, it didn't work with #.

My conversion file looks like this:

EXTERNAL INTERNAL

X CLS

# AVG

* AVG

"X" works, these members get ratetype = CLS, but AVG is not filled for the rest.

regards

jdalby