System Center Data Warehouse Base Library

DisplayName	ID	Base Class	Abstract	Hosted	Singleton	Group	Extension	Accessibility
Data Warehouse Base Managed Type	Microsoft.SystemCenter.Datawarehouse.Base.ManagedType	System.Entity	True	False	False	False	False	Public
Data Warehouse Base Management Pack	Microsoft.SystemCenter.Datawarehouse.Base.ManagementPack	System.Entity	True	False	False	False	False	Public
Data Warehouse Base Relationship Type	Microsoft.SystemCenter.Datawarehouse.Base.RelationshipType	System.Entity	True	False	False	False	False	Public
Data Warehouse CMDB Source	Microsoft.SystemCenter.DataWarehouse.CMDBSource	Microsoft.SystemCenter.DataWarehouse.DataSource	False	False	False	False	False	Public
Data Warehouse Data Source	Microsoft.SystemCenter.DataWarehouse.DataSource	System.AdminItem	True	False	False	False	False	Public
Data Warehouse Management Pack	Microsoft.SystemCenter.DataWarehouse.ManagementPack	System.AdminItem	False	False	False	False	False	Public

Relationship Types (1)

	DisplayName	ID	Source	Target	Accessibility	Abstract
	Is Related to Management Pack	DataSourceAssociatesManagementPack	Microsoft.SystemCenter.DataWarehouse.DataSource	Microsoft.SystemCenter.DataWarehouse.ManagementPack	Public	False

Enumerations (33)

DisplayName	ID	Parent	Accessibility
Base Domain	Domain		Public
Activity Management	Domain.ActivityManagement	Domain	Public
Change Management	Domain.ChangeManagement	Domain	Public
Configuration Management	Domain.ConfigurationManagement	Domain	Public
Incident Management	Domain.IncidentManagement	Domain	Public
Instance Management	Domain.InstanceManagement	Domain	Public
Orchestration	Domain.Orchestration	Domain	Public
Problem Management	Domain.ProblemManagement	Domain	Public
Release Management	Domain.ReleaseManagement	Domain	Public
Service Catalog	Domain.ServiceCatalog	Domain	Public
Datasource Type	DW.DatasourceType		Internal
Linking Framework	DW.DatasourceType.LinkingFramework	DW.DatasourceType	Internal
Operations Manager	DW.DatasourceType.OperationsManager	DW.DatasourceType	Internal
Service Manager	DW.DatasourceType.ServiceManager	DW.DatasourceType	Internal
Unknown	DW.DatasourceType.Unknown	DW.DatasourceType	Internal
Source Action	DW.SourceAction		Internal
Registered	DW.SourceAction.Registered	DW.SourceAction	Internal
Unregistered	DW.SourceAction.UnRegistered	DW.SourceAction	Internal
Domain.Common	Domain.Common	Domain	Public
Domain.ConfigurationManager	Domain.ConfigurationManager	Domain	Public
Domain.OperationsManager	Domain.OperationsManager	Domain	Public
Domain.SLAManagement	Domain.SLAManagement	Domain	Public
DW.SourceStatus	DW.SourceStatus		Internal
DW.SourceStatus.Disabled	DW.SourceStatus.Disabled	DW.SourceStatus	Internal
DW.SourceStatus.Enabled	DW.SourceStatus.Enabled	DW.SourceStatus	Internal
DW.Transform.Template	DW.Transform.Template		Public
DW.Transform.Template.AbstractDimension	DW.Transform.Template.AbstractDimension	DW.Transform.Template	Public
DW.Transform.Template.AbstractSingleRelationshipFact	DW.Transform.Template.AbstractSingleRelationshipFact	DW.Transform.Template	Public
DW.Transform.Template.ConcreteDimension	DW.Transform.Template.ConcreteDimension	DW.Transform.Template	Public
DW.Transform.Template.ConcreteSingleRelationshipFact	DW.Transform.Template.ConcreteSingleRelationshipFact	DW.Transform.Template	Public
DW.Transform.Template.MultiRelationshipFact	DW.Transform.Template.MultiRelationshipFact	DW.Transform.Template	Public
DW.Transform.Template.Outrigger	DW.Transform.Template.Outrigger	DW.Transform.Template	Public
DW.Transform.Template.StateTransition	DW.Transform.Template.StateTransition	DW.Transform.Template	Public

