Visual Totals functionality when not using the MSOLAP provider

C

Chuck Heatherly

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Visual Totals functionality when not using the MSOLAP provider 6
DAO IS DED 18
Totals don't reflect filtering in Pivot Component when linked to OLAP 0
OLAP Reporting Application 0
data from one project does not get into the OLAP cube 1
current provider does not support the necessary interface for index functionality 0
0hotfix - please review because the sp1 installation just doesn't work 0

Top