Securing Your Data in Analysis Services - Professional SQL Server Analysis Services 2005 with MDX - page 1004

Figure 19-27
4. Delete the count measures created by the intellicube wizard for both
the measure groups because they are not needed for analysis in this
scenario. The response measure contains a value corresponding to
response whether the employee agrees or disagrees to the question.
Make the AggregationFunction (a property of the measure) for the
response measure as Count instead of Sum since we want to ana-
lyze how many users agreed or disagreed to the poll questions.
5. Open the Employee dimension editor and rename the key attribute
from Employee to Employee id. Then rename the parent attribute
hierarchy as Employee so that you can browse the employee hier-
archy. Make the named column for the key attribute of the employee
dimension point to the named column Name so that when you
browse the parent-child hierarchy you see the names of the employ-
ees instead of the ids.
6. In this business example, managers are also involved in the survey.
You need a way to distinguish the responses of the manager against
the responses of the aggregated results of the direct reports. In order
to distinguish the results, set the MembersWithDataCaption property
of the parent attribute to "(* data)" as shown in Figure 19-28 .