OWC Drillthrough on SSAS 2005 Cube

[riskiad]

Does OWC (version 10 or 11) allow you to use the drillthrough action on an
SSAS2005 cube?

I currently use OWC10 to view data in an AS2000 cube and the drillthrough
action works perfectly on it. I've recreated my cubes in SSAS 2005, added the
drillthrough action, changed the connection string in the OWC, but the
drillthrough action doesn't work correctly. When I double click on a cell, a
popup window appears with the field headers, but no records. I've tried it
with OWC11 as well but no luck.

 

[Alvin Bruney [ASP.NET MVP]]

Do you notice any script errors on the page?

--
Regards,
Alvin Bruney

Auther Plug
OWC Blackbook now on download at www.lulu.com/owc

 

[riskiad]

I don't see any errors on the page. The only difference I notice (from
drilling through on my AS 2000 cubes) is that the field names have a dollar
sign and Dimension Name as a prefix. For example, the field headers that show
up are [$DimAllAttrib].[PRACTICE] and [$DimAllAttrib].[REGION]

 

[Joe Sampino]

I've never worked with drillthrough, but in SSAS 2005 there is a setting on
the security roles - cube tab to enable it. Have you set that to allow drill
through?

I don't see any errors on the page. The only difference I notice (from
drilling through on my AS 2000 cubes) is that the field names have a dollar
sign and Dimension Name as a prefix. For example, the field headers that show
up are [$DimAllAttrib].[PRACTICE] and [$DimAllAttrib].[REGION]

Do you notice any script errors on the page?

--
Regards,
Alvin Bruney

Auther Plug
OWC Blackbook now on download at www.lulu.com/owc

 

[rob sturza]

I'm experiencing the same problem. I've proven that data is coming across
to the recordset. But only the headers display in the pivot table.

url:http://www.ureader.com/msg/11061278.aspx