on 2023 Jan 12 7:14 AM
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)
Request clarification before answering.
Copy Operator with Period offset should work here.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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?
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?
User | Count |
---|---|
6 | |
4 | |
3 | |
2 | |
2 | |
2 | |
2 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.