All of the views that follow display a planning enabled measure item named Plan Units Working. The valid hierarchies for its Category are Customer Class, Product, and Region.
In the first example, Products by year are displayed. The cells that contain existing values for 2014 and 2015 can be updated since planning updates can be made at any level of detail for existing data. The blank cells for 2014 through 2016 cannot be updated since all the valid hierarchies for Plan Units working must be represented in this view in order to update blank or zero cells.
In the next example, Customer Class is displayed on rows. Years and Quarters are on columns. The existing values for all quarters of 2015 can be updated. The blank cells for 2016 cannot be updated since all the valid dimensions for Plan Units Working must be represented in this view in order to update blank or zero cells.
The view that follows represents all the valid hierarchies for Plan Units Working - Customer Class, Product, and Region. Therefore, it meets the requirements for planning on zero and blank values in detail cells* as well as planning on existing values in detail cells. This view setup also meets requirements for planning on existing values in subtotal and total cells that are on the axis opposite from measure items – in this case, you can plan on those subtotal and total cells on rows but not on columns since measure items are on columns.* Notice that the view does not need to display the lowest level of the time hierarchy. Only the Year level is displayed. When you change blank or zero values and the view is not drilled to the lowest level of time, the values you enter will be evenly divided among all periods, in this case for the year.
Note: Total and subtotal cells with zero or blank values cannot be updated – which is a standard rule for any type of planning views.
Here is a slightly different set up for the view using all the valid hierarchies for Plan Units Working. Region is in the View Filter, filtered by a single member. Customer Class and Product are on rows and their display text is set to their Long Description attribute relationships rather than their values. Year and Months from the Year Months hierarchy are displayed in columns. This example meets the requirements for planning on zero and blank values in detail cells as well as planning on existing values in detail cells. It also meets the requirements for planning on existing values in subtotal and total cells on the axis opposite from measure items (rows is the opposite axis in this case).
In this example, time hierarchies exist on both the row and column axes. When time hierarchies exist on both axes, planning updates can be made only to cells with existing data. Zero or blank cells cannot be updated.
The final example has a level displayed on rows that is a hierarchy-enabled attribute relationship for Product, which is one of the valid hierarchies for the Plan Units Working’s measure Category. Planning can be done on the existing values in the detail and total cells. Planning cannot be done on zero or blank values in this view because not all of the dimensions for Plan Units Working are visible in the view.
