SAP BPC 10- loading data to BW error for month

[Former Member]

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

[ashwin_kulkarni2 · Accepted solution]

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.

[Former Member · Accepted solution]

Hi Ashwin,

So as u said, we can upload the the below data directly from BPC to BW:

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

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

Can you please let me know the steps or any SAP notes which states the entire process.

Thanks,

Red

[Former Member · Accepted solution]

Hi,

There is no direct way to load BPC data to BW.

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.

[ashwin_kulkarni2]

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.

[Former Member]

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.

[Former Member]

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

[Former Member]

Hi,

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

Hope this helps.

Regards,

[RamanKorrapati]

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

[Former Member]

Hi Raman,

I tried all combo but still error persist. Can you please let me know any other alternative to to resolve this issue.

0CALMONTH

datatype: NUMC-Char with Digits only

Lenght 6

Output Lenght: 7

[RamanKorrapati]

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