Skip to Content

Creating technical documentation in BW is always a pain. Anoying pages and pages of tables : cubes attributes, transformation mapping… No brain, no gain… but lots of customers ask this kind of docs, because it’s the process ! (And if i must tell the truth… sometimes it’s usefull)

So i created a program to extract all technical objects of a flow and write it in a word document. You can generate simple document like a master data direct alimentation from ECC : just choose your masterdata from selection screen and push F8.

But you can also generate a complete flow document, starting from a workbook and got all cubes, transformations, DSO, and datasources that is involved in the flow. All ABAP routine and formulas are added in the document. It’s not more complex to generate, you just have to select your workbook from selection screen and tick the “recursive” box option before press the F8 key.

http://quelquepart.biz/data/images/zautodoc/zautodoc1.png

Word document is generated using a DOTX template, so you can customize the template with YOUR colors and themes. A cover image is also added on first page. At the begin of the documentation, a dataflow graphic is added to help the global understanding of the flow.

You could choose to display DTP & IP in the document or not, or only if they are in process chain… it’s your choice.

The program use my abstraction class CL_WORD to generate the DOCX file. You need to install it to use ZAUTODOC.

Finally, all of this is free

French presentation can be found here : ZAUTODOC : Documentation technique BW automatique ! – Quelquepart

And there is a direct download link (remember that you will need SAPLINK to install .slnk file) : http://quelquepart.biz/telechargements&file=L2RhdGEvbWVkaWFzL1pBVVRPRE9DLnppcCoyYTY4OGY&source=SCN-AUTODOC

Feel free to comment here


My others blogpost :

LISTCUBE replacement : a new way to display data

ZAL11 : a replacement for AL11

ZTOAD – Open SQL editor

Abstraction class to generate MSWORD with SAP using OLE

Generate DOCX file in ABAP

To report this post you need to login first.

3 Comments

You must be Logged on to comment or reply to a post.

  1. Former Member

    Hi Hermann,

    This is excellent and something i have been searching for a while. Thanks for the tool. Is there anyway i can execute the program only till a particular info-provider and not the complete flow everytime. The reason is Any object i give, it is picking the entire flow till the data source. Also i did not the table as shown above instead plain text without tables. Am i missing something? Thanks again for the great source. It is very useful

    Regards

    Haradev

     

    (0) 
  2. Sébastien HERMANN Post author

    Hello,

    Actually, the program is designed to generate documentation with direct ascendant flow :

    If you ask documentation for an infocube, you will get :

    • infocube
    • All transformations to this infocube
    • Source of transformation (only if infosource or datasource)
    • DTP
    • IP (only if datasource found)

    If you tick the “recursive” checkbox, you will get also all infoprovider that are source of your cube, etc until datasource

    Actually, transformation, DTP, IP, (and update rules 3.x) are not independant objects (not proposed in selection screen) but are attached to an infoprodiver.

     

    For your second problem, it sound like a “style” problem. At the begin of the program, there is constant called cs_custo that contain all things that you can (may… must) change to fit to your requirements.

    All style names are in this part. You can check which table style are available in the template you used, and which one are defined in cs_custo. I think the gap is here and that’s why you got plain text instead of “beautiful” word tables.

     

     

    (0) 

Leave a Reply