Issue in COPY function in IP

[Former Member]

HI,

We are facing an issue in COPY function in IP. Few Time characteristics are not copying from Actual to plan cube. We have Three Actual cubes and one plan cube. We are using COPY function and changing Info provider , currency and version Characteristics.

We have tried with FOX code also but Time characteristics 0CALMONTH2, 0CALQUART1 are not getting copied, They are displaying as # but we have data in all the actual cubes. These chars in Multiprovider are mapped with all the infoprovider.

Kindly Provide your valuable inputs.

Thanks & Regards

[former_member5472]

Hi,

If only two time chars are not getting populated then can you check if the values for these chars are in sync with other time characteristics ?

I mean BI-IP automatically checks for CR of time characteristics. ( if fiscal period is there then fiscal year is automatically derived)

Post all actual values of 6 time characteristics which your are loading into plan cube with actual format.

Also you can check one more thing by hard coding the values for these two char ; Just to check if it is able to write back the data .

It looks like the values are conflicting with other time characteristics values,

Thanks

Pratyush

[Former Member]

Hi Pratyush and Cornelia,

We are not using derivations.

Following is the sample data as it is stored in actual cube

0CAlMONTH = 1

0CALQUART1 = 1

0FISCPER = 2006001

0FISCPER3 = 1

0FISCVARNT = K4

0FISCYEAR = 2006

We have some planning sequences which get excuted through a portal based on a planning template. The planning sequences are failing as they are not getting the input parameters when we run them on portal. We ran the sequences individually through the modeller with the necessary input parameters. The actual cube data is read succesfully but the 2 time characteristic are showing # values.On trying to save the data in the plan cube we get this error "Access via Null object reference not possible.error key: RFC_ERROR_SYSTEM_FAILURE". Please suggest.

Thanks & Regards,

Saurav

Edited by: Saurav Chetry on Jun 6, 2011 4:10 PM

[balajee_sivakumar]

Hi Saurav,

Can you kindly share us whether your planning cube is of the same structure as that of the actual cubes.

And one more thing is can you also inform what is the target infoobject, to which you are trying to copy the time characteristics.

Regards,

Balajee

[Former Member]

Hi Pratyush,

We have 6 time characteristics. Out of these 0CALQUART1 and 0CALMONTH2 are not getting poulated.

We are not getting any errors.

Hi Balajee,

Both the planning and actual cubes are having the same structure.

The target infoobjects are same as in the actual cube.

Thanks & Regards

[cornelia_lezoch]

Hi,

are all your time char included in the aggregation level?

Which are the time char´s?

Do you get any error messages from the derivation? Maybe there is a tim char derivation error.

regards

Cornelia

[Former Member]

Hi All,

This is an high priority issue. Your inputs will be highly appreciated.

Thanks & Regards

[former_member5472]

Hi,

Please check the following settings:

1. the fileds you are copying should be in "fields to be changed"

2. if it is through fox, please check the proper format of the date characteristics ? i.e. mm/dd/yyy or mm.dd.yyy or whatever your system is accepting

3. check fiscal year variant is populated or not ? it should also be copied when you are copying time characteristics

4. Post the error message it is thrwoing if any .

Thanks

pratyush