Skip to Content
avatar image
Former Member

SAP BPC 10- loading data to BW error for month

Hi,

When I try to load below data from flat file to BW I get error:

Ccode, Account, Cal Month, Year, Product, Customer, Amt in Local Curr, LC

20, REVENUE, 01/2009, 2009, CK2000, C1, 10000, USD

Error: 'Enter period in the format __.YYYY' at conversion exit CONVERSION_EXIT_PERI6_INPUT (field CALMONTH record 1, value JAN2009)

Message no. RSDS012

I tried to replace 01/2009 with many combination like 1/2009 OR 1-2009 OR 2009/01, etc but still I got the same error.

Request you to please help me to resolve this error.

Also, I am following a book to perform above demo. Can you please let me know, is it necessary to upload data via BW.

Instead don't we have any option where we can directly load data from BPC to BW for the above scenario.

Also, if it has then please let me know and though I am not sure if the error will still persist.

System details:

SAP BPC NW 10

SAP BW 7.3

Thanks,

Red

BPC.png (28.0 kB)
Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

6 Answers

  • Best Answer
    Jun 24, 2013 at 07:48 AM

    Hi Red,

    Please write your time format as 2009.001 or 2009.01 or 2009.JAN.

    Instead of using commas or /, please use dot in your time format. It will work.

    It is not necessary to upload data from BW to BPC. You can upload data to BPC from flat file as well provided the file is in csv format. You can upload this csv file to BPC server and then run import package to load data into BPC. Make sure you have all the dimensions present in your BPC.

    Hope it helps.

    - Ashwin.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jun 24, 2013 at 05:59 AM

    Hi Red,

    I have slight issue to comprehend the question. (1) Are you uploading the flat file in BW (2) Are Uploading from BW to BPC. As per my understanding, I would give few solution.

    enter period in the format 01.YYYY (01.2009 or 02.2010 or 03.2011) and then try to upload it.

    Your 2nd question that " Is it necessary to upload the data from BW". I would say that it is not necessary. In BPC, you can upload through flat file provided that you need to map it according to that flat file and use another data manager package (especially for flat file).

    I would suggest you to upload Transaction Data straight away to BPC through Flat File. its time consuming first to upload into BW and then move data in BPC from BW.

    Hope it helps. if not please reply, will try best to solve it

    Thanks

    Varun

    Add comment
    10|10000 characters needed characters exceeded

  • Jun 24, 2013 at 05:35 AM

    Hi Red,

    As the length of the 0calmonth you need to enter values. have you tried to enter like this 01.2009, or 2009.01 or 200901 or 012009.. try those formats and check it . it may works. message itself saying you need to use formate as 01.2009

    plesase check calmonth info object length and enter the values accordingly in desired formate.

    Thanks

    Add comment
    10|10000 characters needed characters exceeded

    • Hi Red,

      Thru flat file are you loading into BW Cube?

      if yes then your flat file need holds 6 digit number for 0calmonth object.

      if you load flat file 0calmonth values as 200901 or 012009, then only load will continue or it may through error.

      As suggested by Ashwin, directly you can load Flat file data into BPC respective model. but in bpc it may accepts 7digit(or more up to 60 digits) format. so accordingly you need to load data from flat file.

      if you load directly into bpc, use 0calmonth(TIME Deimension) value as 2009.JAN.

      bit confused , actually where to where your loading? Flat file to BW or BPC to BW or Flat file to BPC?

      if target object have more digits than source object length , then no problem. if target object have less length(digits) than source, its create problem.

      Thanks

  • avatar image
    Former Member
    Jun 24, 2013 at 05:41 AM

    Hi,

    Try to load data by changing/Maintaining your file as 012009 or 01.2009.

    Hope this helps.

    Regards,

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jun 24, 2013 at 06:05 AM

    Hi Red,

    To load to BPC from Flat File or BW:

    You have to configure a transformation file and conversion file(optional) to load data from BW to BPC or from flat file to BPC.

    Please refer these links (Transformation file)

    http://help.sap.com/saphelp_bpc75_nw/helpdata/en/66/348113c47b4ae7b2f068b88047d02b/treedata.htm

    and (Conversion file)

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

    Once you have configured and validated the transformation file you may use the standard data manager package

    /CPMB/LOAD_INFOPROV_UI to load the data to BPC cubes.

    To Load from BPC to BW:

    Please refer the below note

    https://websmp130.sap-ag.de/sap(bD1lbiZjPTAwMQ==)/bc/bsp/spn/sapnotes/index2.htm?numm=1730125

    You may also refer note 1816165 .

    BPC exposes its data through virtual provider.

    Hope this helps.

    Regards,

    Kalyan.

    Add comment
    10|10000 characters needed characters exceeded

  • Jun 24, 2013 at 07:49 AM

    Hi Red,

    Please write your time format as 2009.001 or 2009.01 or 2009.JAN.

    Instead of using commas or /, please use dot in your time format. It will work.

    It is not necessary to upload data from BW to BPC. You can upload data to BPC from flat file as well provided the file is in csv format. You can upload this csv file to BPC server and then run import package to load data into BPC. Make sure you have all the dimensions present in your BPC.

    Hope it helps.

    - Ashwin.

    Add comment
    10|10000 characters needed characters exceeded