Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2000 Forums  Analysis Services (2000)  Improve Performance in MDX Query

Author  Topic  Leoaob Starting Member 2 Posts Posted - 2002-11-27 : 14:50:20 I made the following query: WITH MEMBER [Produto].[ Noticiário] AS ' ([Produto].&[P31+], [Conta].&[CN51]) ' MEMBER [Produto].[ Classificados] AS ' ([Produto].&[P32+], [Conta].&[CN51]) ' MEMBER [Produto].[ J.Bairro] AS ' ([Produto].&[P33+], [Conta].&[CN51]) ' MEMBER [Produto].[ Encartes] AS ' ( Produto.&[P34] , [Conta].&[CN51]) ' .. more 50 members SELECT NON EMPTY { [Produto].[ Noticiário] , [Produto].[ Classificados] , [Produto].[ J.Bairro] , [Produto].[ Encartes] , [Produto].[ Projetos Especiais] , [Produto].[ GloboOn Noticiário] , ... more 50 members } on Rows, { [Versao].&[2100], [Versao].&[2200], [Versao].&[2300] } on Columns FROM [Orcamento] WHERE ( [Measures].[ValorSupZero] , [Ano].[2003] , [Canal].&[CANAL] , [Moeda].&[DOLAR.ORCAMENTO] , [Unidade].&[UNIDADE] , [Responsavel].&[RESPONSAVEL] The performance of this query is really bad. I think is because the number of members. I use this members like a rename of the field and any calculate. How can i improve this performance? Anybody help me!!!