Deriving 0CALMONTH from other time characteristics
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
Emmanuel Nepomuceno replied
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>>> ) )