monthly FX conversion for months and quarters
I have a scenario whereby my entities enter (YTD) data monthly. The FX conversion is defined with the "apply periodic" option, so it should work out the periodic change and apply the FX rate to that change. This works absolutely fine.
I now need to add entities that only enter data on a quarterly level. If I simply let them enter data in periods MAR, JUN, SEP and DEC the FX converison won't work, since it will work out the monthly change rather than the quarterly.
I though about in my time dimension having months (JAN to DEC) and quarters (Q1 to Q4) as base level elements all adding into the year. I would give JAN and Q1 a value of 1 for IS_BEGINNING.
Should this work and calculate the correct FX conversion for my quarterly data?