Skip to Content
avatar image
Former Member

BPC NW - Questions on How to Automate Master Data Loads

Hello All,

We recently released a How to for automating master data loads from BW to BPC (Can be found [Here|https://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/00380440-010b-2c10-70a1-e0b431255827]). Please post any questions/comments related to this how to guide in this thread.

We just wanted to consolidate all questions and answers under this thread.

Thanks,

Velavan.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

45 Answers

  • avatar image
    Former Member
    Jun 15, 2009 at 04:24 AM

    Hi ,

    As far as the Master data load is concerned , first we need to load the BW data in a flat file and later on update the Dimension member using this flat file by Data Manager .

    Thanks

    Edited by: Aalok Kumar on Jun 15, 2009 6:24 AM

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jun 15, 2009 at 03:20 PM

    Hi,

    thank you so much for posting the How To paper. This solution is really interesting and we want to implement it very soon.

    Howerver I struggle with the following issue:

    I have a simple infoobject PRODUCTGR with only text and one hierarchy in BW. The Open Hub Destination, Transformations and Data Transfer Process work fine.

    But running the data management package ends with errors.

    My transformation file looks like this:

    ID=*COL(1)

    EVDESCRIPTION=*COL(2)

    PARENTH1=*COL(3)

    The problem is, that BPC is apparently not able to read the rows with products that dont have a hierarchy parent:

    Reject records:

    Command failed *COL(1); column index is out of range

    Line 1 :;;

    Command failed *COL(3); column index is out of range

    Line 1 :BE001000;PGALL;

    This leads to the next problem:

    Package log:

    Dimension PRODUCTGROUP's member BE001010 has a invalid hierarchy parent 'BE001000', and so on

    Can anybody help me with this problem? I have been struggling with this for hours. 😕

    Thank you so much,

    Cora

    Add comment
    10|10000 characters needed characters exceeded

    • Hi,

      I have similar problem like Cora.

      I have tried all different ways but sill ended with the same error.

      _____________________________________________________________

      Command failed *COL(2); column index is out of range

      Line 1 :4518,Master Data,HU_CORP,GBP,USA,HU01,HU_CORP

      _______________________________________________________________

      as suggested by Velavan Trichy: "add an additional field at the end in the open hub (and fill with space in the transformation)"

      How and where to add this space in transformation file?

  • avatar image
    Former Member
    Jun 18, 2009 at 06:46 PM

    Hi,

    thank you for the paper and this forum.

    I am facing the following issue when trying to validate a transformation file that I created:

    An exception with the type CX_SY_STRUCT_COMP_NAME occurred, but was neither handled locally, nor declared in a RAISING clause

    Component Name 'F.000016' of the Component 11 Contains an Invalid Character

    The transformation file contains the following configuration:

    *OPTIONS	   
    FORMAT = DELIMITED	   
    HEADER = YES	   
    DELIMITER = ;	   
    AMOUNTDECIMALPOINT = .	   
    SKIP = 0	   
    SKIPIF =	   
    VALIDATERECORDS=YES	   
    CREDITPOSITIVE=YES	   
    MAXREJECTCOUNT=	   
    ROUNDAMOUNT=	   
    	   
    *MAPPING	   
    ID = *COL(1)	   
    COMPANY = *COL(2)	   
    EVDESCRIPTION = *COL(3)	   
    FCT_AREA = *COL(4)	   
    PC_HRCHY = *STR(1000) + *COL(5)	   
    STATUS = *COL(6)	   
    TYPE = *COL(7)   
    	  
    *CONVERSION
    

    Following checks have been caried out:

    - trailing ";" semicolon is available at the end to ensure that BPC knows that the row is finished

    - order in the mapping section corresponds to the order of provided flatfile

    - field length of target fields and source data matches

    - upload file only contains allowed characters

    What could be the source of this issue? And are there other tools inside BPC available besides the output log that can help to analyze this issue?

    Thank you.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hello Claus

      Are you still facing with this issue??

      I have exacly the same with a transactional one.

      Can you provide me with the steps you did?

      Thanks

      Sergio

  • avatar image
    Former Member
    Jun 29, 2009 at 01:30 PM

    We followed the HTG guide as well and it worked exactly one time. All following packages run an error as stated below:

    No 1 Round:

    Cannot find document/directory

    Application: Budget. Package Status: Error

    It seems, as if the flatfile or the transformation file is not available, even the preview of both files(!!) works.

    Could you please assist or do you have any further information??

    Thx + Rgds,

    Christian

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi Scott,

      I'm working on scenario 1 and seem to have a problem with the Script Editor, too: the prompt

      PROMPT(RADIOBUTTON,%UPDATE%,"Select the method for loading Master

      Data",0,{"Overwrite","Update"},{"0","1"})

      Causes the following BPC error:

      Error occured in the EvmodifyPkg Prompt command.

      Any ideas?

      Regards,

      Stefanie

  • avatar image
    Former Member
    Jul 05, 2009 at 09:15 AM

    Hi,

    I got the error, the error message as following.

    u201C/CPMB/MODIFY : Completed in 0 seconds

    /CPMB/ALLOCATION_LOGIC : Completed in 2 seconds

    /CPMB/CLEAR : Completed in 0 seconds

    [Selection]

    -


    ASARENT=50000

    SOURCE=ASA

    TARGET=RASA

    (Member Selection)

    CATEGORY: ACTUAL,PLAN

    RPTCURRENCY: LC

    TIME: 2008.JAN,2009.JAN

    [Messages]

    -


    RUN_LOGIC:Missing [] on property name: WHAT=RENT.

    Failed

    Application : PLANNING. Package status: ERROR"

    best regards,

    Wang Lei

    u201D

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jul 06, 2009 at 02:42 PM

    Hi,

    thank you for the paper and this forum.

    I am facing the following issue when trying to run my DTP for an Openhup Fileextract for 0WBS_ELEMT (ATTR, HIER and TEXT): I get the following shortdump: Runtime Errors ITAB_DUPLICATE_KEY

    The error occurs in include ZCL_BPC_MD_AUTOMATION=========CM008 in line 45,

    <htable> = nt_id_mapping.

    The internal table nt_id_mapping contains dublicate keys for field ID. I have downloaded this table to ACCESS and analyzed it with dublicate key query. In compairson to WBSH Hierarchy, it seems to depend on the hierarchy. If got records with 2 dublicate entries (1 node below in hierarchy) or for example with 6 dublicate entries (5 nodes below in hierarchy).

    Has anybody else face this problem before or can help.

    Thanks in advance,

    Andy

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Andy,

      This error occurs due to the fact that the Master Data Automation How-To assumes that you are mapping a VALUE of 20 characters or less to the field ID. Remember that BPC's ID field always has length 20 and therefore you cannot map a field like WBS Element with length 24 to it without having part of it truncated.

      I have updated the coding for this in the how-to guide and will be re-releasing the guide at the end of this week. July 31st 2009.

      This updated guide will contain a hashing algorithm that will essentially create a GUID for any infoObject with length greater than 20. This is a unique hashing algorithm so the updates will work seamlessly. You do not need to use this updated method you can instead create a mapping of your values yourself.

      Hopefully this makes sense.

      Cheers, Scott

  • Jul 13, 2009 at 01:38 PM

    Hi Scott,

    Thanks for the Clarification.

    My question is related to Scenario 2.

    We tried mapping BW info Object and BPC object using transformation as specified in the How to paper and transported the same to QA system. Transport request fails to activate the transformation as BPC object does not exist.

    During transport, BPC object is recreated with a different technial name. Transformation activation fails as it does not find the BPC object with the same technical name.

    Could you please suggest a solution or work around?

    Cheers

    Raghu

    Add comment
    10|10000 characters needed characters exceeded

    • Scott,

      When we create a Dimension in BPC Dev i.e, " W_DATASRC " , BI InfoObject gets generated with a technical name " /CPMB/O9DWZ5X ". However when you transport the application set to BPC QA, same BPC Dimension " W_DATASRC " gets re-generated with a new technical name " /CPMB/09DSZ4X ".

      As we have mapped the BI transformation to BI InfoObject " /CPMB/O9DWZ5X ", transport of the transformation fails as it does not find the BI object. How do we work around this for Scenario 2?

      Regards

      Raghu

  • avatar image
    Former Member
    Jul 22, 2009 at 09:01 AM

    Hello!

    have you ever had the following error?

    Thanks for your input,

    Holger

    -


    Record 4, segment 0001 is not in the cross-record table

    Message no. RSM2716

    Diagnosis

    You created new data records in a routine of the transformation. They do not have a data record number. An error occurred in one of these data records. Since this record does not have a data record number, it cannot be handled by error processing.

    You cannot process the error on single-record basis since this sorts out the corresponding original data records and provides a correction.

    System Response

    The processing of the data package is terminated.

    Procedure

    Copy the data record number (field RECORD) from the original data record into the new data record.

    Example

    DATA: result_fields TYPE tys_tg_1.

    LOOP AT result_package INTO result_fields WHERE accounttype = 'I'.

    result_fields-accounttype = 'E'.

    APPEND result_fields TO result_package.

    ENDLOOP.

    Result

    Each data record of the original package exists twice, once with accounttype = 'I', and once with accounttype = 'E'. The new data records have the same record numbers as the original data records.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi Holger,

      I believe that Velavan modified the code so it would work from text loads as well however I am glad you were able to get this working.

      Cheers, Scott

  • avatar image
    Former Member
    Jul 22, 2009 at 02:43 PM

    Hello all,

    as an information where the error occurs:

    After creating and excecuting the DTP as described in Chapter 3.2.4 of the How-to-Paper.

    We have imported the transports and customized all described steps.

    Best regards

    Holger

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Holger,

      I have not seen this error before. Can you potentially provide some screenshots and the errors from the log? Where does the error occur in the DTP?

      Can you set a breakpoint in the end routine and download your resultpackage to a XLS and send to me?

      I could be of more assistance with additional information.

      Cheers, Scott

  • avatar image
    Former Member
    Aug 10, 2009 at 11:33 PM

    Hi Velavan,

    Can we upload the hierarchy also from BW directly to BPC..for example the account and company code hierarchy we have need to automate the process.

    Can we make the latest hierarchy for accounts , company code from BW to be replicated to BPC?

    Does this process works in BPC currently?

    Thanks Velavan in advance.,.

    Add comment
    10|10000 characters needed characters exceeded

    • Dear Gurus,

      My issue got resolved. So far I'm trying to pull data from R/3>BW>BPC. In the existing land scape BW and BPC are 2 different boxes. That is the reason I couldn't able to see BW objects into BPC (since 2 are different boxes). To resolve the issue I have created a new infoobect (RSD1) in BPC and data loading is from R/3>BPC infoobject(which is created through RSD1)>BPC Dimension.

      Thanks and regards,

      Raju