dbTalk Databases Forums  

Web Frontend for Olap on the internet

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


Discuss Web Frontend for Olap on the internet in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Eugene
 
Posts: n/a

Default Web Frontend for Olap on the internet - 09-19-2003 , 12:48 AM






Hi,
After spending a lot of time on OWC, I found that it cannot be used on the
internet with any security. The only way it will work is to put the AS on
the internet (Ie have a public IP address) and allow anonymous access in
your IIS. This will allow anyone on the internet to access the cube, which
cannot be considered.
Therefore can I fairly say that the OWC in an intranet tools only? Has
anyone actually DONE it? Please don't put out a link to the MS white paper,
it might not be for OWC.
Now I am looking for alternatives. The goal is to put the AS on a private
network, having a web server to talk to it. The client side will need basic
drill and drag functions as well as some filtering. I have tried the Thin
Client, it works, but not very satisfactory. It was mentioned that Crystal
Enterprise can do the job. Has anyone used this. Any other recommendations?

Eugene



Reply With Quote
  #2  
Old   
Nigel Pendse
 
Posts: n/a

Default Re: Web Frontend for Olap on the internet - 09-19-2003 , 02:44 AM






"Eugene" <eugene.chen (AT) iwl (DOT) com.au> wrote

Quote:
Hi,
After spending a lot of time on OWC, I found that it cannot be used
on the internet with any security. The only way it will work is to
put the AS on the internet (Ie have a public IP address) and allow
anonymous access in your IIS. This will allow anyone on the internet
to access the cube, which cannot be considered.
Therefore can I fairly say that the OWC in an intranet tools only? Has
anyone actually DONE it? Please don't put out a link to the MS white
paper, it might not be for OWC.
Now I am looking for alternatives. The goal is to put the AS on a
private network, having a web server to talk to it. The client side
will need basic drill and drag functions as well as some filtering. I
have tried the Thin Client, it works, but not very satisfactory. It
was mentioned that Crystal Enterprise can do the job. Has anyone used
this. Any other recommendations?
Yes, Crystal Analysis Professional has a thin Web client for Analysis
Services, suitable for Internet deployment, as do ProClarity, Panorama
NovaView and BusinessObjects WebIntelligence. Temtec Executive Viewer also
has a very nice Web client, but it uses ActiveX, which some people would
prefer not to use over the Internet. Of these, Panorama probably delivers
the best combination of performance and functionality in thin client mode
(DHTML or small Java applets).

Nigel Pendse
OLAP Solutions
http://www.olapreport.com




Reply With Quote
  #3  
Old   
gms@gmsbv.nl
 
Posts: n/a

Default Re: Web Frontend for Olap on the internet - 09-19-2003 , 08:14 AM



Eugene,

If you would liek to have a real great tool working over internet with
lot of features and great performance I would recomend Panorama
NovaView.

You can visit our website and go to one of our references with a live
BI/OLAP production internet portal website based and see the features
and performance by yourself.

If you have any questions, please let me know.

Marco

"Eugene" <eugene.chen (AT) iwl (DOT) com.au> wrote

Quote:
Hi,
After spending a lot of time on OWC, I found that it cannot be used on the
internet with any security. The only way it will work is to put the AS on
the internet (Ie have a public IP address) and allow anonymous access in
your IIS. This will allow anyone on the internet to access the cube, which
cannot be considered.
Therefore can I fairly say that the OWC in an intranet tools only? Has
anyone actually DONE it? Please don't put out a link to the MS white paper,
it might not be for OWC.
Now I am looking for alternatives. The goal is to put the AS on a private
network, having a web server to talk to it. The client side will need basic
drill and drag functions as well as some filtering. I have tried the Thin
Client, it works, but not very satisfactory. It was mentioned that Crystal
Enterprise can do the job. Has anyone used this. Any other recommendations?

Eugene

Reply With Quote
  #4  
Old   
Pete Hohenhaus
 
Posts: n/a

Default Re: Web Frontend for Olap on the internet - 09-19-2003 , 12:48 PM



