AS2000-OLAP Cube (Distinct Count) & OWC11 - Pivot Tables

[Graham Marko]

I have a problem with Office Web Components (OWC11) - Pivot Tables involving
an AS2000-OLAP Cube Distinct count problem. All the totals work fine if none
of the rows or columns are filtered.

Once I try to filter any of the dimensions in the cube, I get a Formula
Error.

If I filtered any of the rows or columns when using the distinct count I
would get a "#VALUE!" in the Grand Total column or row.

If I mouse over the entire error message read: "Formula error - aggregations
are not supported for the DISTINCT COUNT measure "DistinctUsers" - in the
Aggregate function.

If I do not choose a DistinctCount for Totals and I choose <a simple measure
count> everything works fine. Including all the filtering.

Is anyone aware of this issue. Do you know of any solutions? If this is a
legitimate Microsoft bug, how can we go about getting this resolved. Do you
have Microsoft connections to speed up the process.


Any help on this issue or related issues would be greatly appreciated.

I have heard from some web posting that this was not an issue with OWC9 but
it is with OWC10 &11. Using OWC 9 would be an acceptable solution for the
customer.


I have also seen a lot of references that this issue is not a problem in
SQL2005.


Here are some related links I have found and tracked etc

http://www.databasejournal.com/features/mssql/article.php/10894_3482536_1

http://www.databasejournal.com/features/mssql/article.php/10894_3454931_2

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql2k/html/distinct2.asp

http://www.awprofessional.com/articles/article.asp?p=29580&rl=1



Thanks

Graham Marko

 

[Jose A.Aznar]

I have the same problem as you
Have you soved it?
It you have solved the problem i'll aprecciate if you tell me how
Jose A.Aznar
(e-mail address removed)

 

[Jose A.Aznar]

I have the same problem as you
Have you soved it?
It you have solved the problem i'll aprecciate if you tell me how
Jose A.Aznar
(e-mail address removed)