Connecting to OLAP, OWC 9.0 Pivottable

D

Dennis

Hello! I have, due to business reasons, to connect to an olap datasource from
OWC 9.0 and I'm having issues with the connection (and my lack of deep
understanding). I can connect to the cube from excel, AM, MDX sample etc and
I can connect to flat tables from the pivottable and insert fieldsets etc.

this.mPivot.ConnectionString = "Provider=MSOLAP.2;Data Source=<computer
name>;Initial Catalog=FoodMart 2000"

//
And then what? Trying to access the connection yields an exception. Am I
missing any properties?

Grateful for answer.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top