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)
 Magical results from an MDX ???

Author  Topic 

Joozh
Posting Yak Master

145 Posts

Posted - 2005-03-08 : 02:00:31
Hi,

This problem has been driving me crazy for the past few days and I really have no clue at all about how to solve the problem and where to look.

With 1 refresh of the cube the following MDX returns correct data but after the next update of the cube, the same MDX does not display an data at all

SELECT
{[Period].[All Period].[2005].[Quarter 1].Children} ON COLUMNS,
{[SalesType].[All SalesType].[Local],[SalesType].[All SalesType].[Exports]} ON ROWS
FROM Sales
WHERE ([Measures].[NetSales])


Desparately calling experts for some clues.

Thanks.
   

- Advertisement -