dbTalk Databases Forums  

Re: OLAP Reporting App in ASP .NET Using SQL Server 2000 Analysis Serv

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


Discuss Re: OLAP Reporting App in ASP .NET Using SQL Server 2000 Analysis Serv in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Mosha Pasumansky [MS]
 
Posts: n/a

Default Re: OLAP Reporting App in ASP .NET Using SQL Server 2000 Analysis Serv - 08-10-2004 , 04:22 PM






Since you are using middle-tier application with ASP.NET - you don't need
Enterprise Edition of Analysis Services. The Enterprise Edition is only
required if you are connecting directly to Analysis Services using HTTP (and
not through ASP or ASP.NET).

--
==================================================
Mosha Pasumansky - http://www.mosha.com/msolap
Yukon information at http://www.mosha.com/msolap/yukon.htm
Development Lead in the Analysis Server team
All you need is love (John Lennon)
Disclaimer : This posting is provided "AS IS" with no warranties, and
confers no rights.
==================================================

"Adeem Fenster" <AdeemFenster (AT) discussions (DOT) microsoft.com> wrote

Quote:
I am trying to set up an OLAP Reporting Application via HTTP with ASP .NET
using SQL Server Analysis Services. I found one article describing how to
do
this; however, it seems that you need SQL Server Enterprise edition to set
up
HTTP access in Analysis Services. Does anyone know how I can do this using
regular SQL Server? Or if I can set up HTTP access with regular Anlaysis
Services?




Reply With Quote
  #2  
Old   
Adeem Fenster
 
Posts: n/a

Default Re: OLAP Reporting App in ASP .NET Using SQL Server 2000 Analysis - 08-10-2004 , 07:07 PM






I am trying to set up an OLAP Reporting system which can be accessed via
HTTP. Doesn't this require the HTTP web-site to connect into Analysis
Services in order to retreive info. from the OLAP cubes on the server? Is
there a way to bypass this and set up an OLAP Reporting system otherwise via
web? Thanks for the response.

"Mosha Pasumansky [MS]" wrote:

Quote:
Since you are using middle-tier application with ASP.NET - you don't need
Enterprise Edition of Analysis Services. The Enterprise Edition is only
required if you are connecting directly to Analysis Services using HTTP (and
not through ASP or ASP.NET).

--
==================================================
Mosha Pasumansky - http://www.mosha.com/msolap
Yukon information at http://www.mosha.com/msolap/yukon.htm
Development Lead in the Analysis Server team
All you need is love (John Lennon)
Disclaimer : This posting is provided "AS IS" with no warranties, and
confers no rights.
==================================================

"Adeem Fenster" <AdeemFenster (AT) discussions (DOT) microsoft.com> wrote in message
news:2A1F845E-0874-4A82-AB7B-88CF1DBF5505 (AT) microsoft (DOT) com...
I am trying to set up an OLAP Reporting Application via HTTP with ASP .NET
using SQL Server Analysis Services. I found one article describing how to
do
this; however, it seems that you need SQL Server Enterprise edition to set
up
HTTP access in Analysis Services. Does anyone know how I can do this using
regular SQL Server? Or if I can set up HTTP access with regular Anlaysis
Services?





Reply With Quote
  #3  
Old   
Mosha Pasumansky [MS]
 
Posts: n/a

Default Re: OLAP Reporting App in ASP .NET Using SQL Server 2000 Analysis - 08-10-2004 , 08:28 PM



As long as you don't have "Data Source=http://server" in your connection
string - you don't have to use Enterprise Edition.
(assuming your Web site connects to Analysis Services using TCP directly).

--
==================================================
Mosha Pasumansky - http://www.mosha.com/msolap
Yukon information at http://www.mosha.com/msolap/yukon.htm
Development Lead in the Analysis Server team
All you need is love (John Lennon)
Disclaimer : This posting is provided "AS IS" with no warranties, and
confers no rights.
==================================================

"Adeem Fenster" <AdeemFenster (AT) discussions (DOT) microsoft.com> wrote

