0CURMEM_CALDAY use in CMOD?

[Loed]

Hi,

Anyone here already tried to use the 0CURMEM_CALDAY in CMOD?

Or anyone here knows the FM of 0CURMEM_CALDAY?

I was able to search for this FM but not sure if this is the FM used by all the CURRENT MEMBER variables.

RRS_CURMEM_FROM_VREP_FILL

Anyone here knows how to use the above FM? Is it the CURRENT MEMBER variables FM?

What I wanted to achieve is to know the SUM of last 12 months based on the CURRENT CALMONTH in the row.

So if it is JAN 2020, will be the sum of JAN 2019 to DEC 2019.

If it is JUL 2020, will be the sum of JUL 2019 to JUN 2020.

Anyone here knows if this is possible without using 0CURMEM_CALMONTH or any CURRENT MEMBER function?

Thank you.

Loed

[KonradZaleski]

Hi Loed,

It is possible by creating a range on 0CURMEM_CALMONTH with the offset from 0CURMEM_CALMONTH - 1 to 0CURMEM_CALMONTH -12 .

See the attached screenshot:

[Loed]

Hi Konrad,

Yes I can achieve my requirement by using 0CURMEM_CALMONTH. What if I don’t want to use the CURRENT MEMBER function. Any other way to achieve it?

Thanks.

Loed

[KonradZaleski]

You could query your source object 12 times on Composite Provider level. For each instance you would need to add calculation for date to Add month (+1, +2...+11). Then for each instance, map this calculated date to your regular date field. Other columns should be mapped same way as the first instance. Then you can sum all the KF from each instance.

On query level I don't see any other option than using CURRENT MEMBER functionality

[Loed]

What do you mean by query the object 12 times? Is it 12 times loading?