Resources (18)

ID	File Name	Accessibility
TransformDataSourceDimResource	TransformDataSourceDim.sql	Public
TransformEntityDimResource	TransformEntityDim.sql	Public
TransformEntityManagedTypeFactResource	TransformEntityManagedTypeFact.sql	Public
TransformEntityRelatesToEntityFactResource	TransformEntityRelatesToEntityFact.sql	Public
TransformGroupContainsConfigItemFactResource	TransformGroupContainsConfigItemFact.sql	Public
TransformManagedTypeDimResource	TransformManagedTypeDim.sql	Public
TransformManagementPackDimResource	TransformManagementPackDim.sql	Public
TransformRelationshipTypeDimResource	TransformRelationshipTypeDim.sql	Public
TransformServiceContainsConfigItemFactResource	TransformServiceContainsConfigItemFact.sql	Public
UninstallDataSourceDimResource	UninstallDataSourceDim.sql	Public
UninstallEntityDimResource	UninstallEntityDim.sql	Public
UninstallEntityManagedTypeFactResource	UninstallEntityManagedTypeFact.sql	Public
UninstallEntityRelatesToEntityFactResource	UninstallEntityRelatesToEntity.sql	Public
UninstallManagedTypeDimResource	UninstallManagedTypeDim.sql	Public
UninstallManagementPackDimResource	UninstallManagementPackDim.sql	Public
UninstallRelationshipTypeDimResource	UninstallRelationshipTypeDim.sql	Public
UninstallTransformGroupContainsConfigItemFactResource	UninstallTransformGroupContainsConfigItemFact.sql	Public
UninstallTransformServiceContainsConfigItemFactResource	UninstallTransformServiceContainsConfigItemFact.sql	Public

Assemblies (1)

	ID	File Name	Accessibility
	Microsoft.SystemCenter.ManagedSource.Assembly	Microsoft.SystemCenter.ManagedSource.dll	Internal

Data Warehouse Scripts (9)

ID	Install Script	Uninstall Script	Upgrade Script	Upgrade Unsupported	Accessibility
TransformDataSourceDimProc	TransformDataSourceDimResource	UninstallDataSourceDimResource	TransformDataSourceDimResource	False	Public
TransformEntityDimProc	TransformEntityDimResource	UninstallEntityDimResource	TransformEntityDimResource	False	Public
TransformEntityManagedTypeFactProc	TransformEntityManagedTypeFactResource	UninstallEntityManagedTypeFactResource	TransformEntityManagedTypeFactResource	False	Public
TransformEntityRelatesToEntityFactProc	TransformEntityRelatesToEntityFactResource	UninstallEntityRelatesToEntityFactResource	TransformEntityRelatesToEntityFactResource	False	Public
TransformGroupContainsConfigItemFactProc	TransformGroupContainsConfigItemFactResource	UninstallTransformGroupContainsConfigItemFactResource	TransformGroupContainsConfigItemFactResource	False	Public
TransformManagedTypeDimProc	TransformManagedTypeDimResource	UninstallManagedTypeDimResource	TransformManagedTypeDimResource	False	Public
TransformManagementPackDimProc	TransformManagementPackDimResource	UninstallManagementPackDimResource	TransformManagementPackDimResource	False	Public
TransformRelationshipTypeDimProc	TransformRelationshipTypeDimResource	UninstallRelationshipTypeDimResource	TransformRelationshipTypeDimResource	False	Public
TransformServiceContainsConfigItemFactProc	TransformServiceContainsConfigItemFactResource	UninstallTransformServiceContainsConfigItemFactResource	TransformServiceContainsConfigItemFactResource	False	Public

Dimensions (20)

