OWC PivotTable and Offline Cube

F

Francis

Hi,

Can anyone tell me the connection string for the OWC PivotTable to connect a
offline OLAP cube.
I am using ASP.NET and OWC 9.0.

Thanks a lot.
Francis
 
S

Scott Allen

I think you are looking for something like:

Provider=MSOLAP.2;Data Source=C:\Path\MyCube.cub;Initial
Catalog=CubeName;

HTH,
 
F

Francis

Thanks a lot.

But after I set this ConnectionString, the OWC PivotTable control still can
not bind to the offline cube. It does not prompt any error, it just can not
connect to the offline cube file. Is there any other command that I have to
call? e.g., refresh.

Best regards,
Francis
 
V

Vijay

PivotTable1.connectionstring="Provider=MSOLAP.2;Client Cache Size=25;Auto Synch Period=10000;Data Source=D:\Mytestcube.cub
PivotTable1.DataMember = "MuCube"
 
Top