Unable to retrieve columns with DMX queries on PREDICTTIMESERIES RRS feed

  • Question

  • I am using business intelligence studio 2008 and database server is SQL 2012. I have created a mining structure using Time Series and I have given name and path columns which are integers as inputs and memory size another integer column as value to be predicted. But when I write the following query,

    PREDICTTIMESERIES([Memory Size],30),
    [Name],[File Path]
    FROM [Fact Images NEWTS]

    I get the following error:

    Error (Data mining): Only a predictable column (or a column that is related to a predictable column) can be referenced from the mining model in the context at line 3, column 1.

    How can I get the predictable column value with its associated other columns? Please advice.


    Tuesday, September 16, 2014 4:11 PM