TM1 Forum

Hi Guys,

I wanted to know how to perform the below task .

I have a cube with months dimension like
Year - 2018
Month - 201801
Date - 2018-01-01

Now this is calendar year and values are stored in day level.
Now there is a rule in the cube which goes to exchange rate cube which has a different month dimension at month level .

Fiscal year
201801 is 201807 in the exchange rate cube .

Now in my rule for the days I have to do a n level rule and get the correponding fiscal month value from exchange rate cube.

[ Currency:'EUR', Lease Measures:'Right of Use Asset' ] = N: ([ Currency:'Local Currency', Lease Measures:'Right of Use Asset' ] * (DB( 'Exchange Rates', 'Actual', ATTRS( 'Companies', !Companies, 'Functional Currency' ), 'EUR', 'Ending Rate', 'convert 2018-01-01 to 201807' ));

I am thinking of some substring function, but then I have to get the fiscal year equivalent.

If anyone can suggest some logic in the rule , it would be of real help.

Thanks,

You could use an attribute at the day level and retrieve that value ?

so you are asking me store an attribute at day level .

so for 2018-01-01 i store an attribute value of 201807 right?

That should work ,let me try that.

Thanks,

Exactly.
Or, you rework the day element to a month name, which itself has an attribute to the related month name. That can be an option too.