I have arround 6 dimensions one of them is Customer dimension. I am
trying to get Top customer for any given 3 months.
Also quantity for Top customer. Query times out. Any solution for this.

Here is my query
Topcount([Customer].[Customer].members,1,[Measures].[Qty]).item(0).properties("Customer
Name")

Forgot to mention,Customer dimension has 50000 members.

Hi,

Please, post complete MDX query.

Vladimir Chtepa

"shruti" <vrayanker (AT) yahoo (DOT) com> schrieb im Newsbeitrag
news:1130987846.785585.239650 (AT) f14g2000cwb (DOT) googlegroups.com...

Query is only.
Topcount([Customer].[Customer].members,1,[Measures].[Qty]).item(0).properti*es("Customer

Name")

Vladimir,
Thanks for the mail
I have built the cube and I have a claculated membert TopCustomer.
Query is just as follows:
Topcount([Customer].[Customer].members,1,[Measures].[Qty]).item(0).properti*es("Customer

Name")

I don't have any additional queries

Additional to this I am using the BI tool for the client side.

Vladimir,

Thanks for your mail.

I have built a cube and created a calculated member called TopCustomer.
The calcualted member has a query

Topcount([Customer].[Customer].members,1,[Measures].[Qty]).item(0).properti*es("Customer

Name")

I don't have anymore query. I am not sure what you are expecting.

Additionally, I have BI tool to get the data. It doesn't bring due to
performance issue.

Do You can intercept full MDX query?
What do Yuu use? AS2000 or AS2005?

"shruti" <vrayanker (AT) yahoo (DOT) com> schrieb im Newsbeitrag
news:1131052652.851164.201430 (AT) g47g2000cwa (DOT) googlegroups.com...
Vladimir,
Thanks for the mail
I have built the cube and I have a claculated membert TopCustomer.
Query is just as follows:
Topcount([Customer].[Customer].members,1,[Measures].[Qty]).item(0).properti*es("Customer

Name")

I don't have any additional queries

Additional to this I am using the BI tool for the client side.