Hi, Experts:

We need to limit the cube access using standard roles with visual
totals enabled. It means that the user that is allowed to view Canada
only, must not view the grand total for all the countries. The problem
is that our cube has the distinct count measure. I have found an
article in the support of Microsoft that explains that the problem is
solved in the Service Pack 4 of Analysis Services. Here you have the
article's address:

http://support.microsoft.com/kb/829897/en-us

I have applied the ServicePack 4 , but it has not solve the problem.
What is worse, whenever I see data in any dimension using Analysis
Services I obtain one of two following errors:

1. Unable to retrieve children: Key is not unique in collection
2. Unable to retrieve children: Object or provider is not capable of
performing requested operation

If I try to view the dimension data from external tools (mdx sample,
ProClarity, c# code etc.) everything works fine.

I have 2 questions:

1. How can I get rid of the "unable to retrieve children" error? (I
am not in favour of the idea of reinstalling Analysis Services)
2. How can I enable visual totals in a cube with distinct count
measure?

I use Windows 2000 Advanced Server with Service Pack 4. The MDAC
version is 2.81.117.6 and the Analysis Services has the Service Pack 4
applied.

Regards
Maciej Kiewra

Visutal Total doesn't works with DCount aggregated measures.
(SP4 or not, this doesn't works)

Simply because AS has not enough information to evaluate this.

you have to create a dynamic distinct count measure. In this case the visual
total works fine.
But its slower.

Another way is to disable for the user the access to the "all member" (or
All countries)

AS2005 will provide a better support for DCount measures.


<mkiewra (AT) mail (DOT) fujitsu.es> wrote