D
Dahler
Hi.
I'm having problems with the drillthrough function in my OWC10-pivottable.
If I make some selections in my pivottable (chose some Products, some Types
and some Stores - see below), and try to drillthrough, I just get en empty
pop-up, telling 'Getting detail information. Please wait...'. And nothing
happens. I can then remove some selections, and drillthrough works fine
again. I am using the original Drillthrough.htc file from the OWC Toolpack.
If I connect my cube to a normal EXCEL pivottable, then the drillthough
function works much more convincing.
Could anyove give me a hint, how to improve the drillthrough-functionality
in my OWC10-pivottable.
My code (some lines omitted) is shown below.
Thanks,
/Dahler
------------------------------------------------------------------
<HEAD>
<style> .Heading { FONT-SIZE: 14pt; FONT-FAMILY: Arial } .ptdrillthrough
{ BEHAVIOR: url(Drillthrough.htc) } </style>
</HEAD>
<BODY>
<OBJECT id="ch" classid="clsid:0002E546-0000-0000-C000-000000000046"
....... </OBJECT>
<OBJECT class="ptdrillthrough" id="pt"
classid="clsid:0002E552-0000-0000-C000-000000000046" .... </OBJECT>
<script language="VBScript">
Function Window_Onload()
ConnStr = "provider=MSOLAP.2;Persist Security Info=True;Data
Source=MYSRV;Initial Catalog=My_Catalog;Client Cache Size=25;Auto Synch
Period=10000"
pt.ConnectionString = ConnStr
pt.DataMember = "My_Cube"
Set ptView = pt.ActiveView
pt.Drillthrough.UserInterface.SetViewMode(pt.Drillthrough.Constants.plDrillthroughViewModeSpawn)
ptView.RowAxis.InsertFieldSet ptView.FieldSets("Product")
ptView.ColumnAxis.InsertFieldSet ptView.FieldSets("Store")
ptView.FilterAxis.InsertFieldSet ptView.FieldSets("Type")
ptView.DataAxis.InsertTotal ptView.Totals("Count")
Set ch.DataSource = pt
End Function
</script>
</BODY>
</HTML>
I'm having problems with the drillthrough function in my OWC10-pivottable.
If I make some selections in my pivottable (chose some Products, some Types
and some Stores - see below), and try to drillthrough, I just get en empty
pop-up, telling 'Getting detail information. Please wait...'. And nothing
happens. I can then remove some selections, and drillthrough works fine
again. I am using the original Drillthrough.htc file from the OWC Toolpack.
If I connect my cube to a normal EXCEL pivottable, then the drillthough
function works much more convincing.
Could anyove give me a hint, how to improve the drillthrough-functionality
in my OWC10-pivottable.
My code (some lines omitted) is shown below.
Thanks,
/Dahler
------------------------------------------------------------------
<HEAD>
<style> .Heading { FONT-SIZE: 14pt; FONT-FAMILY: Arial } .ptdrillthrough
{ BEHAVIOR: url(Drillthrough.htc) } </style>
</HEAD>
<BODY>
<OBJECT id="ch" classid="clsid:0002E546-0000-0000-C000-000000000046"
....... </OBJECT>
<OBJECT class="ptdrillthrough" id="pt"
classid="clsid:0002E552-0000-0000-C000-000000000046" .... </OBJECT>
<script language="VBScript">
Function Window_Onload()
ConnStr = "provider=MSOLAP.2;Persist Security Info=True;Data
Source=MYSRV;Initial Catalog=My_Catalog;Client Cache Size=25;Auto Synch
Period=10000"
pt.ConnectionString = ConnStr
pt.DataMember = "My_Cube"
Set ptView = pt.ActiveView
pt.Drillthrough.UserInterface.SetViewMode(pt.Drillthrough.Constants.plDrillthroughViewModeSpawn)
ptView.RowAxis.InsertFieldSet ptView.FieldSets("Product")
ptView.ColumnAxis.InsertFieldSet ptView.FieldSets("Store")
ptView.FilterAxis.InsertFieldSet ptView.FieldSets("Type")
ptView.DataAxis.InsertTotal ptView.Totals("Count")
Set ch.DataSource = pt
End Function
</script>
</BODY>
</HTML>