Skip to Content

Model SAP BW DSO in PowerDesigner

Hi,

just a quick question: what's the best approach to model a SAP BW DSO in PowerDesigner?

Just wondering, which diagram would fit best, which database type (in case I decide to go with PDM) to pick ...

Any thoughts. I don't see a "native" integratioin of SAP BW DSOs in PD.

This is only for documentation purposes...no code generation required

Regards,

Rafal

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Jan 07, 2015 at 12:34 PM

    Hi rafal,

    to use PDM "databaseindependend" or with an unknown targetDB you can use ANSI2.

    CreateModel(PdPDM.cls_Model, ModelFileName & "|DBMS=ANSI Level 2")

    HTH

    dj

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Dec 23, 2014 at 09:52 AM

    Hi Rafal,

    If it is for ETL, try the Data Movement Model.

    If it is for datastructures use CDM,LDM,PDM.

    Hans

    Add comment
    10|10000 characters needed characters exceeded

    • Hi Hans,

      it is for both. What I'm trying to do at the moment is:

      1. Model the DSO in PD

      2. Map/Link this DSO model to the Finance & Risk Analytics model (LDM) extracted from BA using the FAR extraction routine

      After this is done, we have to model the data flow (here I will use DMM).

      Regards,

      Rafal