HI All

am using time series algorithm for predict the crime 

so far i completed in following details ,

input data

Date-KeyTime

CFS-Key

CountofIncident as a Predict

Based on  i got  particular date ,what is the crime ,how many incident  going to happen ,like that i have complete.

but now i want to add one more key Columns,that is PatrolArea .

 I tried PatrolArea Also  One of the Key colyumn.but i got error(one key Column only possible).

so what i can do ?

i want to select another one key columns..

i want result like this:

Date PatrolArea CFS   Howmanys

2012-04-01 PatrolArea1  Asulted 10

like this i want ,plz let me know

Hi, try the following:

Go to the Mining Structure and select the current Key Column. Select it in the left window where the hierarchy of the structure is, not in the Data Source View area.

Go to the Properties (F4) and find General section. There is KeyColumns property. Now you should have CFS here. At the right hand of the name of CFS column there is a button with 3 dots. Click it.

Click Add in the opened window and then click OK.

Now there is a word Collection instead of CFS. Click again 3 dots button near New Binding (WChar).

You can see a new window where you can assign an existing column to the new Key Column. Choose

Binding Type = Column Binding

Source Table = the name of your table

Source Column = PatrolArea

Congrats, you have a complex key column.