Existing Logical Data Model Update through excel sheet

[Vipul09]

Hi ,

I believe when we use Import button in SAP Power Designer for importing an excel file it creates a fresh model.

My requirement is to update the existing LDM available in my local repository by excel.

Is it possible to do so ?

If yes , please guide me on it.

Thanks,

Vipul 

SAP PowerDesigner BW Data Modeling (WHM) 

[Ondrej_Divis · Accepted solution]

Hi Vipul,

once your initial imort is done, you can repeat it as many times as needed through Import fuction in the context menu of Excel import object. But keep in mind, that you can only add new objects or modify already existing objects. But you cannot delete objects through standard Excel import.

HTH,

Ondrej Divis

[Vipul09 · Accepted solution]

Hi Ondrej Divis,

When I am trying to update the Logical Data Model entity and attribute.

I am able to update the attribute name , code , mandatory etc but its not updating the Domain Value that I am passing from excel.

The domain values that I am passing, I already have created in LDM before passing but still not updating under the attribute.

Thanks,

Vipul

[Ondrej_Divis · Accepted solution]

Vipul, I had to reply in separate answer, because commenting in this new forum unfortunately doesn`t allow image insertion...

[Ondrej_Divis]

Hi Vipul, even objects like Domains can be imported during Excel import. You just have to make sure that during excel import is the domain value treated like object (and not like string property). After that, even non-existing domains should be created automatically by PD as new objects in the model and attached to your entity attribute. One excel sheet can contain metadata only for one object type. So if you want to import both Entity and EntityAttribute metadata, you have to put them on two separate excel sheets. Domain metadata can be imported only from EntityAttribute sheet.

Correct naming of headers of your excel columns will speed up the import, correct naming of your excel sheets will speed up the import process too.

HTH,

Ondrej Divis

[Vipul09]

Hi Ondrej Divis, If we want to update only the Attribute name from A1 to A2 without adding a new attribute as A2, how should we proceed ? Can you please explain with a proper excel template ? Thanks Vipul

[Ondrej_Divis]

Excel import must have some property, which is used as "primary key" in order to match your excel rows with appropriate PD objects. Either Name or Code can be used as such primary key. If you change your primary key, you have no clue how to find original object. You can perhaps experiment with using Code as your primary key during the import and changing the Name, but make sure that it works together with your Naming conventions settings in your Model Options. Ondrej