"Eugene" <eugene.chen (AT) iwl (DOT) com.au> wrote

Quote:
Hi,
After spending a lot of time on OWC, I found that it cannot be used on the
internet with any security. The only way it will work is to put the AS on
the internet (Ie have a public IP address) and allow anonymous access in
your IIS. This will allow anyone on the internet to access the cube, which
cannot be considered.
Therefore can I fairly say that the OWC in an intranet tools only? Has
anyone actually DONE it? Please don't put out a link to the MS white paper,
it might not be for OWC.
Now I am looking for alternatives. The goal is to put the AS on a private
network, having a web server to talk to it. The client side will need basic
drill and drag functions as well as some filtering. I have tried the Thin
Client, it works, but not very satisfactory. It was mentioned that Crystal
Enterprise can do the job. Has anyone used this. Any other recommendations?

Eugene

Eugene --

I have used ProClarity Analytics Server (Web Server) thin client
approach very successfully. I do not disagree with Nigel at all about
Panorama's web server, however, when you create briefing books with
the desktop client that get published to the web server, I personally
believe that ProClarity Professional, as a desktop dev tool, is far
superior to Panorama's desktop NovaView, in the current instance of
both products.

Also, there is a new web server product coming out called I think
Univiz from Unifact.

Depending on your budget, if it is small, you could look at options
like HTML page publication from any good MSAS Front End - ProClarity,
Panorama, or maybe something like Intellibrowser from Hungry Dog
Software.

Pete

Pete Hohenhaus
Woodinville, WA, East Side Seattle, USA
cam_pete (AT) hotmail (DOT) com
================================================== =============
All comments and views are just that: comments and views, "AS IS."
You may NOT rely on them. These comments and views do NOT convey any
rights, assurances, guarantees, or warranties, of any kind, implied or
express.
================================================== ============


Reply With Quote
  #5  
Old   
Mark Andrews
 
Posts: n/a

Default Re: Web Frontend for Olap on the internet - 09-19-2003 , 05:09 PM



I use ProClarity (desktop and PAS) it's not bad. I like the desktop client
and the web is ok.
High end ProClarity and Panorama (30K+) seem to be the favorites. Business
Objects seems
to be getting into a better position to be a good OLAP player (since they
bought Crystal and their
dashboard product looks good on the web site).

Low end either use one of the two free thin clients, snowflake.net (1K),
or univiz is .net rich client (but kinda cool around 20K). I think ChartFx
has
a OLAP extention, maybe some others out there?

HTH,
Mark



"Pete Hohenhaus" <cam_pete (AT) hotmail (DOT) com> wrote

Quote:
"Eugene" <eugene.chen (AT) iwl (DOT) com.au> wrote

Hi,
After spending a lot of time on OWC, I found that it cannot be used on
the
internet with any security. The only way it will work is to put the AS
on
the internet (Ie have a public IP address) and allow anonymous access in
your IIS. This will allow anyone on the internet to access the cube,
which
cannot be considered.
Therefore can I fairly say that the OWC in an intranet tools only? Has
anyone actually DONE it? Please don't put out a link to the MS white
paper,
it might not be for OWC.
Now I am looking for alternatives. The goal is to put the AS on a
private
network, having a web server to talk to it. The client side will need
basic
drill and drag functions as well as some filtering. I have tried the
Thin
Client, it works, but not very satisfactory. It was mentioned that
Crystal
Enterprise can do the job. Has anyone used this. Any other
recommendations?

Eugene


Eugene --

I have used ProClarity Analytics Server (Web Server) thin client
approach very successfully. I do not disagree with Nigel at all about
Panorama's web server, however, when you create briefing books with
the desktop client that get published to the web server, I personally
believe that ProClarity Professional, as a desktop dev tool, is far
superior to Panorama's desktop NovaView, in the current instance of
both products.

Also, there is a new web server product coming out called I think
Univiz from Unifact.

Depending on your budget, if it is small, you could look at options
like HTML page publication from any good MSAS Front End - ProClarity,
Panorama, or maybe something like Intellibrowser from Hungry Dog
Software.

