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

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.

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

"Jeje" wrote in message

> 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.
>
>