Alert based on Time based master data attributes

[former_member448106]

Hi Experts,

We are trying to setup an alert based on product end of life(EOL) date, which is a time stamp type attribute. We tried to compare this attribute with PERIODID but it fails the PA activation.

Then we tried comparing with PERIODIDFR which is in time stamp format. We got the PA active with this, but now we are not able to load this KF in planning view. We are getting an SQL Execution error for component -SCM-IBP-XLS-SRV.

So just wanted to understand is it possible to set up alerts based on comparison between Time based master data attributes(EOL) and PERIODIDs of time profile.

Attaching the KF config and error screenshots for reference.

Please guide.

Thanks.

Regards,

Naveen K

[ankpatel · Accepted solution]

Hi Naveen,

AS you know the message is not clear, but it can be an issue with the format of the date you are trying to load. Did you try loading data using Data Integration Job? If not, try doing that and you will get more accurate error why it is failing. Also, EOL is an attribute and not KF. So you have to load master data and not KF.

Regards

ankur

[former_member448106 · Accepted solution]

Thanks Ankur for your time.

EOL is definitely an attribute and not a KF. And referencing to RDS planning area its format is - e.g. -

2018-07-13 00:00:00.000 or you can save it as 2018-07-13(YYYY-MM-DD).

My query was if I can compare this attribute with PERIODID in KF calculation.

E.g. - if PERIODID0(Technical week) > EOL Date then 1 else 0.

I hope this helps clarifying the ambiguity in message, if any.

Thanks.

Regards,

Naveen K

[former_member242371 · Accepted solution]

Hi Naveen,

EOL is time stamp type attribute so cannot be compared with PERIODID0.

However PERIODID0FR will represent 'day' if your planning area has daily as lowest granularity.

Do you get SQL error also in daily view? You can check for this error in detail in application logs app.

Thanks,

Rohit

[limbagiri]

Hello Naveen,

You cannot make comparison between EOLDATE and PERIODIDs of time profile because PERIODIDs are nothing but period ID numbers you gave in time profile. Whereas EOLDATE is timestamp. Though PA is activated but you cannot add that KF in planning view because of inconsistent calculation logic.

You may achieve your requirement with below logic
1. Using HCI task, calculate number of days left i.e. ( EOLDATE - Current Date ) and push the result to one stored KF

2. Use condition on this KF in ALERT KF.

Kindly let me know the outcome if you are going to try above approach. This will work I suppose.

Thanks

Sai Samrat