Tuesday, May 29, 2012

PowerDesigner 16.0 CDM entity properties displays TRUE instead of actual value

Product: PowerDesigner Enterprise Architect Version 16.0.0.3576 EBF5
OS: Windows 7 Professional

 In CDM entity property window, clicking in property column displays TRUE instead of the actual text in the cell.

Closing and reopening the entity property window temporarily fixes it, but TRUE will be displayed eventually.  If press TAB to step through all columns, when it wraps to next row, problem is temporarily fixed.

Bug reported: Case 11738269 created successfully.

Monday, May 7, 2012

PowerDesigner: Report "No paragraph numbering" option does not work.

Product: PowerDesigner Enterprise Architect Version 16.0.0.3576 EBF5
OS: Windows 7 Professional

Create a report.
Open the report's properties.
Check the "No paragraph numbering" option; click OK.


From the report editor "Report items" pane, right click the top level item in hierarchy.
Select "Quick view"; no paragraphs are numbered.


Select Report from the menu; select "Generate Report"
Paragraphs are still numbered.




PowerDesigner Bug Report Case:
Case Id: 11735031 - Report "No paragraph numbering" option does not work.

Tuesday, May 1, 2012

PowerDesigner 16.0: Model Options settings not applied when opening model

Product: PowerDesigner Enterprise Architect Version 16.0.0.3576 EBF5
OS: Windows 7 Professional

The settings for a PDM configured in Model Options are not applied when opening the model.  In order to get them applied, I have to open Model Options after the PDM is opened and, without changing any settings, click OK.  The settings are then applied.  This is consistent with some models and does not happen with others.

The one it is consistent with is an Oracle Version 11g database model.

Bug Report created 5/1/2012
Case 11734125

Wednesday, April 18, 2012

Comparitive EDW Architecture Seminar by Bill Inmon

I attended a "Comparitive EDW Architecture" seminar put on by Bill Inmon in Golden, CO, on 4/4/2012 to 4/6/2012.  The purpose of the seminar was to explain the different DW philosophies of Inmon and Kimabll and how they can not only be used together, but complement each other.

Sadly, no one from the "official" Kimball organization accepted Bill's invite to present at the conference.  Scott Hirst, Ultra Solutions, Inc., did attend and presented the Kimball DW architecture philosophy very well.  Thanks, Scott.

The seminar presented Inmon's latest DW 2.0 architecture philosophy and Kimball's latest Dimensional architecture.  Also discussed was how the two of them can complement each other.

The DW 2.0 architecture was compared to a city's architecture and Kimball's Dimensional model was compared to a house's architecture.  The DW 2.0 architecture (in at least 3NF normal form) provided the enterprise data warehouse (EDW) foundation upon which the Dimensional  architecture is used to build the data marts needed for OLAP and reporting.

Of course, the best part of any seminar like this is the chance to network with others and learn from shared experiences.


Power Designer 16: Multi-line text in Description and Annotation columns not always displayed

 Product: PowerDesigner Enterprise Architect Version 16.0.0.3576 EBF5
OS: Windows 7 Professional

In PDM, select Model => Tables
Show Name, Comment, Description, Annotation columns
Sort by Description
Click ... for any apparently blank column that appears between rows with displayed text in column.
Text for column will appear.
Close editing window.
Text will appear in column displayed in grid.

Bug report made: Case 11732189

Thursday, March 22, 2012

Power Designer 16 Stereotype change custom symbol bug

PowerDesigner Enterprise Architect
Version 16.0.0.3576 EBF5
OS: Windows 7 Professional

I have created stereotypes in the Oracle 11g DBMS xdb file for table and reference.  The stereotype, "Deprecated", changes the fill color, gradient, and line style for the stereotype's custom object.

The stereotype is applied to several tables and references.

Now I need to change the custom symbol properties for the stereotypes.  I expect the changes to be applied to tables and references that have been assigned the "Deprecated" stereotype.  Instead, these objects get reformatted back to the default settings!  I need to open each object and reassign the stereotype to get the formatting applied.

Sybase, Inc. - Case-Express bug report attempted, but their web site generates Java error message.

PowerDesigner 16 PDM Display Preferences - Table - Columns

PowerDesigner Enterprise Architect
Version 16.0.0.3576 EBF5
OS: Windows 7 Professional 

Issue:  Changing of Table display preferences for selected items only does not work after first use.

Steps:
  1. Open PDM and diagram.
  2. Select one table
  3. Select Tools=>Display Preference
  4. Select Table in "Display Preferences" Category
  5. Change Columns setting.  Say Columns was not checked by default, but for specific table(s) you want to display all the columns.
  6. Click OK
  7. "Changing Formats" dialog should have "Selected symbols" already selected.
  8. Click OK
  9. Select another table in diagram
  10. Select Tools=>Display Preferences
  11. Select Table in "Display Preferences" Category
  12. Settings in "Table" section should be same
  13. Click OK
  14. No "Changing Formats" dialog window is displayed and tables are not changed.
Work Around: 
  1. Change the Table settings to anything else, apply them, and then change the Table settings back to what you want.
  2. Right click table with desired display settings, select "Get Format".
    Right click target table and select "Apply Format"
    CAUTION: The entire set of format and display options will be applied to target table, so if fill color, shadow, line style, etc. are different in target table, they will be changed, too.
Sybase Inc. - Case-Express bug opened:
Case Id: 11727786 - PDM Display Preferences - Table - Columns not reusable