DrillThrough in OWC11

[Amadeus Consulting]

In VS 2005 we have cubes setup with actions that allow for drillthrough to
underlying data. In the cube browser I can right click on a cell and view
and use the drillthrough action without any problems. When I view the same
cube using OWC11 in a web browser and right click on the cell to drillthrough
I don’t get the ‘action’ listed in the menu.

I know if OWC10 you could double click on the cell to produce the
drillthrough, but that doesn’t work either. Is there something that I’m
missing when setting up actions for drillthrough that I need to be doing in
order for it to work in OWC11 in a web browser? Is there a place when I
deploy that I need to turn drillthrough on? Is there a setting on the
pivottable when I create it that I have to set in order for actions to work?

 

[Wei-Dong XU [MS]]

Hi Steve,

For the code drillthrough feature in Office web component, this technical
article below provides the best presentation with detailed code sample. I'd
suggest please follow up this article regarding this issue. If the features
introduces in this article not satisfy you as the one in VS.net 2005, this
should mean the Office web component doesn't have that feature.
Code Walkthrough: Data Drillthrough from the PivotTable Component
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnowc/html/
odc_pvtdrillthrough.asp

Please feel free to let me know if you have any further question on this
issue.

Best Regards,
Wei-Dong XU
Microsoft Support

 

[Amadeus Consulting]

We were able to get the drillthrough to work as expected, but there are two
issues we are trying to work through now.

First, we currently have the setting plDrillthroughViewModeOriginal set for
the table to display the data in the existing pivot table and everything
works as expected. When we try to set that to plDrillthroughViewModeSpawn we
get a page cannot be found error. Any ideas why that may be happening? The
reason we wanted to have the data display in a new window is because we are
using subcubes and when we click on ‘Return to Aggregate View’ from the
drillthrough the subcubes are lost.

Second, SSAS 2005 allows us to set up Actions for DrillThrough in which we
can set which measures we want to be able to drillthrough on, the caption
that appears in the right click menu of the pivot table and which field(s) we
want to have returned when the drillthrough is performed. Right now when we
right click we see a ‘Show details’ choice on the menu instead of the custom
caption we have put in through SSAS and when we do the drillthrough we get
the all columns from the underlying fact table. What we expect is to see the
custom caption and then have accountid’s returned on the drillthrough. Is it
possible we are missing something when implementing drillthrough for 2005?
The reason that I’m pretty confident this can be done is SSAS cube browser
uses the OWC11 pivot table control to allow browsing of the cubes and when I
attempt the drillthrough it shows the custom caption and returns the
appropriate field(s). Right now we are using the drillthrough.htc file that
comes with the office component download pack and we are wondering if there
is a different version of that behavior file available for OWC11 that
supports these new features, or how we might go about modifying the existing
one.

Thanks,

 

[Wei-Dong XU [MS]]

Hi Steve,

Currently we are researching this issue for you. When any update, we will
reply at the first time. Thanks!

Have a nice weekend!

Best Regards,
Wei-Dong XU
Microsoft Support

 

[Wei-Dong XU [MS]]

Hi Steve,

Currently as I know, this appears to be one compatibility issue regarding
the pivottable with the SQL Server 2005 OLAP. So I have two suggestions for
you:
1. please use the ADOMD.net class library to retrieve the data from SQL
Server 2005 OLAP and not using the Pivottable. ADOMD.NET provides client
access to multidimensional data sources, such as SSAS 2005. Client
applications can use ADOMD.NET to connect to multidimensional data sources
for retrieving and manipulating data and metadata. This is the updated
solution for client accessing the OLAP. As a comparison, the pivottable is
very old now.

2. as I know for this issue, the Pivottable should work as expected with
SSAS2005. However, facing your errors, there is one public Microsoft
article introducing more internal information. So I'd suggest you could
raise one incident to your local Microsoft product support service. Then if
this is a bug of Pivottable or SSAS 2005, your incident will be totally
free of charge. Your Microsoft Product Support Service is available from:
http://support.microsoft.com/common/international.aspx

Please feel free to let me know if you have any further question on this
issue.

Best Regards,
Wei-Dong XU
Microsoft Support