TM1 Forum

Hello,
I would like the rules of the cube to calculate the depreciation of a capex starting from the month the capex cost in incurred to
(i) end of the year
(ii) end of 3 years.

For example, in June, a forecast for Capex worth $36,000 happens.
I would like to show depreciation
June -$1000
July-$1000
Aug-$1000
.
.
Dec - $1000
What would the syntax of the rules look like ?I am stuck at the allocating for each month starting in June...Help!!

What the rules are going to look at will depend on the depreciation method.

One thing I would recommend is to use a cube with a combined year-month dimension for calculating depreciation as many depreciation methods can then be calculated using consolidations or a combination of consolidations and rules which is faster and more efficient than a pure rules approach.

It is probably also going to be useful to have a lookup cube(s) for asset classes, depreciation methods and applicable ratios.