October 6, 2015 at 8:44 am
Hi,
I'm using SSAS to predict data and I'm a junior on that. I was able to Data Mine my data using Time Series and to show on the graph the historic values, the prediction and the high and low standard deviations.
So, now, when I start querying this data with DMX I can see the historic predictions and the future predictions using PredictTimeSeries function, but I'm unable to show the high and low standard deviations values that shows on the graph on Visual Studio (Show Deviations). I searched and used several other functions, but none of them showed me this value.
Do you guys know which function I should use to query the high and low standard deviations?
Thanks
October 9, 2015 at 6:24 am
I'm not totally sure on this (I abandoned the SSAS data mining suite in favour or RStudio and Rattle due to it being quite underwhelming) but you could probably try some manipulation of the RangeMax and TopSum functions to get to what you need. Other than that, maybe run a trace on the SSAS instance and see what BIDS is throwing at it when it generates those values on the graph?
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply