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
Post a Comment