Number ID Segment Customer
001 1 AAA 1
001 2 FFF 1
001 3 KKK 1
001 4 DDD 1
002 1 HHH 2
002 2 FFF 2
002 3 WWW 2
002 4 DDD 2
003 1 AAA 1
003 2 FFF 1
003 3 KKK 1
003 4 DDD 1

....
Is it possible for me to create a Cube (except to create a new table to store Route)
to analysis the Whole Segment(Route) data as
Route CustomerSum
AAAFFFKKKDDD 2
HHHFFFWWWDDD 2
.....
Thks .