Issue while loading Data from BW to BPC

[former_member225135]

Hello Experts,

I am facing a weird issue while loading data from BW mini cube to BPC for consolidation

we have one mini cube in BW which basically stores data from all sources (ECC & Flat file).

I am trying to load above combination of data from Mini Cube to BPC & I am getting this error.

I am not able to understand why system is mapping is doing so. For the same combination for the entity ESA, the data gets properly loaded but for the entity EUK, i am getting this error and that too for this GL.

My transformation file looks like this:

Regards,

Rahul

[Former Member]

Hi Rahul,

I don't think you can have empty values in BW records you loading to BPC. This makes BPC skip Dimensions and try checking member against a wrong Dimension.

Try populating those empty values with NONE or something similar.

Regards,

Gersh

[former_member225135]

If this is the case, Why i am getting error in case of audit-trail

In this case, I have a field of Audit Trail which is populated with "INPUT_FF" and my getting error in case of audit trail also.

System is trying to map Request ID field to Audit Trail BPC Dimension

Regards,

Rahul

[Former Member]

Can you please post a screen shot of a record with all fields populated and error message for Audit Trail? Also a couple records before that record because that shift can come from the previous record.

Regards,

Gersh

[former_member225135]

I am putting the screenshot for the same GL only (in which i am getting error)

and screenshot for loading the same GL in BPC

Hope this helps.

Regards,

Rahul

[Former Member]

Yes, this definitely helped to see that ZMOV_TY is still empty and you are using this field in your load. That's why you have those errors.

Please let me know what is not clear here?

Did this help?

Regards,

Gersh

[former_member225135]

Hi Gresh,

If you my error, system is trying to map request ID to Audit trail dimension.

Here, in this case, my field for audit trail is field with INPUT_FF. so why system is mapping the field of audittrail to request ID of BW for that specific combination and not for other.

My only concern is why system is giving me error for this combination only (ENTITY: EUK & ACCOUNT_C : 4281) and not for other entity with same GL even if the all other combination are same.

Regards,

Rahul

[Former Member]

Hi Rahul,

If you want to see more errors you have to increase MAXREJECTCOUNT in Transformation file.

Regards,

Gersh

[former_member225135]

I have tried doing that but got the same result

Regards,

Rahul

[Former Member]

Can you put in filter ENTITY = EBT and check if you getting same result?

-Gersh

[former_member225135]

PFA.

    

There is no error while loading data for same GL and entity code as EBT.

Regards,

Rahul

[Former Member]

Can you please do same for Company Code  = EUK and post ALL fields of those records for this case as well as previous one? I can see many more fields used in your Transformations than in records you show.

Thank you,

Gersh

[former_member225135]

PFA..

Regards,

Rahul

[Former Member]

Try HEADER = NO.

[former_member225135]

If I am trying as HEADER=NO, i am getting an error :

ZGRP_ACCN is not a valid command or column ZGRP_ACCN does not exist in source

[Former Member]

Data from BW cube is loaded without header.

Can you please post screen shot of that error message?

Thanks,

Gersh

[former_member225135]

IMAGE:

[Former Member]

Are you sure you using Transformation file you showed in the 1st posting? It shows that CATEGORY is always "Actual" while your error message shows "Forecast".

Do you know why is that discrepancy?

[former_member225135]

I have only changed category. Reason is my user has already started validation and I don't want to hamper the validation and so I created a copy of that transformation file.

[former_member193143]

Hello Rahul,

Go to your Flow dimension and check that the member 4281 is available or not.

if it is available please check that is parent member or a base member. Please make sure that all the members in that record are base members

The reason you are getting that error is either that member is not available in your Flow dimension or its a hierarchy node.

In BPC we can't write data to a parent member..

Regards,

Saida Reddy

[former_member225135]

Hi Saida,

My problem is 4281 is my Account ID and there is no flow member with this ID.

If you look at the images:

Image 2. BW Minicube:  4281 is account ID and Movement Type field is empty

Image 3. BPC: system is giving the error that 4281 is not available in Flow dimension.

I don't know why system is mapping BW account ID to FLOW for that specific entity and GL combination.

Regards,

RAhul