|Date: ||Thu, 31 May 2007 17:35:38 +1000|
|Reply-To: ||David Birch <David.Birch@DISABILITY.QLD.GOV.AU>|
|Sender: ||"SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>|
|From: ||David Birch <David.Birch@DISABILITY.QLD.GOV.AU>|
|Subject: ||Re: OLAP building|
|Content-Type: ||text/plain; charset="us-ascii"|
I'm not sure what you understand by 'associated'. The SAS Web OLAP
Viewer (which comes in two flavours - "for Java" and "for .Net") is a
different physical object to the OLAP Viewer object in EG. They are
delivered differently - through your browser vs through EG; they have
different system requirements; and have slightly different
functionality. These differences are porbably moving targets but I
wouldn't rely on them going away.
They both (or rather all three) require and utilise common back-end
server technology: the SAS Metadata Server, and whichever OLE DB for
OLAP compliant data providers that you choose (SAS OLAP Server, SQL
Server, SAP BW etc.).
The message you cite indicates a server problem "opening cube", so would
be the same regardless of which viewer you used.
From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of
Sent: Thursday, 31 May 2007 8:16 AM
Subject: Re: OLAP building
On May 28, 9:39 pm, David.Bi...@DISABILITY.QLD.GOV.AU (David Birch)
> EG does not use OLAP Server to view cubes. It uses an OLAP viewer
> object which can view any OLE DB for OLAP compliant cubes, and is
> different to the viewer object used in Web Report Studio. You
> definitely need Integration Tech and probably SAS/Access for OLE DB to
> view cubes built with either SQL Server or Excel. Unfortunately, the
> server bundle doesn't include OLAP Server. The "Enterprise Server"
> bundle does include OLAP server.
> The few freeware OLAP products I have seen are not OLE DB for OLAP
> compliant, but I haven't looked recently.
> That leaves Excel (which I suspect is a bit flakey for building
> compliant cubes) or SQL Server - for which you'd need the Analysis
> Services client installed on your PC. If you decide to try this
> I'd advise starting with a good simple dimensional design for your SQL
> Server tables rather than trying to use an existing database.
> -----Original Message-----
> From: SAS(r) Discussion [mailto:S...@LISTSERV.UGA.EDU] On Behalf Of
> Sent: Tuesday, 29 May 2007 1:31 AM
> To: S...@LISTSERV.UGA.EDU
> Subject: Re: OLAP building
> On May 27, 1:35 pm, "Jerry" <jerrabombe...@gmail.com> wrote:
> > Hi,
> > Enterprise Guide will view cubes.
> > As my agency doesnt have OLAP studion I am interested in using other
> ways > to produce them.
> > I can use excel, or sql server 2005 (havent been successful yet with
> > but I notice that EG doesnt like the excel cubes so much.
> > What other products can I use? TM1? Any freeware? This is simply
> > demo of webreportstudio to some management dudes, and I am very
> > to get any financial support at present.
> > Doug<auto208...@hushmail.com> wrote in message
> > > On May 27, 6:17 am, "Jerry" <jerrabombe...@gmail.com> wrote:
> > >> Hi
> > >> I would like to build some olap cubes to use in BI - web report
> studio > >> - after creating some information maps.
> > >> However my agency doesnt have olap server. We have BI server,
> > >> integration tech, and some sas access tools, AF, and Stat - i
> > >> may have eis and ets but i am not sure.
> > >> Is there another way to do this using sas? How can i build a
> > >> without the olap. Is this possible if we have eis installed.
> > >> Is there a step by step guide to developing a cube?
> > >> Thanks
> > >> Doug
> > > I believe you need to have SAS OLAP Server to view cubes.
> > > Use PROC SETINIT to see what SAS products you are licensed for.
> > > proc setinit; run;
> > > Also, here's some docs on SAS OLAP Cube Studio:
> > > take look at 'User's Guide, Second Edition'
> E.G. uses the OLAP server to slice and dice the cubes for diplaying.
> Good luck.
Are you saying that SAS Web OLAP Viewer is not all 'associated' with
OLAP Viewer object in E.G. ?
I've had a few instances where I had problems viewing a cube in E.G. ,
each time this occurred I also couldn't view the cube in the
SAS Web OLAP Viewer. The following message would be thrown in E.G.:
'An error occurred opening cube "myCubeName(FOUNDATION)". Could not
establish a connection to the SAS server on the requested machine.
Verify that the SAS server has
been started with the -objectserver option or that the SAS spawner has
been started. Verify that the port Combridge is attempting to connect
to is the same as the port SAS(or the spawner) is listening to.'
********************************* DISCLAIMER *********************************
The information contained in the above e-mail message or messages (which includes any attachments) is confidential and may be legally privileged. It is intended only for the use of the person or entity to which it is addressed. If you are not the addressee any form of disclosure, copying, modification, distribution or any action taken or omitted in reliance on the information is unauthorised. Opinions contained in the message(s) do not necessarily reflect the opinions of the Queensland Government and its authorities. If you received this communication in error, please notify the sender immediately and delete it from your computer system network.