Pete

Pete Hohenhaus
Woodinville, WA, East Side Seattle, USA
cam_pete (AT) hotmail (DOT) com
================================================== =============
All comments and views are just that: comments and views, "AS IS."
You may NOT rely on them. These comments and views do NOT convey any
rights, assurances, guarantees, or warranties, of any kind, implied or
express.
================================================== ============



Reply With Quote
  #6  
Old   
Maersa
 
Posts: n/a

Default Re: Web Frontend for Olap on the internet - 09-19-2003 , 07:36 PM



Microsoft has just posted a ASP.NET Olap Web Control onto their MSDN site,
following is the link.

http://www.microsoft.com/downloads/d...793-B3C6-4ED5-
ACB3-820D0E832151&displaylang=en



"Mark Andrews" <mandrews (AT) rptsoftware (DOT) com> wrote

Quote:
I use ProClarity (desktop and PAS) it's not bad. I like the desktop
client
and the web is ok.
High end ProClarity and Panorama (30K+) seem to be the favorites.
Business
Objects seems
to be getting into a better position to be a good OLAP player (since they
bought Crystal and their
dashboard product looks good on the web site).

Low end either use one of the two free thin clients, snowflake.net (1K),
or univiz is .net rich client (but kinda cool around 20K). I think
ChartFx
has
a OLAP extention, maybe some others out there?

HTH,
Mark



"Pete Hohenhaus" <cam_pete (AT) hotmail (DOT) com> wrote in message
news:3b5c906d.0309190948.2e847819 (AT) posting (DOT) google.com...
"Eugene" <eugene.chen (AT) iwl (DOT) com.au> wrote in message
news:<uYlD7FnfDHA.460 (AT) TK2MSFTNGP12 (DOT) phx.gbl>...
Hi,
After spending a lot of time on OWC, I found that it cannot be used on
the
internet with any security. The only way it will work is to put the AS
on
the internet (Ie have a public IP address) and allow anonymous access
in
your IIS. This will allow anyone on the internet to access the cube,
which
cannot be considered.
Therefore can I fairly say that the OWC in an intranet tools only? Has
anyone actually DONE it? Please don't put out a link to the MS white
paper,
it might not be for OWC.
Now I am looking for alternatives. The goal is to put the AS on a
private
network, having a web server to talk to it. The client side will need
basic
drill and drag functions as well as some filtering. I have tried the
Thin
Client, it works, but not very satisfactory. It was mentioned that
Crystal
Enterprise can do the job. Has anyone used this. Any other
recommendations?

Eugene


Eugene --

I have used ProClarity Analytics Server (Web Server) thin client
approach very successfully. I do not disagree with Nigel at all about
Panorama's web server, however, when you create briefing books with
the desktop client that get published to the web server, I personally
believe that ProClarity Professional, as a desktop dev tool, is far
superior to Panorama's desktop NovaView, in the current instance of
both products.

Also, there is a new web server product coming out called I think
Univiz from Unifact.

Depending on your budget, if it is small, you could look at options
like HTML page publication from any good MSAS Front End - ProClarity,
Panorama, or maybe something like Intellibrowser from Hungry Dog
Software.

Pete

Pete Hohenhaus
Woodinville, WA, East Side Seattle, USA
cam_pete (AT) hotmail (DOT) com
================================================== =============
All comments and views are just that: comments and views, "AS IS."
You may NOT rely on them. These comments and views do NOT convey any
rights, assurances, guarantees, or warranties, of any kind, implied or
express.
================================================== ============





Reply With Quote
  #7  
Old   
Eugene
 
Posts: n/a

Default Re: Web Frontend for Olap on the internet - 09-21-2003 , 11:53 PM



Mark,
Thanks, very helpfull. I am thinking of trying several of them. Already
requested for trial of the ProClairity and NanaView, Any idea where to find
snowflake? Our platform is not .net so I presume I can't try the ChartFX and
Univiz?


