That was a great presentation today at DAMA SA on “Semantics for Data Architects” with the FIB-DM model in PowerDesigner

It overran quite a lot today, but most people attending didn’t seem to mind. I’m talking about Jurgen Ziemer’s presentation for DAMA South Africa, talking about the FIB-DM data model he’s built from the FIBO ontology – you can see his presentation here. It’s a very large model, some of which is available for free – click on the Download link at https://fib-dm.com/ to ask for the free version.

The FIB-DM makes a lot of use of inheritance hierarchies, with some multiple inheritance in there as well, so it can take a while to get to grips with the model.

For example, I might be interested in knowing how the model handles Deposit Accounts. If I right-click the entity name in the object browser, I can use the context menu to find the diagram that contains the Deposit Account entity – it’s called “FIBO Finance, Business and Commerce – Products and Services, Clients and Accounts”, and it’s three levels down inside the package hierarchy within the model. Here’s what that diagram looks like – I’ve highlighted the Deposit Account entity:

The only diagram containing the Deposit Account entity

I can see that the entity is in one of those inheritance hierarchies, and that it’s got relationships to a couple of child entities. What I can’t see here are any connections to other objects that the modeller decided NOT to include on this diagram. That could be another parent or child entity, traceability links, or other relationships. What I’d like to see is a diagram that shows me the complete context for that entity – everything in the ‘proximity’ of the entity.

I could carefully work through the dependencies the entity has, and then select them for inclusion in a diagram, but I’d like a quicker way of doing it.

That’s where the CDM LDM Productivity model extension comes in – it can create that ‘Proximity’ diagram for me with a single click (I can also refresh it with a single click to make sure it’s up to date). Here it is:

Proximity diagram for Deposit Account

There isn’t much there that isn’t on the other diagram, just an extra parent entity – Banking Product. Crikey, that changes my understanding a little bit, I didn’t know about that, and I’d like to find out more. To start with, I’d like to see the inheritance hierarchies in more detail. This is also provided by the CDM LDM Productivity model extension – with one click I can create an Inheritance diagram for the entity, which can also be refreshed whenever I want:

Inheritance diagram for Deposit Account

I’ve hidden all the child entities from the diagram, as I’m primarily interested in the entity’s parentage – I can see that the entity is a great-grandchild of Product, and also a great-grandchild of Account.

These are just two of the features provided by the CDM LDM Productivity model extension – it also includes configurable naming standards, diagram completeness, and other features to improve the productivity of anyone working with Conceptual or Logical Data Models in PowerDesigner.

Book a FREE remote consultation on SAP #PowerDesigner so you can “Work Smarter with PowerDesigner”

SAP PowerDesigner is a great modelling tool with features that differentiate it from the rest of the market. Here are a few topics you might want to talk about:

  • Understanding PowerDesigner’s Capabilities
  • Planning how you’re going to use PowerDesigner
  • Establishing your Modelling Environment
  • Extending PowerDesigner
  • Training Users

Use the calendar below to find a time slot that suits you:

How to add #Erwin Extended Notes to a #PowerDesigner model

Recently I was looking at the list of new features in Erwin Data Modeler 2020, and one feature caught my eye – Extended Notes.

https://learndatamodeling.com/blog/new-features-in-erwin-release-2020-r1/

I knew that I could add a very similar feature to any object in PowerDesigner in less than 10 minutes, with absolutely no programming.

Here’s a simple Logical Data Model – the Entity “Contact Type” has four Extended Notes (one of those has its own Extended Note)

Here’s one of those notes. The properties are all standard, except for Status , Author, and Importance, which I defined in a Model Extension.

These Extended Notes can be compared and merged using the standard PowerDesigner Merge / Compare utility, and I can include them in Reports, List Reports, and Dependency Matrices

Want to see how it’s done? Watch this video.

To discuss how you can the best out of SAP PowerDesigner, go to the Contact page

From ontology to data model, with the #PowerDesigner Glossary

The Glossary is one of the key enterprise resources provided by SAP PowerDesigner – it helps you capture and manage the terminology to be used when naming your models and objects in your models.

What if you want to use your Glossary in a different way – as an ontology? What if you want to use the Glossary to generate content in your models?

That’s exactly what I was asked recently – the good news is that PowerDesigner is designed to be extended. We can meet our objective in several ways:

  • write a script – Design and build all the logic yourself
  • define a simple ‘Object Generation’ – Simple to set up, limited in scope
  • define an ‘Extended Object Generation’ – Simple to set up, will need some scripting to tailor the results

I created a couple of demonstrations for my client, and decided to share them with the world via YouTube.

This video has three parts:

  • the Introduction at 00:22
  • a demonstration of the capabilities of a script at 06:21
  • a demonstration of Object Generation and Extended Object Generation at 08:48.

To discuss how you can the best out of SAP PowerDesigner, go to the Contact page

I’m looking forward to my 2 hours talking to UKSUG about #PowerDesigner next week

Discover the history and key capabilities of SAP PowerDesigner (it’s more than just a data modelling tool), and how it can make life easier for you in Data Governance and Database Development.
This session will show you why you must not use Excel or Visio for data modelling, and find out just how easy it is to get started with PowerDesigner.
Also discover the hidden power of PowerDesigner’s unique customisation capabilities, such as automating the creation of audit tables.

Wednesday June 10th, from 13:00 to 15:00 British Summer Time

(12:00 to 14:00 GMT)

To register, contact Laura Goss
uksug@pbprojects.co.uk