Folks,

I'm trying to do some OLAP Reporting using the "Build an OLAP Reporting App
in ASP.Net" article from MSDN as a starting point.
I'm using OWC11 instead of OWC10.

I've created an Analysis Services database called Project, with a Cube
called BMS Data.
I've installed the anaylsis services component (msolap.asp) in a virtual
directory called AnalysisServices.

My connection string ends up becomming:
"Provider=MSOLAP.2;Data Source=http://localhost/AnalysisServices;Initial
Catalog=Project"

My code reaches the following steps in the InitializePivotTableXML routine:
Dim objPT as PivotTableClass = new PivotTableClass
objPT.ConnectionString = strOLAPConn
objPT.DataMember = "BMS Data"

The problem is that it keeps giving me an error of:
"Database 'Project' deos not exist."
even though I'm looking at the Analysis Manager, and can see the database
(and the cube).

Can anyone tell me if my connection string is bad, if I have to do some
configuration in the AnalysisServices virtual directory, or I am missing
something else?

Thanks in advance,
-Buddy Robbins

Doh!

It seems that I missed a minor note, that the HTTP access only exists in the
enterprise edition.
I changed the connection string datasource to my machine name, and it's
working.


"Buddy Robbins" <BuddysSpam (AT) hotmail (DOT) com> wrote

I m also facing similar problem. I am using same code as urs but ShowDetails() doesnot exist in PivotTableClass. Can u please suggest me how did u display data in Pivot Table and Pivot Chart.