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.
| Author |
Topic |
|
LuckyJim1001
Starting Member
3 Posts |
 Posted - 2010-08-12 : 07:52:51
|
| Hi all,I have a measure that totals Sales Revenue.If I connect to the cube via Excel 2003 and pivot it for Q4 2008 I get a figure of just over £14 millionHowever in SSMS with an MDX query I get just under £13 millionBig difference.I freely admit I am a newb to SSAS and MDX but have done programming and SQL coding before and I am at a loss as to the difference and it is quite frankly worrying me :-)The cube is based on daily sales with a time demsion with all the usual suspects, Weeks, Months, Qtrs, Years.Any advice where to start looking would be much appreciated.Thanks in advance. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-08-12 : 13:46:44
|
| might be problem with MDX. did you try browsing value using cube browser and check what value it returned?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
LuckyJim1001
Starting Member
3 Posts |
Posted - 2010-08-13 : 04:53:47
|
| Sorry - please ignore. Was using a different measure. That is what happens when you have stared at the screen all day and have very similar names for measures. Sorry. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-08-14 : 02:19:40
|
| no probs...glad that you sorted it out------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
|
|
Discrepency's between MDX query and Excel Pivot