278 B u s i n e s s I n t e l l i g e n c e w i t h M i c r o s o f t O f f i c e P e r f o r m a n c e P o i n t S e r v e r 2 0 0 7
When the user clicks on a link for any active assignment, the assignment Form
opens up in the Excel work space, similar to the one seen in the top right quadrant
of Figure 7-40. The data entry region where the user can enter the plan data is
highlighted in yellow color in the Excel worksheet. Here the user can enter the
plan data. By default, the users can enter data only in the cells that represent the
leaf level of all the dimensions. However, Spreading of Data Entry can be turned
on in the Options, which will allow the users to enter data at non-leaf levels as
well. Spreading can be done evenly across all the children of the data-entry level,
or based on the ratio of pre-populated data in the cells. In the example shown in
Figure 7-40, the Account dimension members Airfare, Meals and Entertainment, and
Hotel represent some of the leaf levels of the Account dimension, whereas member
Travel Expenses is not a leaf level member. So, by default, the user will not be able
to enter data directly to the Travel Expenses row. The data that is entered at the leaf
level members of Airfare, Meals and Entertainment, and Hotel will automatically
be summed up and presented at the Travel Expenses level. If Spreading is turned
on, data can be directly entered at the Travel Expenses level and it will be allocated
to the leaf levels of Airfare, Meals and Entertainment, and Hotel depending on the
spreading type selected.
Pages:
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363