BPC Transformation File If Syntax

[Former Member]

Hi Experts

I am trying to load exchange rate from BW data source. In the BW data source there are two fields source & target currency. I need to load only exchange rate meeting certain condition .

For example following table show the structure in BW DSO

Source	Traget	Exchange Rate
YYY	XXX	1.5023
ZZZ	YYY	.234
AAA	XXX	1.234
BBB	AAA	3.4567

I want load only exchange rate XXX - Target against Source and skip all the others. In the above table load row 1 and 3 and skip the other two.

What should be syntax I should use in transformation file.

INPUTCURRENCY =*IF(TARGET=*STR(XXX),THEN (SOURCE);*STR(SKIP)) is this correct or please advise .

Thomas

[former_member186338]

Hi Thomas,

You can't use SKIP inside IF in the transformation file, you can skip lines in conversion file...

Read: Data Transformation Maintenance - SAP BusinessObjects Planning and Consolidation - SAP Library

http://help.sap.com/saphelp_bpc75_nw/helpdata/en/81/94a8a5febd40268d5c59b4fc31be37/content.htm?frame...