Using timestamp/Date comparison in Key Figure calculation

[former_member367912]

Hi Guys,

Need help on below requirement.

In MDT LocationProduct there is a new attribute REFENDDATE for which against Product Location combination a timestamp/date is maintained.

There is KF1 and KF2 which holds values.

Suppose 10/15/2018 date falls on WK37 in the below screenshot and WK30 is current week.

Now I want to populate KF3 which will hold KF1 values till WK37 and from WK38 it will values from KF2

Let me know for any further details if required.

Regards,

Akhilesh Agarwal

[ankpatel · Accepted solution]

Hi Akhilesh,

Unfortunately, you cannot compare PERIODID attribute (Current week) with Time Stamp Attribute (REFENDDATE) in KF modeling. One of the best options is to handle this requirement using HCI. Do the date comparison in HCI and load the data accordingly.

Regards

Ankur

[former_member367912 · Accepted solution]

Hi Ankur,

Thanks for looking into this. Even I thought of the HCI as the last resort to handle this requirement.

Also I tried Attribute (REFENDDATE) comparison with PERIODID but that gives exception and don't work.

If I am not getting any other option then will go for HCI thing

Thanks Again,

Akhilesh Agarwal

[ankpatel · Accepted solution]

Yes, that is what limitation we have. We cannot compare PERIODID to TIMESTAMP (Attribute)