Hi all,


i'd like to have a dimension table that includes a ntext field, as i
need to store a longer free text in it.

Unfortunately the cube is unable to process the cube with such a field.

Is it a general problem to store a ntext/text/xml field in a cube with
SQL 2005 Analysis Services?

Thanx a lot for any help!
Marc

AS2005 is not designed to store this type of information!

Maybe you can store this in a property but deactivate the options to
aggregate this attribute (create hierarchy disabled)
you should be able to display these values through drillthrough commands or
actions, but not from the dimension himself. (like a pivottable analysis)

"Marc" <M.Thierer (AT) web (DOT) de> wrote

A couple of options:
- CAST the ntext column to a smaller datatype
- You can try to use the MemberValue binary binding to store this

Keep in mind though that neither will be good solutions on a very large
scale -- there are limits to the amount of string/binary data that can be
stored for the attribute members (around 4GB).

Thanks,
Akshai
--
Try out the MSDN Forums for Analysis Services at:
http://forums.microsoft.com/MSDN/Sho...ID=83&SiteID=1

This posting is provided "AS IS" with no warranties, and confers no rights
Please do not send email directly to this alias. This alias is for newsgroup
purposes only.

"Jéjé" <willgart_A_ (AT) hotmail_A_ (DOT) com> wrote