dimension- to many lines

[chenchun]

hi,

i want to filter tabelle to a searchterm.
if i want to insert the column as a new dimension, olap says error: too many lines (about 64000), something like that.

what should i do now? how can i use this dimension.

sorry about my english! im from germany

thanx

 

[scottshelby]

First, what type of data is in the dimension?

You might want to look at changing the source column using the Left(x,x) statement. This works for something I had to do Left("dbo"."Claim"."ClaimNumber",2). You then add the same field as another level to the dimension and it will group by the first two characters.

What version of SQL are you using?

SQL 2000 has the ability to Automatically design dimension categories.