MDX query returns double values

I have a Sales Margin cube having Revenue,Cost,Margin as measures and customer,sales invoice,product group,time,area as dimensions.When i run the following MDX query, i get a value for revenue which is double the value i should get.I checked the fact table, value in the fact table for this measure is correct.Any ideas ?

select {[Measures].[Revenue]} on columns,
non empty [Sales Invoice].members on rows
from [Sales Margin]

Regards

[450 byte] By [SQLProgrammer] at [2008-1-28]

«« Beta Experience
»» Custom ValidationRule examples?[dnelson MSFT]

# 1

If you check fact table there is only two ways to duplicate data. Did you check Sales invoice has not duplicate members? Try to full process your cube (what kind of proccessing has Sales Margin, take care of incremental proccess).
If these didn't work i'm sure you have defined 2 partitions for the cube, and they are the same.
I hope it helps you.

VectorR3 at 2007-9-9 >

top of Msdn Tech,SQL Server,SQL Server Analysis Services...

SQL Server Hot Topic

SQL Server New Topic

SQL Server

Java / MSDN / Linux Tech / PHP Tech / MSDN DotNet / MSDN TECH / Health Library / Programmers Tech / visual basic Tech / Developer Tech / Ipod faqs / Msdn China Tech