Date:         Wed, 29 Sep 2004 22:14:05 -0400
Reply-To:     Don Henderson <donaldjhenderson@HOTMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Don Henderson <donaldjhenderson@HOTMAIL.COM>
Subject:      Re: Showing MDDB's in SAS
In-Reply-To:  <7bb4f21d.0409291417.1327a9ae@posting.google.com>
Content-Type: text/plain; charset="us-ascii"

The MRV being slow is likely due to the MDDB itself needing to be tuned. The
CGI part of the SAS/IntrNet Application Dispatcher is "very lean and mean"
and I can state pretty emphatically that the slowness you see is almost
certainly on the "SAS server" side and not the web server (which is where
the CGI piece executes).

Yes there are Java based viewers available from SAS. However, if the problem
is in how you have built/defined the cube (i.e., the MDDB), you will see the
same performance with a Java based approach.

And third, PROC MDDB builds the cube, it is not the tool to query/report on
the content of the MDDB.

Regards,
-don h.

-----Original Message-----
From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of Jesper
Sahner
Sent: Wednesday, September 29, 2004 5:18 PM
To: SAS-L@LISTSERV.UGA.EDU
Subject: Showing MDDB's in SAS

Which tool is the right one for showing MDDB's in SAS? I have tried to
use SAS/MRV (MDDB Report Viewer), but this is very slow. I guess it is
based on CGI-technology. Is there e.g. a Java-based tool available?

In my opinion the right solution would be a solution using SAS/IntrNet
and ODS directly in a similar way a graph is presented as an
ActiveX-object. If this was possible you would just have to put ODS
around your 'proc mddb', and it would be possible to make drill downs
etc. directly on a Web-page using SAS/IntrNet. Any opinions on this?