cancel
Showing results for 
Search instead for 
Did you mean: 

How to copy IBP current week Key figure value in the same key figure for previous week

advait1998
Explorer
0 Kudos
561

For key figure Stock end, there is one value for current week (W02 2023)-27 which is dynamic and value can be change on daily basis.

When we will come at next week, the value for key figure will get displayed in (W03 2023) and no value (blank) in (W02 2023).

Requirement: User want to see in future what was the value of that key figure in (W02 2023), when we will move on to the next weeks further.

For example: We are in (W07 2023) now, then user want to see the value in (W02 2023 or W03 2023....) which is currently blank.

So I want to copy the data for key figure value of current week (W02 2023) before the start of the next week when value will get shifted automatically to (W03 2023).

When I will be in W03 2023, I want to see what was the value at the end of (W02 2023).

(We cannot use snapshot because it has limitation of 9 only and user wish to see the data in the past time bucket from current week onwards)

(Note: This is the KF from order based planning area and the data for this key figure described above is updated by the CI-DS job running on daily basis)

Accepted Solutions (0)

Answers (1)

Answers (1)

girish_nitie
Participant

Copy Operator with Period offset should work here.

advait1998
Explorer
0 Kudos

Current week (W02 2023), Next week (W03 2023).

Currently, At the end of (W02 2023), the value is getting deleted in (W02 2023) and when next week starts(W03 2023), the value is getting updated in the (W03 2023).

My requirement is at the end of (W02 2023), that value should also be visible in (W02 2023), .should not get deleted in (W02 2023)

But KF value in (W03 2023) is dynamic getting updated daily, so if I use Period Shift, then the value in (W02 2023) will also get change when current value is also changing. Is my analysis correct?

girish_nitie
Participant
0 Kudos

Please run CI_DS interface in insert update... and update only current week. (Previous week value will remain as it is then)

0 Kudos

I tried using this particular setting you mentioned while running the CI-DS Job.

Result: The key figure data got updated in the next week (W03 2023), but the current key figure value in (W02 2023) got vanished/deleted. (My requirement is current key figure value should remain at it is and visible, should not get deleted.)

Have I made any mistake in the CI-DS settings?

girish_nitie
Participant
0 Kudos

I don't know about CI-DS settings, so can't comment. you can test the solution with data integration job with csv file upload.. Current week insert update won't delete previous week KF values and then ask you CI-DS resource to do similar updates via interface.

advait1998
Explorer
0 Kudos

I want to add one point on your this suggestion is:

I want Target KF should be same as the input KF. I want to see the data in past week in same KF only.

girish_nitie
Participant
0 Kudos

Ignore copy operator, not needed here. Insert update in current week is enough to retain values in previous weeks.