BPC loading BW trans data to BPC with selection on 0FISCPER

[former_member728473]

Hello ,

I am trying to load the data from BW to BPC with the selection on 0FISCPER  format example : 2012012 . However whenever i load with this selection the package in BPC fails with the error message "The current value in the selection is not in the format required" . Can someone help me resolve and load the transcation data ?

Transformation file :

*OPTIONS

FORMAT = DELIMITED

HEADER = YES

DELIMITER = ,

AMOUNTDECIMALPOINT = .

SKIP = 0

SKIPIF =

VALIDATERECORDS=NO

CREDITPOSITIVE=YES

MAXREJECTCOUNT=

ROUNDAMOUNT=

CONVERTAMOUNTWDIM=CENTROCUSTO

*MAPPING

CATEGORY=0VTYPE

EMPRESA=0COMP_CODE

CENTROCUSTO=0CO_AREA+0PROFIT_CTR

CLASSE=0ACCOUNT

TIME=0FISCPER

VERSAO=*STR(INICIAL)

SIGNEDDATA=0CREDIT

*CONVERSION

TIME=FISCPER.XLS

AMOUNT=inverte_sinal.xls

CONVERSION file : FISCPER.XLS

EXTERNAL     INTERNAL

????001     ????.JAN

????002     ????.FEB

????003     ????.MAR

????004     ????.APR

????005     ????.MAY

????006     ????.JUN

????007     ????.JUL

????008     ????.AUG

????009     ????.SEP

????010     ????.OCT

????011     ????.NOV

????012     ????.DEC

[former_member728473 · Accepted solution]

Hi Gersh,

I found this Note 1695530:Error 'Time is not in required format' when loading data .  Do you think its applicable ? 

we are BPC 7.5

Regards

Ram

[former_member200327 · Accepted solution]

Hi Ram,

It's applicable if you are on SP04 - SP12, or SP02 - SP03 of BPC 7.53.

It seems applicable if your BW InfoCube has non-cumulative key figures (like in and out of inventory). From the example you posted it doesn't look like non-cumulative, so I doubt it will help.

Regards,

Gersh

[former_member728473 · Accepted solution]

Hi Gersh,

Yes, i do understand . Nothing else worked till now , so giving it a shot. Will get back to you here with the results .

Thanks again .

Regards

Ram

[former_member728473 · Accepted solution]

Hi Gersh,

We did implement the note 1695530 and indeed it resolved the issue with the time format .

However i am able to select only 1 0FISCPER  per execution, if i select 2 0fiscper per execution for example it fails :  

0FISCPER  -  2014001 

0FISCPER  -  2015001

0FISCVARNT - K4

Is this the way this would work or am i doing something wrong ? Your thoughts please .

regards

Ram

[former_member200327 · Accepted solution]

Hi Ram,

No, failure is not by design. Please share what error do you get now.

Gersh

[former_member728473 · Accepted solution]

Hi Gersh,

Thanks for all the help .  Looks like 1695530 did resolve the issue . The below example does work .

0FISCPER  -  2013001

0FISCPER  -  2012001

0FISCVARNT - K4

My last update  on  Mar 13, 2015 3:20 PM  was due to the fact that ..the period which i selected had blank records causing the package failure. I tried a different period and it worked fine .

Thanks once again .

Best Regards

Ram

[former_member223749]

Hi,

Try below conversion file.

*004	*.APR
*005	*.MAY
*006	*.JUN
*007	*.JUL
*008	*.AUG
*009	*.SEP
*010	*.OCT
*011	*.NOV
*012	*.DEC
*001	*.JAN
*002	*.FEB
*003	*.MAR

Hope this will help you.

Regards,

Devi

[former_member190501]

Hi,

Did you assign fiscal variant ?

Thanks,

Raju

[former_member223749]

Hi,

Yes we do assign fiscal variant as V3 and K4, in my case we have converted fiscal period to calmonth.

Regards,

Devi

[former_member190501]

Hi,

OFISCPER format is YYYYMMM. Try to filter by both variant and period in selection.

Thanks,

Raju

[former_member728473]

Hello Varaprasad/Devi,

We do not have fiscal variant  data in our source , so we did not map it.  we are using only 0fiscper. 

