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!!
Rules to populate every month till end of the year
-
lotsaram
- MVP
- Posts: 3703
- Joined: Fri Mar 13, 2009 11:14 am
- OLAP Product: TableManager1
- Version: PA 2.0.x
- Excel Version: Office 365
- Location: Switzerland
Re: Rules to populate every month till end of the year
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.
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.