Export txn / transaction data from bpc with end routine and skip a column in transformation file

[UmaArjunan]

BPC Experts ,

I wanted to export transaction data from BPC cube to application server as csv file.

i have used end routine file to apply the business rules. Along with end routine, one particular column in the transformation should be skipped.

BPC structure 14 fields, where as the file requires only 13 fields. Is it possible to skip a column in the transformation file export option when end routine is used ?

When i use skip in the transformation file for that column it is throwing error . Please advise

[Former Member · Accepted solution]

Hi Uma,

Please show your transformation file.....have you tried using SPECIFICMAPPING=YES in transformation file for export? May work

http://help.sap.com/saphelp_bpc75_nw/helpdata/en/5d/9a3fba600e4de29e2d165644d67bd1/content.htm?frame...

Regards,

JP

[UmaArjunan]

Hi JP & Vadim,

Addition of

SPECIFICMAPPING=YES in the transformation file worked in the way i expected. Less no of required columns available in the end routine data is based on the definition in the transformation file . thank you very much

Regards, Uma

[former_member186338]

Have to ask the same second time:

Text of the transformation file.

BADI text.

[UmaArjunan]

DMP BPC: Export Transaction Data to Application Server /CPMB/EXPORT_TD_TO_APPL created to export the transaction data to a file in Appliication server path . It is semicolon separted file.

I have used end routine for entity and account conversion based on certain business conditions. In the output file only few columns are required to display.

the file is generated with right values but which ever column is blank , it just add the separators. i just need the contents of few columns from the END Routine, as per the endroutine, system is trying to export all columns to the file .

For that i m trying to skip few columns in the transformation file which is not required in the output file. can we use skipcol command in transformation file when endroutine is used. pl. clarify

[former_member186338]

Sorry, but not clear!

What do you have in the transformation file?

What is the logic implemented in routine badi?