Skip to Content
avatar image
Former Member

How to load several transformation files with a single action

Hi everybody,

We are loading data from BI cube into BPC cube. We are working on SAP BPC 7.0 version and we have designed several transformation files in order to load each key figure we need.

Now, we want to load all the transformation files executing only one action. Which one is the best way to do it?

We thought that it would be possible to build a single process chain, where we would call the target cube and all the transformation files. In this way, the administrator only has to execute once a package that would execute the process chain. We don't want the administrator to execute several times a package looking for the different transformation files.

How can we do it? Is there any example or document related to it?

Any idea out there?

Kind regards

Albert Mas

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

3 Answers

  • avatar image
    Former Member
    Mar 16, 2010 at 07:53 PM

    Dear Albert.

    I have the same problem. We are trying to load key-figure model but we didn´t it still.

    I can see an interested issue:

    I tried to do the indications but only I could input 3 transformation file including 3 PROMPT in the Process Chain using DM -> advanced:

    PROMPT(TRANSFORMATION,%TRANSFORMATION%,"Transformation file:",,,Import.xls)

    PROMPT(TRANSFORMATION,%TRANSFORMATION%,"Transformation file:",,,Import.xls)

    PROMPT(TRANSFORMATION,%TRANSFORMATION%,"Transformation file:",,,Import.xls)

    But when I run a package, I get an error:

    FILE= DATAMANAGERDATAFILESpruebas_CAMPOVALOR3.csv

    TRANSFORMATION= DATAMANAGERTRANSFORMATIONFILESTF_REVENUE.xls

    TRANSFORMATION= DATAMANAGERTRANSFORMATIONFILESTF_COST.xls

    TRANSFORMATION= DATAMANAGERTRANSFORMATIONFILESTF_OVERHEAD.xls

    CLEARDATA= Sí

    RUNLOGIC= No

    CHECKLCK= Sí

    -

    -


    Task name CONVERT:

    No 1 Round:

    Cannot find dimension K_REVENUE in current application

    Application : CONTROLLING. Package status: ERROR

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Mar 17, 2010 at 12:02 AM

    Hi Albert,

    Within one BPC Transformation file you can have multiple ROUNDS

    Each ROUND is the combination of a *OPTIONS / *MAPPING / *CONVERSION block.

    One Transformation file can have as many ROUNDS as you would like.

    Try combining these various transformations into one and see if this gets you the behavior that you desire.

    Cheers, Scott

    Add comment
    10|10000 characters needed characters exceeded

    • HI SCOTT,

      I AM FACING A PROBLEM WHEN I RUN 2 ROUNDS IN ONE TRANSFORMATION FILE...

      I need to distribute a source field in to BPC through making 2 conversion files... following is the data

      Transformation file

      *OPTIONS FORMAT = DELIMITED HEADER = YES DELIMITER = , AMOUNTDECIMALPOINT = . SKIP = 0 SKIPIF = VALIDATERECORDS=YES CREDITPOSITIVE=YES MAXREJECTCOUNT= ROUNDAMOUNT= CONVERTAMOUNTWDIM=ZOUTPUT *MAPPING CATEGORY=*NEWCOL(ACT) PAO=0COSTCENTER TIME=0FISCYEAR ZOUTPUT=0FUNDS_CTR SIGNEDDATA=0DEB_CRE_LC *CONVERSION PAO=PAO_CONVER.XLS ZOUTPUT=ZOUTPUT_CONVER.xls *OPTIONS FORMAT = DELIMITED HEADER = YES DELIMITER = , AMOUNTDECIMALPOINT = . SKIP = 0 SKIPIF = VALIDATERECORDS=YES CREDITPOSITIVE=YES MAXREJECTCOUNT= ROUNDAMOUNT= CONVERTAMOUNTWDIM=ZOUTPUT *MAPPING CATEGORY=*NEWCOL(ACT) PAO=0COSTCENTER TIME=0FISCYEAR ZOUTPUT=0FUNDS_CTR SIGNEDDATA=0DEB_CRE_LC *CONVERSION PAO=PAO_CONVER.XLS

      ZOUTPUT=AMOUNT_CONVER.XLS

      Conversion file 1 (PAO=PAO_CONVER.XLS)

      EXTERNAL INTERNAL ID0001 F08001 ID0002 F08001 ID0003 F08001 DG0001 F08001 DG0002

      F08001

      Conversion file 2 (ZOUTPUT=ZOUTPUT_CONVER.xls)

      ID0001 FX01 VALUE*1 ID0002 FX01 VALUE*1 ID0003 FX01 VALUE*.40 DG0001 FX02 VALUE*1 DG0002 FX02 VALUE*1

      Conversion file 3 (ZOUTPUT=AMOUNT_CONVER.XLS)

      EXTERNAL INTERNAL FORMULA ID0003 FX02 VALUE*.60

      I am getting the following error

      [Start validating transformation file] Validating transformation file format Start validation transformation 1/2 Validating options... Validation of options was successful. Validating mappings... Validation of mappings was successful. Validating conversions... Validation of the conversion was successful Start validation transformation 2/2 Validating options... Validation of options was successful. Validating mappings... Validation of mappings was successful. Validating conversions... Validation of the conversion was successful Creating the transformation xml file. Please wait... Transformation xml file has been saved successfully. Begin validate transformation file with data file... [Start test transformation file] Validate has successfully completed ValidateRecords = YES Reject count: 0 Record count: 6 Skip count: 0 Accept count: 6 0COSTCENTER is not a valid command or column 0COSTCENTER does not exist in source Validation with data file failed
  • avatar image
    Former Member
    Mar 23, 2010 at 07:12 PM

    Thanks!

    Add comment
    10|10000 characters needed characters exceeded