Example - Allocating a Measure to Levels in a Regular Dimension

You want to allocate sales forecasts, which are created at the Product Line level, to Product Type and Product Name levels, in proportion to actual revenues. The revenues are recorded daily, by product and region.

Procedure

Using the Level property sheet for Product Line (the parent level), you set the Allocation type for theRevenue measure to By Measure.

Results

You check the scope map to confirm your result.

Screen capture - the Level property sheet for Product Line.