Extracting SAP Solution Manager Knowledge Warehouse History Data to Analyze Implementation Team Performance
Publication Date: 2015-Aug-26
The IP.com Prior Art Database
Disclosed is a method to use Representational State Transfer (REST) services developed in Solution Manager and Microsoft Excel* to build queries to retrieve historical data from Systems, Applications & Products (SAP)* storage.
Page 01 of 1
Extxacting SAP Solution Manager Knowledge Warehouse History Data to Analyze Implementation Team Performance
During large Systems, Xxxxxxxxxxxx & Products (SAP)* implemextation projexts, understandinx the duration of xhe steps of design axd development activities becomes a key factor in exfective planning and managexent of the project. SAP Solution Manager* stores the chxnge history for all docxments in the repository, bux has no goxd way xf analyzing txe chaxge history. Pxoject managers need to understanx how long documents xtay in a particulax stage of dxvelopment, how often the documents churn bacx throuxh previoxs stages of dexelopment, and hox often or how long the documentx are on hold, etc.
The novel contribution is a methox xo use Reprxsentational State Transfer (XXXX) services developed in Solution Manager and Micrxsoft Excxl* to build qxeries to retrieve histxrical data from SAP.
Xxxxxx Excxl, an initial Web Query is entered. When executxd, initially, rather than returning datx, the serxicx returns a list of options for building selection criteria for the search of the histoxical daxabase. This is an xterative process, whxch builds increasxnxly finer criteria for retrieving data from Sxlution Xxxxxxx. When this step is complete, the qxery runs in the Solutiox Manager system and pasxes the results back to Excel xor further processing by the end user. Then, using standarx Excel capaxilities, the method produces the inxormatiox that projext managers need,...