Visual Totals functionality when not using the MSOLAP provider

[Chuck Heatherly]

(Note: Having to repost this because apparently my no-spam alias was not set up
correctly.)

I support an OLAP OLE DB provider for a third party data source. I'm unable to
get the visual totals functionality of OWC10 or OWC11 to work with my provider.

When I bring up a web page with an OWC11 pivot table control and select Commands
and Options > Report > Visible Items only, OWC11 returns "The data source does
not support totaling only visible items".

Doing the same operation with the Analysis Services OLE DB provider MSOLAP.2
causes OWC11 to generate MDX using the VisualTotals function.

What does my provider need to surface so that OWC11 will generate MDX using the
VisualTotals function? My provider surfaces VisualTotals through the Functions
Schema Rowset. It also supports the property DBPROP_VISUALMODE.

Thanks,
Chuck

 

[Wei-Dong XU [MSFT]]

Hi Chunk,

So far as I know, this issue is one product by design issue. And for
MSOLAP, only the MSOLAP.2 driver supports the visual totals. Office Web
Component will need to use the Version 2.0 OLE DB providoer for MS OLAP to
display the visual totals. This kb explains this:
PRB: Unable to Display Visual Totals Using the PivotTable Component
http://support.microsoft.com/?id=306756

For your third party data source, I'd suggest you can raise this question
to them. Perhaps they can provide one patch or update for you to resolve
this issue.

Please feel free to let me know if you have any question.

Best Regards,
Wei-Dong XU (WD)
Microsoft Product Support Services
Get Secure! - www.microsoft.com/security
This posting is provided "AS IS" with no warranties, and confers no rights.

 

[Chuck Heatherly]

I support an OLAP OLE DB provider for a third party data source. I'm unable to

Hi Chuck,

So far as I know, this issue is one product by design issue. And for
MSOLAP, only the MSOLAP.2 driver supports the visual totals. Office Web
Component will need to use the Version 2.0 OLE DB providoer for MS OLAP to
display the visual totals. This kb explains this:
PRB: Unable to Display Visual Totals Using the PivotTable Component
http://support.microsoft.com/?id=306756

For your third party data source, I'd suggest you can raise this question
to them. Perhaps they can provide one patch or update for you to resolve
this issue.

Please feel free to let me know if you have any question.

Best Regards,
Wei-Dong XU (WD)
Microsoft Product Support Services

Wei-Dong,

I am the third-party data source. What I am asking is what do I need to do,
either to the data source or to the OLE DB for OLAP Provider, to get Visual
Totals in OWC to work, given that I have already tried the things mentioned in
the original post? I only mentioned the MSOLAP provider as a reference, as an
example of a provider/data source combo that works. The KB reference you cited
applies to MSOLAP.1 only (the solution it suggests is to use MSOLAP.2), and as
the post title states, I am not using MSOLAP.

Thanks,
Chuck

 

[Wei-Dong XU [MSFT]]

Hi Chunk,

Thank you for posting in Newsgroup!

From my research on this issue, I found the Vitual Totals of PivotTable
will require the data source to support the version 2 OLE DB Provider, for
example MSOLAP.2; you can try to configure the connection string to your
data source with the direction of the KB article 306756. Since your are
using the 3rd party data source which is not the Microsoft product, I can
only figure out the requirement from Microsoft side. I'd suggest you can
send one mail or request the support of the 3rd party data source product
provider for more information on the configuration regarding this.

Greatly appreciate your understanding!

Best Regards,
Wei-Dong XU (WD)
Microsoft Product Support Services
Get Secure! - www.microsoft.com/security
This posting is provided "AS IS" with no warranties, and confers no rights.

 

[Chuck Heatherly]

Hi Chuck,

Thank you for posting in Newsgroup!

From my research on this issue, I found the Vitual Totals of PivotTable
will require the data source to support the version 2 OLE DB Provider, for
example MSOLAP.2; you can try to configure the connection string to your
data source with the direction of the KB article 306756. Since your are
using the 3rd party data source which is not the Microsoft product, I can
only figure out the requirement from Microsoft side. I'd suggest you can
send one mail or request the support of the 3rd party data source product
provider for more information on the configuration regarding this.

Greatly appreciate your understanding!

Best Regards,
Wei-Dong XU (WD)
Microsoft Product Support Services
Get Secure! - www.microsoft.com/security
This posting is provided "AS IS" with no warranties, and confers no rights.

OK, I am a little frustrated. I have tried to explain this twice and it doesn't
seem to be getting through. I have trimmed the original post and replies for
brevity.

There is some kind of handshake going on between OWC and MSOLAP.2. Whatever is
happening under the covers for MSOLAP.2 to support Visual Totals, it is not
published in the OLE DB for OLAP specification, as far as I am aware. I have
tried to observe the details in the spec that I noted in my original post,
namely, surfacing VisualTotals through the Functions schema rowset and
supporting the property DBPROP_VISUALMODE. My question is, what else do I need
to do in the provider? If I am missing something in the spec, please let me
know.

Wei, you keep telling me to contact the 3rd party data source, and I keep trying
to explain that I *AM* the third party data source (and provider writer) in
question. The MS KB article you keep referring me to only applies to the MSOLAP
provider, so it is of no help to me.

Wei, can you forward this to somebody at Microsoft who works on the OWC or OLE
DB for OLAP team? They are ultimately the people who will know what is going
on. Wei, I greatly appreciate your time and effort in helping me out.

Thanks,
Chuck

 

[Alvin Bruney [MVP]]

Chuck,
I am not sure microsoft will provide that information to you in a public
forum. You may need to open a troiuble ticket with their support group.
Either that or Wei may be able to identify a resource in product support who
can provide you with the required information. I hope this helps.

 

[Wei-Dong XU [MSFT]]

Hi Chuck,

The version 2.0 OLE DB provider is one specification. This book will
introduce detailed information for you:
Microsoft? OLE DB 2.0 Programmer's Reference and Data Access SDK
http://www.microsoft.com/mspress/brasil/books/book13622.htm

For the development of OLE DB provider version 2.0, I'd suggest these
links below will provide some assistance for you:
Data Access Programming
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vccore/html
/_core_database_topics_.28.general.29.asp

OLE DB Programming
http://msdn.microsoft.com/library/en-us/vccore/html/vcconOLEDBProgramming.as
p

However, for the co-operation of Pivottable with your data source which
touches the product design, I'd recommand you can obtain more information
from Microsoft Consulting or raise one incident to your local Microsoft
PSS. The contact info is available from this link.
Consult
http://www.microsoft.com/services/microsoftservices/cons.mspx
Support
http://www.microsoft.com/services/microsoftservices/supp.mspx

Greatly appreciate your understanding!

Best Regards,
Wei-Dong XU (WD)
Microsoft Product Support Services
Get Secure! - www.microsoft.com/security
This posting is provided "AS IS" with no warranties, and confers no rights.