Getting #/Not assigned data from BW

[simon_kussmann]

Hi,

I am loading data from BW to BPC and found some inconsistencies.

The transactional data related to the #/not assigned master data isn't loaded to BPC.

For example the red row:

Dimension 1 | Dimension 2 | Amount

dim1a               dim2a                10

dim1b               dim2b                  5

#                      dim2c                10

Is there any possibility to handle that?

Regards,

Simon

[Former Member · Accepted solution]

Hi Simon,

In your transformation file for the transaction data load you need to map those empty member into a member in BPC dimension member, maybe during the selection you excluded those members, thus not loading into BPC.

Andy

[damovand]

Hello,

Please provide your BPC version and transformation file.  Are you mapping these values correctly to BPC data regions and are you able to validate the transformation successfully?

In BPC we do not have a specific place for non-assigned values.  What you can do is to map it to a member that has NO specific designation, something like NO_INTCO for example.

Best Regards,

Leila

[former_member186338]

"Is there any possibility to handle that?" - handle how? What do you want to achieve?

Vadim

[Ankur_Jain1m8]

Hi Simon,

What I understood is that you are not getting the row which is highlighted in red above.

Could you please share the source row in BW and the mapping in your transformation file and conversion file?

Regards,

Ankur Jain