A member set can be
flat, with all dimension members organized as siblings, or members can be organized
into a hierarchy, with some dimension members designated as parents and other
members designated as child elements, nested below the parents in the hierarchy.
When organized into a hierarchy, parent members in member sets represent
dimensions subtotals of child members. Thus member sets can be easily used to
create subtotals in a form or report generated by the PPS Planning Application. The
dimension member sets are similar to dimension hierarchies in SSAS OLAP cubes
and, in fact, the member sets are defined as parent-child hierarchies when a SSAS
OLAP cube is created for the model during the model site deployment phase.
A member set should include all the members that are required from a dimension
for the calculations that will be performed by a model or group of models. One
approach to designing member sets is to determine which calculations will be
used in a given model. Then you should work backward from those calculations to
determine the members that will be required from each dimension, and include those
members in member sets from each dimension. The rest of this section will describe
how member sets can be defined for dimensions. The Entity dimension is selected to
demonstrate creation of member sets in this chapter.
The first step in creating a member set is to click the link Create a Member Set
from the Dimension Tasks pane after Checking Out the Entity dimension.
Pages:
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334