Hi,

I am tryng to connect to an OLAP cube built through AS 2000 from
SharePoint 2003 over the internet. I need to plot a graph(PivotChart of
Office Web Components (OWC) ) with data coming from the cube. For the
SharePoint authentication, I have set "Basic Authetication" mode
(primarily Network Authentication). The error that I get is " Unable to
connect to Analysis Server. The name <servername> was not found. I
tried giving the IP of the server but it was of no luck.

if you use the OWC directly, this load the ActiveX control on the browser.
So first, the user must have access to the cube, second the user must have
the OWC installed on his computer.
if you use AS2005 (any version), you can use the HTTP protocol to access the
cube. if you use AS2000, then the enterprise edition provide a way to access
the cube through the HTTP protocol, standard edition don't provide this
capability, the user must have a direct access to the cube server.

if you use the business scorecard manager, there is an option to render the
control on the server side and only the resulting picture is displayed, so
there is no needs for the end users. But in this case the user can't play
with the cube.

Can you describe your architecture?

"bharathram.c (AT) gmail (DOT) com" wrote:

Hi,

Thanks for the reply.

The architecture is like this. I have a cube built using AS
2000 that feeds data to a Microsoft Business Scorecard Manager
workspace. Now this workspace is published to a Sharepoint Portal
Version 2003. I am typically using 2 web parts(one for the Scorecard
View and another for the Office Report View (Chart in this case)). The
Scorecard refreshes the data on selecting Page Filter/KPI Clicks but
the graphs dont show up. It is not able to resolve the Machine name. It
is also not able to connect to the Analysis Server even if I give the
IP of that machine.

Let me know if u need any more information.

Thanks


Jerome P wrote:

ok,

I presume you have setup your chart to be generated on the server side not
on the client side.
if its not the case, then change this option.

second point, try to use a DNS name in the server connection string.
verify that there is no firewall problem between portal server and the OLAP
Server.
(can you access the cube from the web server using any other tool?)

also, where this name error appears?

also, if you have 2 servers and if you use the NTLM (windows integrated)
security verify your Kerberos delegation.


"bharathram.c (AT) gmail (DOT) com" wrote:

The chart is setup at the workspace level...precisely at the server
level....which is published at the SharePortal through a web part...the
site is configured at port 80 and is thrown to the internet....

the name error appears when i click on a KPI...the graph is not showing
up but gives the error mentioned earlier...

I have tried giving the DNS name/IP of the server but was of no luck...

reg access the cube through another tool...in the same site, the
scorecard is able to pick data from the same data source but the chart
is not able to do that which is very surprising....the cube that
provides data to the chart as well as the scorecard is the same






Jerome P wrote:

mmm...

have you take a look in the HTML code himself?
when you have the error, look at the HTML source code.

find the IMG tag where the chart is, and verify the URL and the parameters
here.
maybe the system try to access another server.
(a right click --> properties on the image can display the URL too)

did you see the chart if you open the page on the server himself?

"bharathram.c (AT) gmail (DOT) com" wrote:

maybe this article will help you:
http://support.microsoft.com/kb/912129/en-us


"Jerome P" wrote: