V
Varadaraj Bhat
Hello,
I have a customer who is using Office web components 11.0 in this asp.net
application. Earlier when they were accessing SQL Analysis Services 2000
using OWC 11.0 , and when we dropped any dimension attribute ( Eg: Product
Name ) on the row axis we are able to see all dimension members. We also we
were able to see all dimension members when we wanted to filter only certain
members( Products).
When we migrated to SQL 2005 + SP3 and used the same OWC component and when
we now want to filter only cetain members, we are now able to see fewer
members and not the complete list. The attribute has more than 4000 products.
We see the same behaviour while using Excel 2003 also.
Any suggestions to resolve this would be appreciated.
Thanks
I have a customer who is using Office web components 11.0 in this asp.net
application. Earlier when they were accessing SQL Analysis Services 2000
using OWC 11.0 , and when we dropped any dimension attribute ( Eg: Product
Name ) on the row axis we are able to see all dimension members. We also we
were able to see all dimension members when we wanted to filter only certain
members( Products).
When we migrated to SQL 2005 + SP3 and used the same OWC component and when
we now want to filter only cetain members, we are now able to see fewer
members and not the complete list. The attribute has more than 4000 products.
We see the same behaviour while using Excel 2003 also.
Any suggestions to resolve this would be appreciated.
Thanks