HI,
my ascill file format is ...... total records are 7
here the date is the keffigure and remain are char's
sloc num date location
B 0077 09/16/2002 MUM
B 0077 09/17/2002 DEL
B 0077 09/18/2002 MUM
B 0077 09/19/2002 HYD
B 0077 09/16/2002 CHE
B 0077 09/21/2002 HYD
B 0077 09/22/2002 KOL
when i load the data to cube i got only 5 records...
B 0077 09/17/2002 DEL
B 0077 09/18/2002 MUM
B 0077 09/21/2002 HYD
B 0077 09/16/2002 CHE
B 0077 09/22/2002 KOL
here 2 records were overwrittem according to the location wise
i have not used any routines to filter the records
can u tell me how do i achieve all the records into cube..
Thanks...