Data Warehouse and Class Extensions

Nick_Flint

Very often after I add extend a class to add a new property and import the sealed class extension; our Data Warehouse starts having issues were it either stops archiving data altogether or won't add the new property to the DW database.

Does anyone have or know of a resource with a procedure to safely import class extensions and have them transfer into the DW?

Conner_Wood

Unfortunately there is a unfixed bug in SCSM. I reported it to Microsoft back in 2016 but they never touched it and ultimately they deleted their submitted ticket database.

Bug causes 100% Data Warehouse MP Corruption - Import Sealed MP for DataWarehouse that contains StateTransition Fact that uses a Dimension that has specified "Extends" Attribute

The workaround is to not use extends so that the "Data Warehouse Bug - Duration Fact using Dimension with "Extends" corrupts DW 100%" does not happen.

As for safely, you have 2 sealed management packs, one with the sealed properties and relationships, then one for the DataWarehouse Dimensions (Properties) and Facts (Relationships). Note that class extensions don't need Dimensions specified if the main class has HierarchySupport="IncludeExtendedClassProperties"

https://community.cireson.com/discussion/comment/3760#Comment_3760

If you are interested in getting stuff into the DWAS Cubes

https://community.cireson.com/discussion/comment/9688#Comment_9688

EDIT: More Examples

https://social.technet.microsoft.com/Forums/systemcenter/en-US/6aaa5cc2-fc9c-4f6a-bc51-d0a2f70b11f1/custom-fields-in-dw-and-cubes?forum=dwreportingdashboards

For additional info on correctly making readable extended relationships and then using them in projections, see Cireson Thread Change Request Primary Owner

Conner_Wood

Unfortunately there is a unfixed bug in SCSM. I reported it to Microsoft back in 2016 but they never touched it and ultimately they deleted their submitted ticket database.

Bug causes 100% Data Warehouse MP Corruption - Import Sealed MP for DataWarehouse that contains StateTransition Fact that uses a Dimension that has specified "Extends" Attribute

The workaround is to not use extends so that the "Data Warehouse Bug - Duration Fact using Dimension with "Extends" corrupts DW 100%" does not happen.

As for safely, you have 2 sealed management packs, one with the sealed properties and relationships, then one for the DataWarehouse Dimensions (Properties) and Facts (Relationships). Note that class extensions don't need Dimensions specified if the main class has HierarchySupport="IncludeExtendedClassProperties"

https://community.cireson.com/discussion/comment/3760#Comment_3760

If you are interested in getting stuff into the DWAS Cubes

https://community.cireson.com/discussion/comment/9688#Comment_9688

EDIT: More Examples

https://social.technet.microsoft.com/Forums/systemcenter/en-US/6aaa5cc2-fc9c-4f6a-bc51-d0a2f70b11f1/custom-fields-in-dw-and-cubes?forum=dwreportingdashboards

For additional info on correctly making readable extended relationships and then using them in projections, see Cireson Thread Change Request Primary Owner