Deriving 0CALMONTH from other time characteristics

[i807185]

Hi,

I have a <b>datasource</b> that delivers <b>0CALWEEK, OCALQUARTER and 0FISCPER</b> as time characteristics.

I have an <b>Infocube</b> that <b>also</b> contains <b>0CALMONTH</b> as as an additional Time Characteristic.

Is there a <b>way to derive 0CALMONTH from these other time characteristics in the update rules?</b>

Thanks a lot

Christian

[Former Member · Accepted solution]

Hi,

There is a formula called FISCPER_CALMONTH() that computes the the 0CALMONTH from the given 0FISCPER.

You can also use a formula to convert the 0CALWEEK to 0CALMONTH by getting the starting date of the 0CALWEEK and then computing the 0CALMONTH from that date.

DATE_MONTH( WEEK_TO_1ST_DAY( <<<Place 0CALWEEK here>>> ) )

[Former Member]

Hi Christian,

You can use the "automatic time conversion" check in the update rules to convert any of the existing time characteristic for 0CALMONTH. The other option is to use an ABAP routine.

Bye

Dinesh