Friday, March 9, 2012

Microsoft_Time_Series DMX parser error

Can anyone tell me why my syntax is wrong and a fix? Obviously it's the PERIODICITY_HINT, but I'm doing what the BOL says...

ALTERMININGSTRUCTURE [zzz]

ADDMININGMODEL [xxx]

(

...

)

UsingMicrosoft_Time_Series (

PERIODICITY_HINT = {12},

AUTO_DETECT_PERIODICITY=0.1

)

I get this error:

Query (9, 24) Parser: The syntax for '{' is incorrect.

The parameter type of PERIODICITY_HINT is string, therefore it needs to be quoted, e.g.

ALTERMININGSTRUCTURE [zzz]

ADDMININGMODEL [xxx]

(

...

)

UsingMicrosoft_Time_Series (

PERIODICITY_HINT = '{12}',

AUTO_DETECT_PERIODICITY=0.1

)

No comments:

Post a Comment