Requirement in Data Loading

[Former Member]

Hi All

We are loading data from a Multiprovider to BPC. Under Multiprovider we have 3 Infoprovider. 2 Infoprovider is from SAP and another one is from Non SAP. So my question is while we transferring the data from BW to BPC, data should transfer based on AuditTrial as SAP and Non SAP as below:

If the Infoprovdier

1. SAP Infoprovider - AuditTrial should be SAP

2. SAP Infoprovider - AuditTrial should be SAP

3. Non SAP Infoprovider - AuditTrial should be Non_SAP

In a Multiprovider we have a attribute as Infoprovider and the values of this attribute are Infoprovider names.

Structure of our Multiprovider as below:

Multiprovider

     SAP Infoprovider

     SAP Infoprovider

     Non SAP Infoprovider

Hope you understand our requirement, if you want any more details please let me know and will provide you accordingly.

Thanks in Advance

Regards

Srikant

[Former Member · Accepted solution]

Hi Srikant,

In your transformation file for audittrial = mapping you just use the 0INFOPROV with the IF statement.

if 0INFOPROV = NON SAP infoprovider then *STR(NON_SAP) else *STR(SAP)

Andy

[Former Member · Accepted solution]

Hi Andy

Thanks for your reply

It works fine once we convert the "Non SAP Infoprovider" as a string. Otherwise it throws error as this field does not exist.

Thanks

Srikant