Document formulas in web report

building reports webintelligence
1

Hi, is there a way to document all the formulas in a web report?
Thanks

2

Hi, I solved this with a python script running on a local WID-file copy of the webi document.
The wid-file is the local working copy used by the Rich Client.
And you’ll need python / jupyter notebook or lab to run the code.
initial version is here: GitHub - CoenHordijk/SAP-BO-WebI-file-analyzer: Python tool to analyze SAP Business Objects WebI documents but i’ve made some upgrades, like exporting the variable formulas, since then which are not checked in yet. Let me know when you are interested

3 Likes
3

Great tool ! Love it.

1 Like
4

You may also use the RESTful Web Services to get the list of variables for a document in the CMS and then also get the formula (definition) for each variable.

variables-list URL: …/raylight/v1/documents/[documentId]/variables
HTTP Method: GET

variables-details URL: …/raylight/v1/documents/[documentId]/variables/[variableId]
HTTP Method: GET

1 Like
6

This is brilliant and so helpful, thanks!