Skip to Content
author's profile photo Former Member
Former Member

Data Modeling Tool


Can anyone recommend a data modeling tool that does effective dimensional modeling? It's probably wishful thinking but it would be wonderful if there was something out there that we could use to reverse-engineer our production BW system.



Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on Nov 04, 2003 at 05:15 PM


    I think that is a good idea to use some modeling tool for BW.

    And I do not understand why there is no such tool in SAP BW.

    There are only recommendations to use some tool like Visio (it is from ASAP).

    But for me better do not use a modeling tool at all than use Visio.

    Before BW I was involved in some data warehouse projects

    and I used ErWin 3.5 (with data warehouse template).

    I tried to find some modeling tools a couple of months ago

    that allow to depict complex SAP BW structure, but

    I found only add-on for ErWin that called Saphir Data Model

    but I couldn't run that tool (because of lack of license).

    But I think sales representatives can help you


    Hope this helps,

    Andrey Goryunov

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member


      what i sometimes use are Mind Maps. I like the idea of Mind Mapping and think that a branch in a Mind Map is likewise a Dimension and a Characteristic on that branch is something like a leaf. There ist a special Branch and several Leafs for every key figure. An additional branch can be used for the Navigation Attributes.

      On the strength of past experience in Workshops this is a good idea.

      When Using the MindManager, you can put the documentation for every branch and leaf into the Mind Map and it is possible to Export that as a set of HTML Files.



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.