Eugene
"Mark Andrews" <mandrews (AT) rptsoftware (DOT) com> wrote

Quote:
I use ProClarity (desktop and PAS) it's not bad. I like the desktop
client
and the web is ok.
High end ProClarity and Panorama (30K+) seem to be the favorites.
Business
Objects seems
to be getting into a better position to be a good OLAP player (since they
bought Crystal and their
dashboard product looks good on the web site).

Low end either use one of the two free thin clients, snowflake.net (1K),
or univiz is .net rich client (but kinda cool around 20K). I think
ChartFx
has
a OLAP extention, maybe some others out there?

HTH,
Mark



"Pete Hohenhaus" <cam_pete (AT) hotmail (DOT) com> wrote in message
news:3b5c906d.0309190948.2e847819 (AT) posting (DOT) google.com...
"Eugene" <eugene.chen (AT) iwl (DOT) com.au> wrote in message
news:<uYlD7FnfDHA.460 (AT) TK2MSFTNGP12 (DOT) phx.gbl>...
Hi,
After spending a lot of time on OWC, I found that it cannot be used on
the
internet with any security. The only way it will work is to put the AS
on
the internet (Ie have a public IP address) and allow anonymous access
in
your IIS. This will allow anyone on the internet to access the cube,
which
cannot be considered.
Therefore can I fairly say that the OWC in an intranet tools only? Has
anyone actually DONE it? Please don't put out a link to the MS white
paper,
it might not be for OWC.
Now I am looking for alternatives. The goal is to put the AS on a
private
network, having a web server to talk to it. The client side will need
basic
drill and drag functions as well as some filtering. I have tried the
Thin
Client, it works, but not very satisfactory. It was mentioned that
Crystal
Enterprise can do the job. Has anyone used this. Any other
recommendations?

Eugene


Eugene --

I have used ProClarity Analytics Server (Web Server) thin client
approach very successfully. I do not disagree with Nigel at all about
Panorama's web server, however, when you create briefing books with
the desktop client that get published to the web server, I personally
believe that ProClarity Professional, as a desktop dev tool, is far
superior to Panorama's desktop NovaView, in the current instance of
both products.

Also, there is a new web server product coming out called I think
Univiz from Unifact.

Depending on your budget, if it is small, you could look at options
like HTML page publication from any good MSAS Front End - ProClarity,
Panorama, or maybe something like Intellibrowser from Hungry Dog
Software.

Pete

Pete Hohenhaus
Woodinville, WA, East Side Seattle, USA
cam_pete (AT) hotmail (DOT) com
================================================== =============
All comments and views are just that: comments and views, "AS IS."
You may NOT rely on them. These comments and views do NOT convey any
rights, assurances, guarantees, or warranties, of any kind, implied or
express.
================================================== ============





Reply With Quote
  #8  
Old   
Mark Andrews
 
Posts: n/a

Default Re: Web Frontend for Olap on the internet - 09-22-2003 , 12:02 PM



http://www.xmlabrowser.com/
is a good place to start it has lots of links. Snowflake is .NET as well
(server only). Univix requires clients to have .NET.

Mark


"Eugene" <eugene.chen (AT) iwl (DOT) com.au> wrote

Quote:
Mark,
Thanks, very helpfull. I am thinking of trying several of them. Already
requested for trial of the ProClairity and NanaView, Any idea where to
find
snowflake? Our platform is not .net so I presume I can't try the ChartFX
and
Univiz?


Eugene
"Mark Andrews" <mandrews (AT) rptsoftware (DOT) com> wrote in message
news:OWqKBrvfDHA.1748 (AT) TK2MSFTNGP10 (DOT) phx.gbl...
I use ProClarity (desktop and PAS) it's not bad. I like the desktop
client
and the web is ok.
High end ProClarity and Panorama (30K+) seem to be the favorites.
Business
Objects seems
to be getting into a better position to be a good OLAP player (since
they
bought Crystal and their
dashboard product looks good on the web site).

