time series against a cube in SSAS2005, how to??????

[Jeje]

Hi,

I try to create a simple test data mining model to forecast the sales.
my cube contains a time dimension with only the fiscal years.
I create my time series DM model, select the years as the key time, but when
I try to publish the solution I'm receiving an error:
Error 1 Error (Data mining): The data type specified for the 'Fiscal Years'
column of the 'Test' OLAP mining structure is not compatible with its source
attribute ('Dim Fiscal Years' in the 'Fiscal Years' cube dimension). 0 0I don't understand what's appends.

The key column is a smallint column in the database and in the cube.

any idea?

thanks
Jerome.

[Dejan Sarka]

Jeje,

Check the data type of the column you are using as Key Time in your mining
model. For this type of column, allowed data types are Double, Long, and
Date. Maybe is the OLAP type text? Can you create a calculated member of
desired type in your cube, and use it as key time in mining model? Or is it
just wromng mapping from OLAP to DM type, and you can just change the data
type in your mining structure?
--
Dejan Sarka
http://blogs.solidq.com/EN/dsarka/default.aspx

Post by Jeje
Hi,
I try to create a simple test data mining model to forecast the sales.
my cube contains a time dimension with only the fiscal years.
I create my time series DM model, select the years as the key time, but
Error 1 Error (Data mining): The data type specified for the 'Fiscal
Years' column of the 'Test' OLAP mining structure is not compatible with
its source attribute ('Dim Fiscal Years' in the 'Fiscal Years' cube
dimension). 0 0I don't understand what's appends.
The key column is a smallint column in the database and in the cube.
any idea?
thanks
Jerome.

[Jeje]

I'm using a smallint type
I have tried to use int type, but its the same result.

the system doesn't found any of these types compatible with a long or double
type.

Post by Dejan Sarka
Jeje,
Check the data type of the column you are using as Key Time in your mining
model. For this type of column, allowed data types are Double, Long, and
Date. Maybe is the OLAP type text? Can you create a calculated member of
desired type in your cube, and use it as key time in mining model? Or is
it just wromng mapping from OLAP to DM type, and you can just change the
data type in your mining structure?
--
Dejan Sarka
http://blogs.solidq.com/EN/dsarka/default.aspx

Post by Jeje
Hi,
I try to create a simple test data mining model to forecast the sales.
my cube contains a time dimension with only the fiscal years.
I create my time series DM model, select the years as the key time, but
Error 1 Error (Data mining): The data type specified for the 'Fiscal
Years' column of the 'Test' OLAP mining structure is not compatible with
its source attribute ('Dim Fiscal Years' in the 'Fiscal Years' cube
dimension). 0 0I don't understand what's appends.
The key column is a smallint column in the database and in the cube.
any idea?
thanks
Jerome.