OWC PivotTable and Offline Cube

[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

 

[Scott Allen]

I think you are looking for something like:

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

HTH,

 

[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

 

[Vijay]

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