Kindly help me with below requirements.
I have an input ready query where user/business can update the Sales Qty value and then save the workbook.
Before image output of the Ananlysis for Office is shown in the image ( Before Image).
Now, the requirement is that whenever any user update/change a particulr Sales Qty value, ( for example in this case, the user change the Sales Qty from 200 to 300) then the corresponding Column: Modified By and Modified Date has to be updated automatically as shown in the image( After Image). Here the condition is that only the row/entries which user changes/modifed has to be udpated with the Modified By and Modified Date( In the image, for example user James modified it on 04-08-2022 and only this row has been updated)
Could you kinldy help as to how i can achieve this dynamically? Any existing Planning Functions(FOX code) with which i can acheive this requirement?
I guess you are looking for change history with respect to a given keyfigure
In BW IP you can not enable auditing info. Datasource update data will not solve your scenario as you wan individual row update info seperately. Datasource update data and time will show overall infoprovider update and always show the last update.
Viewers/ readers - If you find above information helpful, feel free to up-vote (arrows on left side).