All time infoobjects are clubbed together in transformation of 0IC_C03

[Former Member]

Hi All

I am working on inventory Cube 0IC_C03, I have a requirement to get the MAP price in this cube . Since MAP price is based on Fiscal Period not on calday . I want to pull MAP data in this cube based on calmonth. But in the transformation of the Cube 0IC_C03 I can see all time infoobjects are clubbed together in infoobject 0CALDAY . How can I use 0CALMONTH for transformation.

PLease help

Regards,

Jagriti Jha

[KodandaPani_KV]

Hi,

its mapped to one many relationship.

basically we give mapping form data filed to another time char filelds like calday,calmonth.calyear, calmonth2.

you can add the cube leve OCALMONTH under the time dimension -> activate the cube and transformation check it out.

Thanks,

Phani.

[Former Member]

Hi Phani

Thanks for your reply , but I tried that as well . That doesn't work . Still I can see 0CALMONTH in transformation as it's being calculated based on calday which we pass.

[former_member186399]

Dear Jagriti,

Calendar day in basically mapped to posting date of the GR and all other time characteristics are derived using this calendar day. So you will have to bring in the MAP for each calendar day ( convert the day to month)

Regards

Gajesh

[Former Member]

Hi Ganesh

Thanks for your reply !

I understand that 0CALMONTH is being calculated based on 0CALDAY which we pass in 0IC_C03 cube .

My problem is that MAP is always based on Fiscal Period , I think we can't have MAP based on CALDAY .

I wanted to map the Fiscal Period to 0CALMONTH in 0IC_C03 , but as I mentioned I am not able to do that as it's being calculated based on 0CALDAY .

Is there any workaround . I have to include the MAP in this Cube and I have to do some calculation on MAP price.

regards,

Jagriti Jha

[former_member186399]

Dear Jagriti,

You will have to use a work around solution to do this. If you  are trying to fetch MAP in BW make use of the end routine in 0IC_C03 . use Calmonth (convert it into fiscper using FM

UMC _CALMONTH_TO_FISCPER) and get the MAP.

Regards

Gajesh

[Former Member]

HI Ganesh

thanks for your suggestion but I have one question . I will get the MAP in cube also , the value for this will be doubled everytime as I am loading this to cube .

I tried the exception aggregation Last value for infoobject 0price_avg ( MAP) , but still I got double value  as First I loaded the BX data then BF.

Do you have any idea .... how I can solve this.

Regards,

Jagriti Jha

[former_member186399]

Dear Jagriti,

Try using an infoobject with exception aggregation as last value and agg reference char as cal day.

refer to infoobject 0HDCNT_LAST.

Regards

Gajesh