Connect pivot table to cube file?

[Markus Stehle]

Hi all!

Is it possible to connect an OWC10 pivot table to a cube file instead of an
OLAP cube (and how to do so)? And if possible, is this also possible via the
internet (e.g. data source=http://www.myserver.com/dummy.cub)?


Regards

Markus

 

[Markus Stehle]

Dan,

thanks for your hint, it works fine

You can connect to a CUB file by setting the file path as
the "Location" parameter in the connection string.

Provider=Msolap;LOCATION=C:\MyData\MyData.cub;INITIAL
CATALOG=OCWCube

I don't believe this can't be done via a web URL. But even
if it can, it's not a workable solution. The data client
components that OWC uses to connect to a cub file lock the
cube file so nothing else can access it. Therefore only
one user could connect at a time.