sql server data warehouse: XML Data type in SSAS 2005 -- sql server data warehouse

Re: XML Data type in SSAS 2005

Bhupesh Mohan
10/9/2007 10:16:01 PM

Thanks for your reply,
I tried in changing the size of the Xml data type, eventhough it is giving
the same exception.

One more thing I want to know that, How can I achieve, to convert the Xml
data type to String in Attributes.

[quoted text, click to view]

Re: XML Data type in SSAS 2005

ML
10/10/2007 12:56:01 AM

In the Project Browser right-click the erroneous dimension and select View
Code. In the dimension's definition find the section where your XML column is
defined (the Attribute element - look at its Name child element).

Change the value of the DataType element to "WChar", and set the value of
the DataSize element appropriately.

ML

---
Matija Lah, SQL Server MVP

Re: XML Data type in SSAS 2005

Bhupesh Mohan
10/10/2007 2:24:00 AM

Hi
Glad to see you here.

By default, SSAS 2005 WCHAR will select as the Xml Data type and also I had
changed the Data size as you informed in your blog.

Even though its showing the same exception.

[quoted text, click to view]

Re: XML Data type in SSAS 2005

ML
10/10/2007 3:22:05 AM

How large is this data? Why do you need it in the cube in the first place?
Have you tried casting the values explicitly to [n]varchar (e.g. using a
named calculation in the data source view)?

ML

---
Matija Lah, SQL Server MVP

Re: XML Data type in SSAS 2005

MC
10/10/2007 6:55:35 AM

Im not certain about XML type, but in general, this eror occurs when the
datatype in DSV (and in dimension) is wrong. Try refreshing the DSV and
checking the size of the XML datatype. If that doesnt help, perhaps you can
convert it to string and control the size that way?

MC

[quoted text, click to view]

Re: XML Data type in SSAS 2005

Bhupesh Mohan
10/16/2007 1:11:00 AM

Hi Matija lah,

Thanks for your reply, Sorry for the delay,
I created the Named calculations for that columns. Its working fine,
But, Is it possible that I can add the string value to the Data area.

Bhupesh Mohan

[quoted text, click to view]

Re: XML Data type in SSAS 2005

ML
10/16/2007 1:21:00 AM

What do you expect to accomplish by doing that? Is text a measure or a
dimension?

ML

---
Matija Lah, SQL Server MVP

Re: XML Data type in SSAS 2005

Bhupesh Mohan
10/16/2007 1:38:00 AM

My target is to get the XML as the Output from the cubes.

For that,

I tried to create the Xml column as the Dimensions, that We can't get the
XML as an output using dimensions,

After that I created the Xml column as Measures, there I am not able to add
other than Numeric values.

Is there any solutions for this?

Thanks
Bhupesh Mohan

[quoted text, click to view]

Re: XML Data type in SSAS 2005

ChrisHarrington
10/22/2007 11:14:57 PM

For what it's worth - I store XML in the description field.

[quoted text, click to view]

Re: XML Data type in SSAS 2005

ML
10/23/2007 1:09:02 AM

What calculations can you do on XML instances? Imagine aggregating XML data
(e.g. SUM, AVG...) - how could that work on XML?

ML

---
Matija Lah, SQL Server MVP

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server data warehouse group.