Re: OLAP clients

Tech-Archive recommends: Fix windows errors by optimizing your registry

RS is a good tool, but a "static" reporting tool.
if you want to do ad-hoc analysis you'll found a list of tools here:
http://www.mosha.com/msolap/util.htm

SSAS 2005 will really improve the access performance, everything is evaluated on the server side and cached on the server side!
because its a shared cache if you have multiple users, everybody sees its speed increased if there is more then 1 user.



"Daniele Romagnoli" <d.romagnoli@xxxxxxxxxxxxxxx> wrote in message news:u$bcXt4RHHA.3996@xxxxxxxxxxxxxxxxxxxxxxx
Do you think that SQL Server 2005 could solve my problems?
Do you know some web based application? (I think about Reporting Services)

"Jéjé" <willgart_A_@xxxxxxxxxxxxxx> ha scritto nel messaggio news:ez6ENWvRHHA.1228@xxxxxxxxxxxxxxxxxxxxxxx
with AS2000 most of the calculation are evaluated on the client side.
you'll suffer the same issue with any client / server tool for AS2000
(except the MDX query will be better written)

try to play with your connection string first.
Try adding this in the string:
Execution Location=3;Default Isolation Mode=1
(to force the execution on the server side)

other options:
cache ratio=0.001;cache ratio2=0.001;Non Empty Threshold=1;Cache Policy=7

but make sure you'll test ALL your calculated measures because you could suffer bad results.
You can improve the performance but the query result is bad or the performance can degrade for some measures while improve for other measures.

if its not good after these tests, take a look on a web based application.

"Daniele Romagnoli" <d.romagnoli@xxxxxxxxxxxxxxx> wrote in message news:evVP7JvRHHA.4404@xxxxxxxxxxxxxxxxxxxxxxx
Hi, my company actually use SQL Server 2000 Analysis Services and OWC 10 as client. We have some performance issue and we would consider some other clients. Can you suggest some good client?

The big problem is that when users browse the cube the response time on the client are very high, but the server does nothing (RAM and processor usage quite low). I think that the problem is the client elaboration of OWC, I would like to use a client that make a server elaboration.



.

Relevant Pages

  • Re: What doesnt lend itself to OO?
    ... >> proxy and instructs the server to constuct the real object. ... rather than client code. ... If 'clock' is instantiated in the server, ... > for the server interface at the OOA level. ...
    (comp.object)
  • This is going straight to the pool room
    ... or not the client has privilege to do what they're trying to do, ... The server environment is this: ... 3GL User action Routines that Tier3 will execute on your behalf during the ... Routine Name: USER_INIT ...
    (comp.os.vms)
  • [Full-Disclosure] R: Full-Disclosure Digest, Vol 3, Issue 42
    ... Full-Disclosure Digest, Vol 3, Issue 42 ... SD Server 4.0.70 Directory Traversal Bug ... Arkeia Network Backup Client Remote Access ...
    (Full-Disclosure)
  • Re: What doesnt lend itself to OO?
    ... > rather than client code. ... no way to do that without also touching the object with clock semantics ... will not encapsulate both clock semantics and network semantics. ... The server can do whatever it wants ...
    (comp.object)
  • RE: Fax monitor incoming + outgoing calls?
    ... problem between the client computer and the SBS server. ... Client is using the internal IP address of the SBS server as the ... To the folder redirection GPO issue: ...
    (microsoft.public.windows.server.sbs)