Prediction

navaneeth79 — Fri, 03 Nov 2017 08:38:05 GMT

Hello all, a very warm morning

I have a data of average ram utilization for last 30 days say 4%, I want to predict the ram utilization at next 30th day or 60th day.

for example for oct if ram utilization is 4% at the end of month (total avg) we could be able to predict the ram utilization at say 30th November.

can anyone please help me out in this

Re: Prediction

micheledenardi — Fri, 03 Nov 2017 09:21:30 GMT

Ram utilization depends from lots of things like:

- Number of active users (concurrent);

- Dimension of your documents (in terms of number of record and dimensions);

- Load script quality and calculations;

- Hardware;

So if you want to predict the amount of RAM at 30th november and we assume:

- Number of concurrent active users at 30th nov is the same as today;

- The number of dimensions at 30th nov is the same as today;

- Load script quality and calculations at at 30th nov is the same as today;

- Hardware at 30th nov is the same as today;

- Records increase steadily;

- Your Layout doesn't change;

Assuming that PROBABLY your ram calculation prediction could be something like:

January RAM usage incr.= RAM at 31/01/2017 - RAM at 01/01/2017

February RAM usage incr.= RAM at 28/02/2017 - RAM at 01/02/2017

March RAM usage incr.= RAM at 31/03/2017 - RAM at 01/03/2017

April RAM usage incr.= RAM at 30/04/2017 - RAM at 01/04/2017

May RAM usage incr.= RAM at 31/05/2017 - RAM at 01/05/2017

June RAM usage incr.= RAM at 30/06/2017 - RAM at 01/06/2017

July RAM usage incr.= RAM at 31/07/2017 - RAM at 01/07/2017

August RAM usage incr.= RAM at 31/08/2017 - RAM at 01/08/2017

September RAM usage incr.= RAM at 30/09/2017 - RAM at 01/09/2017

October RAM usage incr.= RAM at 31/10/2017 - RAM at 01/10/2017

AVG Monthly RAM usage incr.= (January RAM usage incr. + February RAM usage incr. + March RAM usage incr. + April RAM usage incr. + May RAM usage incr. + June RAM usage incr. + July RAM usage incr. + August RAM usage incr. + September RAM usage incr. + October RAM usage incr.)/10

Ram needed at 30/11/2017= RAM at 31/10/2017 + AVG Monthly RAM usage incr.

Hope it helps

topic Prediction in QlikView

Prediction

Re: Prediction