Skip to Content
avatar image
Former Member

HANA Prediction demand - Populate new column

Hi Team, Need one help about prediction for populating new column. I need to populate one new column -10 Yrs_Max_Predicted Load demand( screen shot - last column ).

I have applied double exponential algo ( Predictive Analytics tool ) and got the data for next 20 year prediction of Transformer Demand, which is available in table. all data available in same table , I need to populate based on that date and needs to put in the right side column

I want to create new one column(10 Yrs_Max_Predicted Load demand) where next 10 years prediction will display from current month in the right side.

for example , this month (201708 ) demand is 70.1 I want to populate data 202708 in this column which is 101 as highlighted below.

Next month (201709 ) demand is 70.2, I want to populate data 202709 in this column, which is 102 as below.

next Year_month(201710), next 10 yrs (202710), I want 103 to be polulated in the right column.

My doubt is - How can I populate this field 10 Yrs_Max_Predicted Load demand

refer to the below screen shot.

Transformer ID| Location | Capacity (MV) | Year_Month | Next 10 _yrs Date |Max_Predicted Load(MV) | 10 Yrs_Max_Predicted Load demand

load-demand.jpg (204.7 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Aug 24, 2017 at 08:59 AM

    Hello Friends,

    Any update. I want to populate last column 10 Yrs_Max_Predicted Load demand.



    Add comment
    10|10000 characters needed characters exceeded