Quote:
I am trying to set up an OLAP Reporting system which can be accessed via
HTTP. Doesn't this require the HTTP web-site to connect into Analysis
Services in order to retreive info. from the OLAP cubes on the server? Is
there a way to bypass this and set up an OLAP Reporting system otherwise
via
web? Thanks for the response.

"Mosha Pasumansky [MS]" wrote:

Since you are using middle-tier application with ASP.NET - you don't
need
Enterprise Edition of Analysis Services. The Enterprise Edition is only
required if you are connecting directly to Analysis Services using HTTP
(and
not through ASP or ASP.NET).

--
==================================================
Mosha Pasumansky - http://www.mosha.com/msolap
Yukon information at http://www.mosha.com/msolap/yukon.htm
Development Lead in the Analysis Server team
All you need is love (John Lennon)
Disclaimer : This posting is provided "AS IS" with no warranties, and
confers no rights.
==================================================

"Adeem Fenster" <AdeemFenster (AT) discussions (DOT) microsoft.com> wrote in
message
news:2A1F845E-0874-4A82-AB7B-88CF1DBF5505 (AT) microsoft (DOT) com...
I am trying to set up an OLAP Reporting Application via HTTP with ASP
..NET
using SQL Server Analysis Services. I found one article describing how
to
do
this; however, it seems that you need SQL Server Enterprise edition to
set
up
HTTP access in Analysis Services. Does anyone know how I can do this
using
regular SQL Server? Or if I can set up HTTP access with regular
Anlaysis
Services?







Reply With Quote
  #4  
Old   
Adeem Fenster
 
Posts: n/a

Default Re: OLAP Reporting App in ASP .NET Using SQL Server 2000 Analysis - 08-11-2004 , 09:13 AM



Unfortunately I do have that in my string. Thanks for the help.

"Mosha Pasumansky [MS]" wrote:

Quote:
As long as you don't have "Data Source=http://server" in your connection
string - you don't have to use Enterprise Edition.
(assuming your Web site connects to Analysis Services using TCP directly).

--
==================================================
Mosha Pasumansky - http://www.mosha.com/msolap
Yukon information at http://www.mosha.com/msolap/yukon.htm
Development Lead in the Analysis Server team
All you need is love (John Lennon)
Disclaimer : This posting is provided "AS IS" with no warranties, and
confers no rights.
==================================================

"Adeem Fenster" <AdeemFenster (AT) discussions (DOT) microsoft.com> wrote in message
news:ED435213-977C-492B-9A9C-4000E0C78DAB (AT) microsoft (DOT) com...
I am trying to set up an OLAP Reporting system which can be accessed via
HTTP. Doesn't this require the HTTP web-site to connect into Analysis
Services in order to retreive info. from the OLAP cubes on the server? Is
there a way to bypass this and set up an OLAP Reporting system otherwise
via
web? Thanks for the response.

"Mosha Pasumansky [MS]" wrote:

Since you are using middle-tier application with ASP.NET - you don't
need
Enterprise Edition of Analysis Services. The Enterprise Edition is only
required if you are connecting directly to Analysis Services using HTTP
(and
not through ASP or ASP.NET).

--
==================================================
Mosha Pasumansky - http://www.mosha.com/msolap
Yukon information at http://www.mosha.com/msolap/yukon.htm
Development Lead in the Analysis Server team
All you need is love (John Lennon)
Disclaimer : This posting is provided "AS IS" with no warranties, and
confers no rights.
==================================================

"Adeem Fenster" <AdeemFenster (AT) discussions (DOT) microsoft.com> wrote in
message
news:2A1F845E-0874-4A82-AB7B-88CF1DBF5505 (AT) microsoft (DOT) com...
I am trying to set up an OLAP Reporting Application via HTTP with ASP
..NET
using SQL Server Analysis Services. I found one article describing how
to
do
this; however, it seems that you need SQL Server Enterprise edition to
set
up
HTTP access in Analysis Services. Does anyone know how I can do this
using
regular SQL Server? Or if I can set up HTTP access with regular
Anlaysis
Services?








Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.