DisplayName	ID	Target	Inferred Dimension	Hierarchy Support	Reconcile	Accessibility
Billable Time Dim	BillableTimeDim	System.WorkItem.BillableTime	True	IncludeExtendedClassProperties	False	Public
Computer Dim	ComputerDim	Microsoft.Windows.Computer	True	IncludeExtendedClassProperties	True	Public
Config Item Dim	ConfigItemDim	System.ConfigItem	True	Exact	True	Public
Config Item Group Dim	ConfigItemGroupDim	Microsoft.SystemCenter.ConfigItemGroup	True	IncludeExtendedClassProperties	True	Public
Data Source Dim	DataSourceDim	Microsoft.SystemCenter.DataWarehouse.CMDBSource	True	Exact	True	Public
Deployed Computer Dim	DeployedComputerDim	System.ComputerHardware	True	IncludeExtendedClassProperties	True	Public
Entity Dim	EntityDim	System.Entity	True	Exact	False	Public
Group Dim	GroupDim	System.Group	False	Exact	True	Public
Logical Disk Dim	LogicalDiskDim	Microsoft.Windows.LogicalDisk	True	IncludeExtendedClassProperties	True	Public
Managed Type Dim	ManagedTypeDim	Microsoft.SystemCenter.Datawarehouse.Base.ManagedType	True	IncludeExtendedClassProperties	False	Public
Management Pack Dim	ManagementPackDim	Microsoft.SystemCenter.Datawarehouse.Base.ManagementPack	True	IncludeExtendedClassProperties	False	Public
Network Adapter Dim	NetworkAdapterDim	Microsoft.Windows.NetworkAdapter	True	IncludeExtendedClassProperties	True	Public
Operating System Dim	OperatingSystemDim	Microsoft.Windows.OperatingSystem	True	IncludeExtendedClassProperties	True	Public
Physical Disk Dim	PhysicalDiskDim	Microsoft.Windows.PhysicalDisk	True	IncludeExtendedClassProperties	True	Public
Processor Dim	ProcessorDim	Microsoft.Windows.Processor	True	IncludeExtendedClassProperties	True	Public
Relationship Type Dim	RelationshipTypeDim	Microsoft.SystemCenter.Datawarehouse.Base.RelationshipType	True	IncludeExtendedClassProperties	False	Public
Service Dim	ServiceDim	System.Service	True	Exact	True	Public
User Dim	UserDim	System.Domain.User	True	IncludeDerivedClassProperties	True	Public
Work Item Dim	WorkItemDim	System.WorkItem	True	Exact	False	Public
Work Item Group Dim	WorkItemGroupDim	System.WorkItemGroup	True	Exact	False	Public

Outriggers (6)

DisplayName	ID	Accessibility
Action Type	ActionType	Public
Config Item Asset Status	ConfigItemAssetStatus	Public
Config Item Object Status	ConfigItemObjectStatus	Public
Service Classification	ServiceClassification	Public
Service Priority	ServicePriority	Public
Service Status	ServiceStatus	Public

Relationship Facts (23)

