Analysis server cube Performance through Excel 2007

Hello Everybody

I am accessing Analysis server cube -2005 through Excel 2007 for building reports. When ever i select a row or column right click and select Filter > Hide Selected Items, it will show "running query on the OLAP server" at bottom and will not respond after that.

Ran the MDX generated by Excel 2007 directly on analysis server, even then also it takes lot of time and finally it doesnt respond. I read in the forum that the sql generated by Excel 2007 is different. how can i tweak in so that cube performance improves ?

Thanks
Kiran

Hi Kiran,

Do you have old AS 2000 to compare performance? The reason I am asking this because you can check if you have same aggregation setup in AS 2005 cube. If you don't have old cube to compare try creating aggregation on AS 2005 cube. Also you can check profiler, performance counter etc.

-Ashok

sql

Alternative to IPSec?

The client I'm working with has a 2-node Failover cluster. Owing to their
environment, they have several machines accessing the many databases. For
cost reasons, they went with SQL standard.
As to securing the traffic. I understand that IPSec isn't supported for
failover cluster, owing to the recovery time (6 minutes, according to the
document).
But the recovery for SQL standard doesn't allow external connections until
all databases are recovered. If the server has a lot of databases (perhaps
50), there may already be a delay.
I guess the questions I'm asking are:
1>Outside of the time delay, is there any other reasons to avoid IPSec?
2>In an environment with a lot of potential clients, what are the
recommended alternatives?
Thanks for any insight!
Bob Coppedge
me (at) RLCoppedge (put a dot here) com
IPSec can be processor intensive; so, offloading the encryption to an
outside engine would increase throughput. This could be through a support
NIC with these features, or a dedicated hardware appliance.
Short of that, you could use SSL encryption and/or HTTPS for communication.
Microsoft provides a good document on the subject through MSDN:
http://www.microsoft.com/downloads/details.aspx?displaylang=en&familyid=055ff772-97fe-41b8-a58c-bf9c6593f25e
Good luck.
Sincerely,
Anthony Thomas

"RL Coppedge" <RLCoppedge@.hotmail.com.(nospam)> wrote in message
news:28CF43D3-38DC-47A8-9C46-CC25D1A01150@.microsoft.com...
> The client I'm working with has a 2-node Failover cluster. Owing to their
> environment, they have several machines accessing the many databases. For
> cost reasons, they went with SQL standard.
> As to securing the traffic. I understand that IPSec isn't supported for
> failover cluster, owing to the recovery time (6 minutes, according to the
> document).
> But the recovery for SQL standard doesn't allow external connections until
> all databases are recovered. If the server has a lot of databases
(perhaps
> 50), there may already be a delay.
> I guess the questions I'm asking are:
> 1>Outside of the time delay, is there any other reasons to avoid IPSec?
> 2>In an environment with a lot of potential clients, what are the
> recommended alternatives?
> Thanks for any insight!
> Bob Coppedge
> me (at) RLCoppedge (put a dot here) com
>