Home > Archive > MS SQL Data Warehousing > November 2006 > error deploying analysis server cube









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author error deploying analysis server cube
Garza_JP

2006-10-31, 7:13 pm

Has anyone ever received this message before?
"The Description element at line 3123, column 29 (namespace
http://schemas.microsoft.com/analys...ces/2003/engine) cannot appear
under
Envelope/Body/Execute/Command/Batch/Alter/ObjectDefinition/Database/Cubes/Cube/Dimensions/Dimension."

All I was doing was adding description to the properties of the dimension
tables. I was doing this so that the report user can see pop-up descriptions
in Report Builder.

I haven't been able to resolve this problem. Not only that - Now that I've
received this error, I haven't been able to reset the solution file so that I
don't get this error. I have even removed all the description changes I
made, but to no avail.

Can anyone help me?

--JP
Darren Gosbell

2006-11-14, 5:15 am

There are a couple of things you could try.

1) you could run Profiler while you are trying to deploy, this way you
would be able to capture the XMLA that is being sent to the server. You
would then be able to copy and paste the XMLA into a text editor and
search it. Maybe there is one change that you have missed undoing.

2) If all else fails, you could re-create your project from the database
on the server by starting a new project and choosing the "import
Analysis Services 9.0 database option"

--
Regards
Darren Gosbell - SQL Server MVP
Blog: http://www.geekswithblogs.net/darrengosbell

In article <16360AA6-10E3-4E75-9124- D939176CC1C2@microso
ft.com>,
Garza_JP@discussions
.microsoft.com says...
> Has anyone ever received this message before?
> "The Description element at line 3123, column 29 (namespace
> http://schemas.microsoft.com/analys...ces/2003/engine) cannot appear
> under
> Envelope/Body/Execute/Command/Batch/Alter/ObjectDefinition/Database/Cubes/Cube/Dimensions/Dimension."
>
> All I was doing was adding description to the properties of the dimension
> tables. I was doing this so that the report user can see pop-up descriptions
> in Report Builder.
>
> I haven't been able to resolve this problem. Not only that - Now that I've
> received this error, I haven't been able to reset the solution file so that I
> don't get this error. I have even removed all the description changes I
> made, but to no avail.
>
> Can anyone help me?
>
> --JP
>

Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2009 droptable.com