#ERR in Analysis Browser when using Distinct Count measure 
Author Message
 #ERR in Analysis Browser when using Distinct Count measure

We are setting up most of our securities based on our Organisation
dimension which has the following structure:

- Geographical Location
- Division Name
- Department Name
- Business Unit.

When I restrict a certain user to a certain full Division (i.e. a
division manager) and there is a Distinct Count measure in the cube I
retrieve always #ERR in the Analysis Browser (V8.0) and in Excel XP
(#Valid!).

But this does not appear on the lowest level (Business Unit), there I
retrieve correct figures. Has the Analysis Server problems with the
aggregations of distinct counts, when I restrict any members ?

This problem also not appears for users with full access rights !

Did anybody else get the same error ?

Please help,

dajm

--
Posted via dBforums
http://www.***.com/



Sat, 25 Dec 2004 14:52:42 GMT
 #ERR in Analysis Browser when using Distinct Count measure

 Dajm,

 I can explain this error if you dimension security role says "Use Visual
 Totals".
 For Distinct Count measure it is impossible to calculate visual total
value,
 and showing the real (non visual total) value would be a security hole,
 since the role explicitly asked for visual totals. Therefore Analysis
 Services has no choice, but to return an error.
 On the lowest level, the visual totals and real totals are always the same
 (because leaf members don't have children), therefore, there it's OK to
 return the real values.

 You can disable Visual Totals on the dimension security, and then you won't
 get the #ERR's, but your users will see the real aggregates.

 HTH,
 Mosha.

 --
 ==================================================
 Mosha Pasumansky (moshap at microsoft dot com)
 Development Lead in the Analysis Server team
 All you need is love (John Lennon)
 Disclaimer : This posting is provided "AS IS" with no warranties, and
 confers no rights.
 ==================================================

Quote:


> > We are setting up most of our securities based on our Organisation
> > dimension which has the following structure:

> > - Geographical Location
> > - Division Name
> > - Department Name
> > - Business Unit.

> > When I restrict a certain user to a certain full Division (i.e. a
> > division manager) and there is a Distinct Count measure in the cube I
> > retrieve always #ERR in the Analysis Browser (V8.0) and in Excel XP
> > (#Valid!).

> > But this does not appear on the lowest level (Business Unit), there I
> > retrieve correct figures. Has the Analysis Server problems with the
> > aggregations of distinct counts, when I restrict any members ?

> > This problem also not appears for users with full access rights !

> > Did anybody else get the same error ?

> > Please help,

> > dajm



Mon, 27 Dec 2004 04:22:18 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. #ERR in Analysis Browser when using Distinct Count measure

2. Using a Calculated Measure to Sum a Distinct Count Aggregation Type

3. Measures Using COUNT DISTINCT

4. Two Distinct Count measures

5. Distinct Count on Text Measures???

6. Many distinct counts in a measure/fact table ?

7. Cognos PowerPlay Transformer [Distinct Count Measure]

8. Distinct Count on Text Measure

9. distinct count measure - olap 2000

10. distinct count measure

11. Measure Aggregation - Distinct Count

12. How-To set "Distinct(Count" measures


 
Powered by phpBB® Forum Software