Products like ERWIN

[Former Member]

Good day

We have requirement in product like ERWIN but for BW 7.41. We have too many cubes and ods , thats is why looking for product which helps to manage

architecture of system. Is anyone knows such product?

[GeorgeMcGeachie · Accepted solution]

PowerDesigner can manage your physical data models - you can use Silwood Safyr to reverse-engineer from BW into PowerDesigner. Take a look at the product here - SAP BW - Silwood Technology. I know they'll be happy to demonstrate it for you.

If you're running BW on HANA, and the views have been activated, then PowerDesigner can reverse-engineer those BW items activated in HANA using the standard HANA reverse engineering built into PowerDesigner.

PowerDesigner Physical Data Models support Cube models directly - not sure if Safyr imports these or not - here's a simple example:

The tool also has a Data Movement model, which you can use to document (and even generate, depending on technology) how the data moves around your architecture - how much detail you want to include is up to you. Each of the databases in this diagram is represented by one or more Physical Data Models; you can run impact analysis to trace the path that data in one of your tables takes through the transformations (the brown squares in the diagram).

[Former Member · Accepted solution]

Thanks George ,will look . Anyone else?