Calendar
hierarchy in the Columns. Now, in the Hierarchies tab, the user expands the Customer
dimension and then double-clicks on the Customer Geography dimension. This
opens the Select Items tab with Default (All Customers) selected. Expanding the
All Customers member will reveal the members of the Country level. Selecting one
of these items will automatically put the Customer Geography in the Background.
Selecting two or more members will keep the Customer Geography hierarchy in
the background but a Slicer will appear above the chart. In addition, an icon will
appear next to the Customer Geography dimension to show that it is sliced. This
symbol is shown in the illustration below left. This is fine if the desire is to keep
the items separate, selecting one at a time by choosing them in a Slicer. If the goal
is to combine the choices and sum them, clicking on the icon changes it to one
representing combined items. This icon is shown in the illustration on the right below.
C h a p t e r 6 : A n a l y s i s w i t h P e r f o r m a n c e P o i n t S e r v e r a n d P r o C l a r i t y 175
The Select Items tab also has a very powerful tool; the ability to search through
the members of a hierarchy. Clicking the Search button opens a simple textbox in
which the search criteria can be entered, and clicking on Go will search all members
at all levels of the hierarchy. ProClarity users will need to exercise caution as the
search may lead to unexpected results.
Pages:
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238