Low end either use one of the two free thin clients, snowflake.net (1K),
or univiz is .net rich client (but kinda cool around 20K). I think
ChartFx
has
a OLAP extention, maybe some others out there?

HTH,
Mark



"Pete Hohenhaus" <cam_pete (AT) hotmail (DOT) com> wrote in message
news:3b5c906d.0309190948.2e847819 (AT) posting (DOT) google.com...
"Eugene" <eugene.chen (AT) iwl (DOT) com.au> wrote in message
news:<uYlD7FnfDHA.460 (AT) TK2MSFTNGP12 (DOT) phx.gbl>...
Hi,
After spending a lot of time on OWC, I found that it cannot be used
on
the
internet with any security. The only way it will work is to put the
AS
on
the internet (Ie have a public IP address) and allow anonymous
access
in
your IIS. This will allow anyone on the internet to access the cube,
which
cannot be considered.
Therefore can I fairly say that the OWC in an intranet tools only?
Has
anyone actually DONE it? Please don't put out a link to the MS
white
paper,
it might not be for OWC.
Now I am looking for alternatives. The goal is to put the AS on a
private
network, having a web server to talk to it. The client side will
need
basic
drill and drag functions as well as some filtering. I have tried the
Thin
Client, it works, but not very satisfactory. It was mentioned that
Crystal
Enterprise can do the job. Has anyone used this. Any other
recommendations?

Eugene


Eugene --

I have used ProClarity Analytics Server (Web Server) thin client
approach very successfully. I do not disagree with Nigel at all about
Panorama's web server, however, when you create briefing books with
the desktop client that get published to the web server, I personally
believe that ProClarity Professional, as a desktop dev tool, is far
superior to Panorama's desktop NovaView, in the current instance of
both products.

Also, there is a new web server product coming out called I think
Univiz from Unifact.

Depending on your budget, if it is small, you could look at options
like HTML page publication from any good MSAS Front End - ProClarity,
Panorama, or maybe something like Intellibrowser from Hungry Dog
Software.

Pete

Pete Hohenhaus
Woodinville, WA, East Side Seattle, USA
cam_pete (AT) hotmail (DOT) com
================================================== =============
All comments and views are just that: comments and views, "AS IS."
You may NOT rely on them. These comments and views do NOT convey any
rights, assurances, guarantees, or warranties, of any kind, implied or
express.
================================================== ============







Reply With Quote
  #9  
Old   
Terry M. Ledet
 
Posts: n/a

Default Web Frontend for Olap on the internet - 09-22-2003 , 03:34 PM



Currently managing an implementation of CE and AS2K. The
the DHTML viewer for Crystal Analysis wass use with sucess
and was available with Domain Security over the internet.
Please note, neither CE or AS2K were public ip's only the
Web Server used to connnect.

Also note, the user community was migrated to the Active X
viewer as the user basis is in the Corporate Office.
Quote:
-----Original Message-----
Hi,
After spending a lot of time on OWC, I found that it
cannot be used on the
internet with any security. The only way it will work is
to put the AS on
the internet (Ie have a public IP address) and allow
anonymous access in
your IIS. This will allow anyone on the internet to
access the cube, which
cannot be considered.
Therefore can I fairly say that the OWC in an intranet
tools only? Has
anyone actually DONE it? Please don't put out a link to
the MS white paper,
it might not be for OWC.
Now I am looking for alternatives. The goal is to put the
AS on a private
network, having a web server to talk to it. The client
side will need basic
drill and drag functions as well as some filtering. I
have tried the Thin
Client, it works, but not very satisfactory. It was
mentioned that Crystal
Enterprise can do the job. Has anyone used this. Any
other recommendations?

Eugene


.


Reply With Quote
  #10  
Old   
Jean-Michel
 
Posts: n/a

Default Re: Web Frontend for Olap on the internet - 09-22-2003 , 07:16 PM



