Friday, March 15, 2019

How to find out who uploaded file to BPC server

EPM add-in of MS Excel offers functionality of uploading files to BPC server. These are so called Data Files of Data Manager functions. It enables to upload files from local user machine to BPC server. Uploaded files can be later used within BPC packages, transformations and so on. 

I was wondering whether there is no information about who uploaded particular file. Within e.g. Data Preview, function there is only information about when was the file modified for last time but no information who modified/uploaded it.

Luckily, there is a table available in BW backend, which holds this information. It is table UJF_DOC. While browsing for table in t-code like SE11 you need to provide environment ID first into APPSET field at selection screen; afterwards put a full path of file in Data Manager into field DOCNAME.

This will return you the user name in field LSTMOD USER that is not available on BPC’s popups in EPM add-in.

No comments: