I'm going for "Analysis Services Error Message of the Week":
"The 'root' element at line , column (namespace 'urn:schemas-microsoft-com:xml-analysis:empty') cannot appear under Envelope/Body/ExecuteResponse/return because the parent already contains a child element, ''.
As you can clearly see, what I was trying to do was to add a linked Time dimension into a very simple A/S 2005 cube. This is the error I get when I process the cube.
Interestingly, if the solution needs deploying to the sever first, although the deployment step tells me it has worked (and therefore moves on to cube processing), I get a "Deployment Failed" message in the bottom left of the screen, to go with my "Deployment Succeeded" message at the bottom right of the screen.
Can anyone translate this error message into a known language
Thanks
Mick
Linked Dimensions
Drudkh
Yes, the provider you mention is not on the list of providers supported by AS2005.
As for the linked dimension. It is hard to say what is going on. If you are trying to have a single dimension shared between 2 cubes, you might want to consider creating single cube with multiple measure groups.
I would be happy to take a look if you can reproduce the problem you describe by creating a new cube based on the AdventureWorks sample.
Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
AdrianWalls
The error message indicates that XMLA command has not been built correctly.
Now about failed deployment. You got one of the cases when deployment progress dialog has some inconsistency. You should believe it when it says "Deployment Failed".
Hard to say what has gone wrong, try building a simple cube with only few dimensions and then add linked dimension to it. See if you get a better grip on the situation.
Hope that helps.
Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
sachinsharma
Thanks Edward. Unfortunately my cube couldn't get much simpler - it has one dimension and one measure! I'm trying to link to a Time dimension in another cube so that I can bring in a couple of measures that can share the new time dimension with my single native cube measure.
My data source is odd - would that make a difference I'm connecting to OSISoft PI (a real time historian) through their OLEDB provider. The browse data function works fin in the DSV and the cube processes fine until I bring in the linked dimension.
Mick