Developer Edition vs Enterprise Edition

Does anyone know why the same cube
deployed on 2 different servers (one Enterprise Edition,
the other a Developer Edtion) with the same MDX
query would return 2 different Results?

MDX query I am using:

WITH MEMBER [Measures].[TimeChargedToDate] AS
'SUM({NULL:[Timesheet].[Date].&[2006].&[9].&[15]},[Time Charged])'

SELECT NON EMPTY
{
[Measures].[Time Charged],
[Measures].[TimeChargedToDate]
} ON COLUMNS,
NON EMPTY
{
(
[Project].[Project Number].&[Z07600] *
[Staff Member].[Staff Member Name].[Staff Member Name].ALLMEMBERS
)
} ON ROWS
FROM
(
SELECT
{[Timesheet].[Date].[Year].&[2006].&[9].&[2] : [Timesheet].[Date].[Year].&[2006].&[9].&[15]}
ON COLUMNS
FROM
(
SELECT ( [Project].[Project Number].&[Z07600] ) ON COLUMNS
FROM [Timesheet_Cube]
)
)

On the Enterprise Edition my results are:
Time Charged TimeChargedToDate
Z07600 Person One (null) 0.25
Z07600 Person Two (null) 2
Z07600 Person Three (null) 1
Z07600 Person Four 82 276
Z07600 Person Five 69.5 307.75
Z07600 Person Six (null) 187.25
Z07600 Person Seven (null) 24.5
Z07600 Person Eight (null) 77.5
Z07600 Person Nine 34 34

On the Developer Edition My results are:
Time Charged TimeChargedToDate
Z07600 Person Four 82 82
Z07600 Person Five 69.5 69.5
Z07600 Person Nine 34 34

Same query, same cube, same data (I backed up the processed cube
from the developer edition and restored it on the Enterprise Edition to
make sure that I did not reProcess the cube and have that affect something)
and somehow I get different results.

Any ideas as to why this is happening?

Hello. We can test this more rapidly if you can repeat this using the Adventure works cube and an MDX-example with that cube.

Are the service packs or hotfixes different on these servers? What tool do you use to query the cubes?

Regards

Thomas Ivarsson

|||

Nothing special has been done with the servers.
They are both 2005 servers and I am using Management
Studio as my MDX query tool.

I can try to reproduce this with adventureworks... It will
take some time.

|||

Are both servers sp1 servers. Do one or both have the same hotfixes after sp1?

Do you use the same partions on both servers(one or several?)

Regards

Thomas Ivarsson

|||

I cannot reproduce the problem with
AdventureWorks using MS sample UDM.

|||

It appears that my local machine
may not have SP1 installed. I will
give that a shot then try again.

Thanks.

|||

After installing SP1 on the Developer Edition,
this problem goes away... How interesting.

Thanks for you comments everyone!