Skip to Content
0
Former Member
Jan 13, 2012 at 10:49 PM

Data export from BPC 7.5 NW

32 Views

I have created and validated my transformation file, which takes two dimensions and concatenates them. For example Company and ProfitCenter, in the mapping section:

U_Entity=Company+ProfitCenter.

Where my company = 5110 and my profit center = SVS8110

The records are validated and in my output file I can see 5110SVS8110 and the associated transaction data.

However, in the *Conversion section of the Transformation file I reference the conversion file

U_Entity=U_EntityConv.XLS

Within the Conversion file, in the internal column I have 5110SVS8110, and in the external column I have UKSERVCO.

Both files are validated, but when I run the export transaction data package, the output file doesn't include UKSERVCO

In BPC 420 training it says *Conversion can be used to convert external keys from the flat file to internal keys. But can it convert internal keys to external keys in the flat file? If so, what do I need to do here?

Thanks.