Hi, divide the customers by first letter A,B,C on a superior level...
"Chris Busch" <Chris Busch (AT) discussions (DOT) microsoft.com> escreveu na mensagem
news:F769EBAB-1ABF-4D6B-9F68-0F8C63A64BAD (AT) microsoft (DOT) com...

Hi Tore,

Can you provide more detail on how I can derive a level with first letter of
last name?





"Tore Johnsen" wrote:

Chris,
do this in the ETL part create a dimension table like:

cod_custgroup, dsc_custgroup, cod_customer, dsc_customer

1 A 12333 Hugh
Alister
1 A 12334 Diane
Anderson
2 B 12335 Bob
Barefoot
etc

and create two levels, Group and Customer from those fields

In the transformation you should use the substring and charindex clauses to
extract the first letter of the surname, or just make your life easy and use
the first letter of the first name (LEFT)



"Chris Busch" <ChrisBusch (AT) discussions (DOT) microsoft.com> escreveu na mensagem
news:2A431CD7-0731-4B2F-9042-CF0C933E7873 (AT) microsoft (DOT) com...

Hi,

Have a look at:

INF: How to Work with More Than 64,000 Children Per Parent WGID:223
ID: 303969.KB.EN-US
http://support.microsoft.com/default...b;en-us;303969

HTH,
Bas

"This posting is provided "AS IS" with no warranties, and confers no
rights."