Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Deriving 0CALMONTH from other time characteristics

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

replied

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

0 View this answer in context

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question