AnalysisServices + IIS?can they be seperated

#1

I have developed a web application that uses owc 10 Pivot table control. My
analysis services is on server A, and i deploy my web application on server B
i.e. my iis is on machine B. I am not able to get Pivottable.ActiveView
object in this scenario. Now if i have my analysis services and my web server
both on one machine then there is no problem.
So is it necessary that we have our analysis services and IIS on same machine?
Or Is there any workaround??

Note: I need activeview object just to make costomized view of pivottable
control. So that by default i show some rowaxis, column axis and data axis
filled along with different color schema.

#2

http://support.microsoft.com/kb/279489/EN-US/

That only works with AS2000 though.

"specialist" wrote:

Quote:

created a OLAP CUBE foodmart 2000 using MS SQL Analysis services.The
Cube is working very fine.
Now to i need to place in Web for for end user using OWC(Hope i am
correct). I would like to do this using asp.net..
pls helpe to how to bring this OLAP CUBE to browser using ASP.NET.
i gone through some of link like
http://msdn.microsoft.com/msdnmag/issues/03/10/OLAP/
but i am unable to understand as this is not by step by step
basis/process.

Can pls any body help me to display MS SQL OLAP CUBE in the browser
using ASP.NET and OWC.

thanks in advance

#3

thanks alot Pat!!!
That was really very helpful... It solved the hell of the problem. Could you
please tell me if there are any issues related to http type of connections.

Quote:

http://support.microsoft.com/kb/279489/EN-US/

That only works with AS2000 though.

"specialist" wrote:

created a OLAP CUBE foodmart 2000 using MS SQL Analysis services.The
Cube is working very fine.
Now to i need to place in Web for for end user using OWC(Hope i am
correct). I would like to do this using asp.net..
pls helpe to how to bring this OLAP CUBE to browser using ASP.NET.
i gone through some of link like
http://msdn.microsoft.com/msdnmag/issues/03/10/OLAP/
but i am unable to understand as this is not by step by step
basis/process.

Can pls any body help me to display MS SQL OLAP CUBE in the browser
using ASP.NET and OWC.

thanks in advance

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

AnalysisServices + IIS?can they be seperated

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap

AnalysisServices + IIS?can they be seperated - 12-08-2005 , 02:38 AM

Re: AnalysisServices + IIS?can they be seperated - 12-08-2005 , 02:43 PM

Re: AnalysisServices + IIS?can they be seperated - 12-08-2005 , 11:36 PM