Transformation file issue?

[former_member225916]

Hi All,

We are using SAP BPC NW 10.1 classic.

I have to load following type of flat file.

Account   Entity  Rptcurrency  Category    2015.JAN  2015.FEB

4000000   XYZ     USD            ACTUAL    1000000    1500000

5000000   XYZ     USD            ACTUAL     2000000    250000

Total Dimensions in model: Account,Entity,Time,Rptcurrecny, Category, Time, Audittrail and Region.

My requirement is,

   1. no audittrail members are coming from flat file. We have to load each record in flat file to 2 audittrail members (Input, Calc)

   2. If the account member begins with '4' then i have to flip the sign

   3. no region members are coming from flat file. We are maintaining property in entity dimension which contains with respect to entity.                                We need to load region members based on entity dimension property.

Please let me know the possible solutions??

Thanks,

Naidu

[Former Member]

If you are loading flat file directly to BPC then Load it once and then write badi for the logic you want to implement.

When you load the same for the first time get it on new AUDITTRAIL as FLAT and then using a badi copy this data to other auditrails as required with all the other logics to be implemented.

Other way to do this is by loading the flatfile to BW cube and then using rule group copy the same line on 2 audittrails. The remaining logic can be handled in Field routine and look on entity master.

BW developer will be able to manage the same.

Regards

Rohan

[former_member225916]

Hi Leila,

Yes I can hard code. but i was supposed to load the same record to different audittrails.

AUDIT=*NEWCOL(Input)  -> it loaded only to Input but i want to load same record to 'Calc' member also.

Thanks,

Naidu

[former_member186338]

You have to load twice to load single value to 2 different audit members! Or use badi.

Vadim

[former_member186338]

"3. no region members are coming from flat file. We are maintaining property in entity dimension which contains with respect to entity.                                We need to load region members based on entity dimension property."

Load to dummy region and then copy to the required region using script!

Or use routine badi...

Vadim

[damovand]

Hello,

You can hard code a column for audit value.  So you can write a statement like the following AUDIT=*NEWCOL(Input) In your mapping of account you can use a conditional statement. So you can write a statement like: ACCOUNT=*IF(*col(1,1:1)=4… Please check the information in the online help for more details.  I hope that this is helpful.

https://help.sap.com/saphelp_bpc70/helpdata/en/5d/9a3fba600e4de29e2d165644d67bd1/content.htm

Best Regards,

Leila