DisplayName	ID	Domain	Time Grain	Source Type	Source Dimension	Accessibility
Billable Time Has Working User Fact	BillableTimeHasWorkingUserFact	Domain.InstanceManagement	Daily	System.WorkItem.BillableTime	BillableTimeDim	Public
Computer Hosts Logical Disk Fact	ComputerHostsLogicalDiskFact	Domain.Common	Daily	Microsoft.Windows.Computer	ComputerDim	Public
Computer Hosts Network Adapter Fact	ComputerHostsNetworkAdapterFact	Domain.ConfigurationManagement	Daily	Microsoft.Windows.Computer	ComputerDim	Public
Computer Hosts Operating System Fact	ComputerHostsOperatingSystemFact	Domain.Common	Daily	Microsoft.Windows.Computer	ComputerDim	Public
Computer Hosts Physical Disk Fact	ComputerHostsPhysicalDiskFact	Domain.ConfigurationManagement	Daily	Microsoft.Windows.Computer	ComputerDim	Public
Computer Hosts Processor Fact	ComputerHostsProcessorFact	Domain.Common	Daily	Microsoft.Windows.Computer	ComputerDim	Public
Config Item Group Contains Entities Fact	ConfigItemGroupContainsEntitiesFact	Domain.ConfigurationManagement	Daily	Microsoft.SystemCenter.ConfigItemGroup	ConfigItemGroupDim	Public
Config Item Impacts Customers Fact	ConfigItemImpactsCustomersFact	Domain.ConfigurationManagement	Daily	System.ConfigItem	ConfigItemDim	Public
Config Item Owned By User Fact	ConfigItemOwnedByUserFact	Domain.ConfigurationManagement	Daily	System.ConfigItem	ConfigItemDim	Public
Config Item Relates To Config Item Fact	ConfigItemRelatesToConfigItemFact	Domain.ConfigurationManagement	Daily	System.ConfigItem	ConfigItemDim	Public
Config Item Serviced By User Fact	ConfigItemServicedByUserFact	Domain.ConfigurationManagement	Daily	System.ConfigItem	ConfigItemDim	Public
Service Impacts User Fact	ServiceImpactsUserFact	Domain.ConfigurationManagement	Daily	System.Service	ServiceDim	Public
Work Item About Config Item Fact	WorkItemAboutConfigItemFact	Domain.InstanceManagement	Daily	System.WorkItem	WorkItemDim	Public
Work Item Affected User Fact	WorkItemAffectedUserFact	Domain.InstanceManagement	Daily	System.WorkItem	WorkItemDim	Public
Work Item Assigned To User Fact	WorkItemAssignedToUserFact	Domain.InstanceManagement	Daily	System.WorkItem	WorkItemDim	Public
Work Item Created By User Fact	WorkItemCreatedByUserFact	Domain.InstanceManagement	Daily	System.WorkItem	WorkItemDim	Public
Work Item Group Contains Work Item Fact	WorkItemGroupContainsWorkItemFact	Domain.InstanceManagement	Daily	System.WorkItemGroup	WorkItemGroupDim	Public
Work Item Has Billable Time Fact	WorkItemHasBillableTimeFact	Domain.InstanceManagement	Daily	System.WorkItem	WorkItemDim	Public
Work Item Relates To Config Item Fact	WorkItemRelatesToConfigItemFact	Domain.InstanceManagement	Daily	System.WorkItem	WorkItemDim	Public
Work Item Relates To Work Item Fact	WorkItemRelatesToWorkItemFact	Domain.InstanceManagement	Daily	System.WorkItem	WorkItemDim	Public
ComputerHasPrimaryUserFact	ComputerHasPrimaryUserFact	Domain.ConfigurationManagement	Daily	Microsoft.Windows.Computer	ComputerDim	Public
WorkItemHasParentWorkItemFact	WorkItemHasParentWorkItemFact	Domain.InstanceManagement	Daily	System.WorkItem	WorkItemDim	Public
WorkItemImpactsServiceFact	WorkItemImpactsServiceFact	Domain.InstanceManagement	Daily	System.WorkItem	WorkItemDim	Public

Facts (4)

DisplayName	ID	Domain	Time Grain	Accessibility
Entity Managed Type Fact	EntityManagedTypeFact	Domain.InstanceManagement	Daily	Public
Entity Relates To Entity Fact	EntityRelatesToEntityFact	Domain.InstanceManagement	Daily	Public
Group Contains Config Item Fact	GroupContainsConfigItemFact	Domain.Common	Daily	Public
Service Contains Config Item Fact	ServiceContainsConfigItemFact	Domain.Common	Daily	Public

Warehouse Modules (9)

ID	ETL Module	Warehouse Module Type	Target Warehouse Entity	Accessibility
TransformDataSourceDim	TransformDataSourceDimProc	Transform	DataSourceDim	Public
TransformEntityDim	TransformEntityDimProc	Transform	EntityDim	Public
TransformEntityManagedTypeFact	TransformEntityManagedTypeFactProc	Transform	EntityManagedTypeFact	Public
TransformEntityRelatesToEntityFact	TransformEntityRelatesToEntityFactProc	Transform	EntityRelatesToEntityFact	Public
TransformGroupContainsConfigItemFact	TransformGroupContainsConfigItemFactProc	Transform	GroupContainsConfigItemFact	Public
TransformManagedTypeDim	TransformManagedTypeDimProc	Transform	ManagedTypeDim	Public
TransformManagementPackDim	TransformManagementPackDimProc	Transform	ManagementPackDim	Public
TransformRelationshipTypeDim	TransformRelationshipTypeDimProc	Transform	RelationshipTypeDim	Public
TransformServiceContainsConfigItemFact	TransformServiceContainsConfigItemFactProc	Transform	ServiceContainsConfigItemFact	Public