Skip to Content

SAP BW Data Model Documentation

Dear Experts,

I have requirement to document end to end data model flow in SAP BI system.

This should include full data flow from Multiprovider to PSA with all objects involved, Transformations mappings and if any routines used in mappings, DTPs and logics used in it if any, fields in each object.

Similarly for Report level as well.

I wanted to know if there is any good way to accomplish this in SAP BI Workbench with less manual work. Or if there is any free tool i can use to extract this info.

Hopin for your suggestion.

Regards

Syed Zabiullah

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • Posted on Jul 18, 2016 at 04:26 AM

    below tables will help.

    rsdcubeiobj - cube and io details.

    rsdodsoiobj - DSO and io details.

    rsdicmultiiobj - MP and details.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jul 18, 2016 at 07:09 AM
    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jul 18, 2016 at 07:38 AM

    Hello,

    You can achieve that by using standard ways.

    If your version allows it (from BW 7.3), you can use "Data flows" tab in rsa1. It allows you to graphically drag and drop the selected objects you want to document and use the existing links between them. Quicklinks are available to show "Objects on level afterwards", "Objects on level before" from a starting object.

    When your dataflow is updated with all the objects you want to document, you choose the "Data flow documentation" button. It will provide you complete list of technical properties of the objects selected : modelisation of providers, mappings of transformations (rules types, codes...), queries...

    It can be a good starting point for dataflow documentation.

    Hope it helps

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.