Is 0FISCvariant.  mandatory ?   Are you saying we need to select it  fiscal year variant along 0fiscper in Selection ??

regards

Ram

[former_member200327]

0FISCVARNT is not mandatory per se, but 0FISCPERIOD is compounded with it. Hence whenever you use 0FICPERIOD you have to use 0FISCVARNT.

Now something is strange with your screen shots. You said that you didn't map 0FISCVARNT when you loaded the cube - this should male it blank if such value exists. You screen shot of data in cube shows it populated.

Can you please clarify this discrepancy?

[former_member728473]

Hi Gersh,

Thanks for your reply. Ok understood about the compounding part.

The cube data posted was of the Source cube not the BPC cube.  We have mapped only 0FISCPER  to a DIM in BPC. When i try to load  data from BW cube to BPC cube with /CPMC/LOAD_INFOPROVIDER_UI  i get the error mesg. not accepting the format of 0FISCPER (YYYYMMM)  provided as input .

Hope the above clarifies.

Regards

Ram

[former_member200327]

Hi Ram,

In selection screen of your load do you have an option to chose Fiscal variant? If you have, can you choose value as K4 there?

Regards,

Gersh

[Former Member]

hi Ram,

When you validate the transformation file, did you encounter any errors?

Andy

[former_member728473]

Hi Andy,

The same transformation file works fine , if i do a full load without any selections . So doesnt seem to be a issue with the transformation file .

However in PROD we have a huge volume of records from 2007 - 2015 . But in BPC we need only 2 months data 2014001 & 2015001 . So i am trying to use with the selections on 0FISCPER which doesnt seem to work .  Any other thoughts ?

regards

Ram

[Former Member]

Hi Ram,

Can you please take a screen shot of the data in BW?

Andy

[former_member728473]

Hi Andy,

Thank you once again . Here are few records from the cube :

0COMP_CODE	0CO_AREA	0PROFIT_CTR	0ACCOUNT	0VERSION	0VTYPE	0FISCPER	0FISCPER3	0FISCVARNT	0FISCYEAR	0CURRENCY	0CREDIT
1003	INDA	0000002868	0000321506	000	10	2015001		K4		USD	-354234
1001	INDA	0000000136	0000321506	000	10	2015001		K4		USD	324.02
1003	INDA	0000000145	0000321506	000	10	2015001		K4		USD	1380999
1101	INDA	0000001239	0000321506	000	10	2015001		K4		USD	-471.01
1006	INDA	0000001644	0000321506	000	10	2015001		K4		USD	-731.47

Regards

Ram

[Former Member]

Hi Ram,

Ok, in your selection screen make sure you select the correct fiscal period info object, sometimes they have similar names, so many try select a difference one with similar name.

the format will be YYYYMMM

Andy

[former_member728473]

Hi Andy,

Just tried all of them related to TIME dim, still the same The current value in the selection is not in the format required".  any other thoughts ?

I dont think it matters , but just thought would share ..

Source

0FISCPER

@1T@

Exercício/período

NUMC

7

PERI7

Destination

/CPMB/D9DKGYS

@81@

Time

CHAR

20

Regards

Ram

[former_member186338]

Can you show a selection screenshot?

Vadim

[former_member728473]

Hi Vadim,

Thanks for the quick response. screenshot below . I have also tried various other input formats . YYYYMMM , MM.YYYY , YYYY.MMM,YYYY.MM. all of them have failed with the same mesg. as mentioned above.

[former_member186338]

But I see here MMMYYYY

Vadim

[former_member728473]

have tried MMMYYYY, YYYYMMM , MM.YYYY , YYYY.MMM,YYYY.MM all of them have failed with the same mesg. "The current value in the selection is not in the format required".

what am i doing wrong ?

Regards

Ram

[Former Member]

Hi Ram,

Goto RSA1, select your BW cube from infoproviders, and try to display thedata.

after displaying the data, check the format of 0FISCPER and try the same in selections.

Regards,

Balraj

[former_member728473]

Hi Raj,

Thanks for your reply.

Listcube  shows 0fiscper in the following format 2012012

F4  of 0fiscper shows in the following format      012.2012

I have tried both the formats in the selection , i still get the same error . I have posted the Transformation & conversion files .  Can you please have a look and tell me if i am missing anything ?

Regards

Ram