You maintain a SQL Server 2008 Analysis Services (SSAS) database that contains a
dimension named Customer.
You need to configure the Dimension Data settings to meet the following requirements:
Deny access to the {[Customer].[Country].&[Germany],[Customer].[Country].&[France]} set
of attribute members.
New members added to the attribute are visible by default. What should you do?
A.
Add all the country members except those of France and Germany to the Allowed Set
property.
B.
Add the following set to the Denied Set property.
{[Customer].[Country].&[Germany],[Customer].[Country].&[France]}
C.
Add the following set to the Denied Set property.
Except([Customer].[Country].[Country],{[Customer].[Country].&[Germany],[Customer].[Count
ry].&[
France]})
D.
Add the following set to the Allowed Set property.
Extract({[Customer].[Country].&[Germany],[Customer].[Country].&[France]},[Customer].[Cou
ntry])