S
Swapan
Hi group,
Please Please help me .I would really appreciate any help.
I am trying to connect and access to Analysis server cubes
with owc pivot table over internet
I have both SQL Server 2000(SP3), Analysis Server(SP3) and
IIS(Anonymous security) in the same Machine(with Static IP
open to internet).
I can connect to the Analysis server cubes data locally
and also from all other machine in the LAN but I can not
connect it over internet.
Code goes like this.
<html>
<body>
<OBJECT id="PivotTable1" style="WIDTH:
502px; HEIGHT: 217px" height="217" width="502"
classid="clsid:0002E552-0000-0000-C000-000000000046">
</OBJECT>
<br>
<br>
<input type="button" id="button1"
value="Populate">
<script language="vbscript">
sub button1_onclick()
PivotTable1.ConnectionString
= "Provider=MSOLAP;Integrated Security=SSPI;Persist
Security Info=False;Data Source=Myserver;Initial
Catalog=FoodMart 2000"
PivotTable1.DataMember = "Sales"
PivotTable1.CommandText = "select non empty
time.members on columns, non empty store.members on rows
from sales where measures.[Store Sales]"
end sub
</script>
</body>
</html>
Please help
Thank you
Swapan
Please Please help me .I would really appreciate any help.
I am trying to connect and access to Analysis server cubes
with owc pivot table over internet
I have both SQL Server 2000(SP3), Analysis Server(SP3) and
IIS(Anonymous security) in the same Machine(with Static IP
open to internet).
I can connect to the Analysis server cubes data locally
and also from all other machine in the LAN but I can not
connect it over internet.
Code goes like this.
<html>
<body>
<OBJECT id="PivotTable1" style="WIDTH:
502px; HEIGHT: 217px" height="217" width="502"
classid="clsid:0002E552-0000-0000-C000-000000000046">
</OBJECT>
<br>
<br>
<input type="button" id="button1"
value="Populate">
<script language="vbscript">
sub button1_onclick()
PivotTable1.ConnectionString
= "Provider=MSOLAP;Integrated Security=SSPI;Persist
Security Info=False;Data Source=Myserver;Initial
Catalog=FoodMart 2000"
PivotTable1.DataMember = "Sales"
PivotTable1.CommandText = "select non empty
time.members on columns, non empty store.members on rows
from sales where measures.[Store Sales]"
end sub
</script>
</body>
</html>
Please help
Thank you
Swapan