Morning all,
I've created a project with a SQL 2008 R2 Enterprise edition back-end. Deployed and Executed fine. Working perfectly.
However it's a demo environment, so I've just exported the project and imported it into a colleague's demo environment. The only difference between the two is that he is running a SQL 2008 R2 Standard edition back-end.
The Cubes won't deploy on this machine - failing with the error "The 'Semi-additive measures' feature is not included in the '64 Bit Standard Edition' SKU."
Other than re-designing the cubes on the second machine, does anyone have any ideas?
Cheers
2 comments
-
Jet Reports Historic Posts It would appear that the above issue is caused by having measures in the cubes that are of type 'AverageofChildren'.
I'm guessing this measure type is not compatible with SQL 2008 R2 Standard Edition which the error message alluded to.
What is frustrating is that we had set the deployment target to SQL 2008 R2 Standard, yet it still allowed to select the measure type that is not compatible.
Maybe Jet/TimeXtender could be modified to prevent you from using functions that are not compatible with the target SQL version.
This would have saved us a great deal of time. -
Jet Reports Historic Posts Hello Ian,
I will look into this more closely and request a suggestion if necessary.
In the meantime, I believe that you could create a Business Function that would achieve the same thing without having to use the AverageOfChildren type measure that is only available in SQL Enterprise. The Business Function would look like this:
AVG(Hierarchy.CurrentMember.Children, Value)
Where the Parameters would be set to:
"Hierarchy" = Hierarchy Type
"Value" = Measure Type
Let me know if you have any questions!