Technical data

Using Built-in Functio ns in Analytic Models Chapter 11

Now s uppose that you p lan to build a new building in 2006, and you want to spread the building costs over the

quarters of that year. On the other hand, you do not want to allocate the building costs to any other years. If the

year and building costs are stored in data cubes called BUILDING_YEAR and TOTAL_BUILDING_COSTS,

you can calculate the QTRLY_BUILDING_COSTS data cube as follows:

IF(YEAR( ) = BUILDING_YEAR, TOTAL_BUILDING_COSTS / 4, 0)