sql server - How to omit empty values from PredictTimeSeries DMX query -


i'm using predicttimeseries function within dmx query in order values predictions, follows:

select flattened  predicttimeseries([miningmodel_8].[values], 100)  [miningmodel_8] 

it works well, problem @ point, result set returns empty values, so:

expression.$time    expression.values ------------------------------------- 30/04/2015          6 01/05/2015          4 02/05/2015          4 03/05/2015          3 04/05/2015          3 05/05/2015          <<-- here becomes empty 06/05/2015  07/05/2015  

how can cut empty rest of result set (so last record in above example 04/05/2015)?

any advice or appreciated, thank you

i believe can limit result set using clause. more details: https://msdn.microsoft.com/en-us/library/ms132048.aspx


Comments

Popular posts from this blog

css - SVG using textPath a symbol not rendering in Firefox -

Java 8 + Maven Javadoc plugin: Error fetching URL -

datatable - Matlab struct computations -