L
Lautlos
Dear Reader,
I have a problem in the PivotTableControl concerning filtering a dimension
that contains members that only differ in the upper or lower case of one or
more letters.
The collation on the SQL-Server is case sensitive, the registry keys for the
Analysis Server are adjusted. OWCs are the newest downloadable versions,
SQL-Server and Analysis Server are SP3a.
Without Filtering the data is displayed just fine:
Total
Group Member
L A-12 1
A-bR 3
A-Bb 2
A-BB 4
Total 8
But when I apply a filter, removing the all-members and then add just A-Bb
and A-BB then I get:
Total
Group* Member
L A-Bb 2
Total 2
Furthermore, when I leave the all-members untouched and remove all the
members (one after the other) but leave A-Bb and A-BB, the result is the
correct one:
Total
Group* Member
L A-Bb 2
A-BB 4
Total 6
I tested this behaviour with owc10 and owc11 (directly on server and on an
extra client). For the owc10 there is a reproducable way to crash the IE6,
with the owc11 it just does not work correct. I also browsed and googled and
read an tested for a long time. Switching all settings, DBs and registry keys
to binary compare, e.g. does not solve the problem, only switches the order
of the entries...
So it seems to me, that the settings are right (it is displayed and
calculated correctly without filtering) and the filtering algorythm ignores
the case of the letters in the filter collection...
Has anyone encountered the problem before and found a solution? Changing the
way the Members are build is all but impossible. Too many dbs and
applications depend on that.
BTW, the rumors and hints from M$ to discontinue the OWCs for a better paid
Excel-Service-Platform just made my day... :-(
Clear Skies,
Thomas
I have a problem in the PivotTableControl concerning filtering a dimension
that contains members that only differ in the upper or lower case of one or
more letters.
The collation on the SQL-Server is case sensitive, the registry keys for the
Analysis Server are adjusted. OWCs are the newest downloadable versions,
SQL-Server and Analysis Server are SP3a.
Without Filtering the data is displayed just fine:
Total
Group Member
L A-12 1
A-bR 3
A-Bb 2
A-BB 4
Total 8
But when I apply a filter, removing the all-members and then add just A-Bb
and A-BB then I get:
Total
Group* Member
L A-Bb 2
Total 2
Furthermore, when I leave the all-members untouched and remove all the
members (one after the other) but leave A-Bb and A-BB, the result is the
correct one:
Total
Group* Member
L A-Bb 2
A-BB 4
Total 6
I tested this behaviour with owc10 and owc11 (directly on server and on an
extra client). For the owc10 there is a reproducable way to crash the IE6,
with the owc11 it just does not work correct. I also browsed and googled and
read an tested for a long time. Switching all settings, DBs and registry keys
to binary compare, e.g. does not solve the problem, only switches the order
of the entries...
So it seems to me, that the settings are right (it is displayed and
calculated correctly without filtering) and the filtering algorythm ignores
the case of the letters in the filter collection...
Has anyone encountered the problem before and found a solution? Changing the
way the Members are build is all but impossible. Too many dbs and
applications depend on that.
BTW, the rumors and hints from M$ to discontinue the OWCs for a better paid
Excel-Service-Platform just made my day... :-(
Clear Skies,
Thomas