cancel
Showing results for 
Search instead for 
Did you mean: 

Deriving 0CALMONTH from other time characteristics

i807185
Associate
Associate
0 Kudos
198

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

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

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>>> ) )

Answers (1)

Answers (1)

Former Member
0 Kudos

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