MDX Query is slow when execute using linked server

[krajeshkumar]

Hi,

I am having 2lac records in a cube, my requirement is to get the cube results using openquery and linked server. When i try to execute this query it take more time when compare to the normal sql query.

Is there is any thing i am doing worng or can someone help me to improve the performance.

This is the query is trying
SELECT * FROM OPENQUERY(olap_server,
' Select
[PATIENT_DETAILS:Pres Patient First Name],
[PATIENT_DETAILS:Pres Patient Last Name]


from
[Patient_details]
WHERE

[PATIENT_DETAILS:Pres Patient First Name] = ''DENISE''')

Please help me

[Island1]

Isn't this the same issue as you are attempting to describe (albeit initially from another angle) in "Can we use Analysis service to create a cube for huge records?"

If so, let's try to keep the threads together to make this a little less confusing.

Your consideration is appreciated.

Bill

[krajeshkumar]

How to keep the threads together. Please let me know

[Island1]

Thanks for helping us to keep it easy for subsequent searchers to see full dialogs / solutions!

Bill