Analysis Services and Citrix

[Shab]

Hi all,

I have a VB program that connects to a cube and fetches data using ADOMD.Cellset. This program is installed on a Citrix machine, so different users use the Citrix client to ge t to it.

When logging you can chose to log to workstation only.This means you will not see the mapped drives if you go to My Computer however you have access to them.

Now the wierd thing is that if you log to Workstation only my program runs 4 times faster. I know it has something to do with the mapped drives.

Any ideas? Clues? Similar problem on Terminal Sever? Any server setting on Analysis Manager that I can set to get the other logins to run faster.

Thanks,

Shab

 

[justins57]

Shab,

I've been told that the majority of the AS caching gets done on the client machine. This may be the cause of slower performance on clients versus faster performance on the server.

Justin

 

[Shab]

Hi Justin,

I made a mistake, the AS is not installed on the Citrix server it is installed on another server, but still if you use Citrix server the program runs faster than if you logged to your NT account and connected to the server.
I am wondering if there is a location for cellset that I can set, for example for ADO.recordset object I can specify a location to be on the server or client. Is there something similar for a cellset?

Shabnam

 

[justins57]

Yes, you can tell Analysis Services where to process the query in the Connection String parameter ExecutionLocation=2 (this sets the location to the client) machine. I don't know if this will help, but you can give it try.

Justin