BO, ProClarity, Panorama... tend to rely on fat client to create
reports and are quite pricey. BO for example still relies on a query
panel to pre-define queries and run them. ZAP.BI from
zaptechnology.com is a Zero footprint front-end based on XMLA and .NET
that provides Ad hoc OLAP query and Managed reporting with dynamic PDF
reports and drill back. They're right between the Tier 1 vendors and
the cheap products and will soon have KPIs and a version for MS
Reporting Services! They're Australian but have started selling in US
& UK to Virgin Atlantic in an extranet environment for their travel
agents.

Cheers, Jean-Michel.

"Mark Andrews" <NOSPAMmandrews (AT) rptsoftware (DOT) com> wrote

Quote:
http://www.xmlabrowser.com/
is a good place to start it has lots of links. Snowflake is .NET as well
(server only). Univix requires clients to have .NET.

Mark


"Eugene" <eugene.chen (AT) iwl (DOT) com.au> wrote in message
news:e5Ky3UMgDHA.1748 (AT) TK2MSFTNGP10 (DOT) phx.gbl...
Mark,
Thanks, very helpfull. I am thinking of trying several of them. Already
requested for trial of the ProClairity and NanaView, Any idea where to
find
snowflake? Our platform is not .net so I presume I can't try the ChartFX
and
Univiz?


Eugene
"Mark Andrews" <mandrews (AT) rptsoftware (DOT) com> wrote in message
news:OWqKBrvfDHA.1748 (AT) TK2MSFTNGP10 (DOT) phx.gbl...
I use ProClarity (desktop and PAS) it's not bad. I like the desktop
client
and the web is ok.
High end ProClarity and Panorama (30K+) seem to be the favorites.
Business
Objects seems
to be getting into a better position to be a good OLAP player (since
they
bought Crystal and their
dashboard product looks good on the web site).

Low end either use one of the two free thin clients, snowflake.net (1K),
or univiz is .net rich client (but kinda cool around 20K). I think
ChartFx
has
a OLAP extention, maybe some others out there?

HTH,
Mark



"Pete Hohenhaus" <cam_pete (AT) hotmail (DOT) com> wrote in message
news:3b5c906d.0309190948.2e847819 (AT) posting (DOT) google.com...
"Eugene" <eugene.chen (AT) iwl (DOT) com.au> wrote in message
news:<uYlD7FnfDHA.460 (AT) TK2MSFTNGP12 (DOT) phx.gbl>...
Hi,
After spending a lot of time on OWC, I found that it cannot be used
on
the
internet with any security. The only way it will work is to put the
AS
on
the internet (Ie have a public IP address) and allow anonymous
access
in
your IIS. This will allow anyone on the internet to access the cube,
which
cannot be considered.
Therefore can I fairly say that the OWC in an intranet tools only?
Has
anyone actually DONE it? Please don't put out a link to the MS
white
paper,
it might not be for OWC.
Now I am looking for alternatives. The goal is to put the AS on a
private
network, having a web server to talk to it. The client side will
need
basic
drill and drag functions as well as some filtering. I have tried the
Thin
Client, it works, but not very satisfactory. It was mentioned that
Crystal
Enterprise can do the job. Has anyone used this. Any other
recommendations?

Eugene


Eugene --

I have used ProClarity Analytics Server (Web Server) thin client
approach very successfully. I do not disagree with Nigel at all about
Panorama's web server, however, when you create briefing books with
the desktop client that get published to the web server, I personally
believe that ProClarity Professional, as a desktop dev tool, is far
superior to Panorama's desktop NovaView, in the current instance of
both products.

Also, there is a new web server product coming out called I think
Univiz from Unifact.

Depending on your budget, if it is small, you could look at options
like HTML page publication from any good MSAS Front End - ProClarity,
Panorama, or maybe something like Intellibrowser from Hungry Dog
Software.

Pete

Pete Hohenhaus
Woodinville, WA, East Side Seattle, USA
cam_pete (AT) hotmail (DOT) com
================================================== =============
All comments and views are just that: comments and views, "AS IS."
You may NOT rely on them. These comments and views do NOT convey any
rights, assurances, guarantees, or warranties, of any kind, implied or
express.
================================================== ============





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 - 2012, Jelsoft Enterprises Ltd.