Skip to Content
0

HANA Prediction demand - Populate new column

Aug 23, 2017 at 06:50 AM

36

avatar image
Former Member

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)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

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

Hello Friends,

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

Regards,

Kamruz

Share
10 |10000 characters needed characters left characters exceeded