Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
saveriop
Starting Member
1 Post |
 Posted - 2003-09-26 : 10:14:17
|
| How can I obtain a distinct count aggregation on a text fact table coloum?I tried to add a CheckSum calculated coloumn to my fact table, but OLAP return strange results. |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2003-09-26 : 19:53:17
|
| eeeeeeeeeeeewwwwwwwwww, I don't know anything about Analysis Services, but I do know that you can't aggregate text/ntext/image columns in SQL Server. It's unlikely AS will either.If you can convert the text column to varchar(8000), you'll be able to get distinct values for that, but you'll also lose everything past the 8,000th character in the text body. If it's at all possible to change the database structure, and you don't absolutely need more than 8,000 characters of storage, you should change that column from text to varchar(8000). |
 |
|
|
|
|
|
Distinct count on text measures