Provance ITAM-Software-Data Warehouse-Bibliothek

Provance.ServiceManager.Itam.Software.Datawarehouse :: 2.0.8006.0 (Management Pack)

Management Pack Elements

Resources (2)

 IDFile NameAccessibility
TransformSoftwareTitleHasOwnersFactProcResourceTransformSoftwareTitleHasOwnersFactProcResourceTransformSoftwareTitleHasOwnersFactProc.sqlPublic
UninstallTransformSoftwareTitleHasOwnersFactProcResourceUninstallTransformSoftwareTitleHasOwnersFactProcResourceUninstallTransformSoftwareTitleHasOwnersFactProc.sqlPublic

Data Warehouse Scripts (1)

 IDInstall ScriptUninstall ScriptUpgrade ScriptUpgrade UnsupportedAccessibility
TransformSoftwareTitleHasOwnersFactProcTransformSoftwareTitleHasOwnersFactProcTransformSoftwareTitleHasOwnersFactProcResourceUninstallTransformSoftwareTitleHasOwnersFactProcResourceTransformSoftwareTitleHasOwnersFactProcResourceFalsePublic

Dimensions (14)

 IDTargetInferred DimensionHierarchy SupportReconcileAccessibility
ExcludedSoftwareItemGroupDimExcludedSoftwareItemGroupDimProvance.ITAM.ExcludedSoftwareItemGroupTrueIncludeExtendedClassPropertiesFalsePublic
SkuDimSkuDimProvance.ITAM.SkuTrueIncludeExtendedClassPropertiesFalsePublic
SoftwareAdminSettingsDimSoftwareAdminSettingsDimProvance.ITAM.SoftwareAdminSettingsTrueIncludeExtendedClassPropertiesFalsePublic
SoftwareAllocationDimSoftwareAllocationDimProvance.ITAM.AllocationTrueIncludeExtendedClassPropertiesFalsePublic
SoftwareAllocationSetDimSoftwareAllocationSetDimProvance.ITAM.AllocationSetTrueIncludeExtendedClassPropertiesFalsePublic
SoftwareAssignmentDimSoftwareAssignmentDimProvance.ITAM.AssignmentTrueIncludeExtendedClassPropertiesFalsePublic
SoftwareAssignmentSetDimSoftwareAssignmentSetDimProvance.ITAM.AssignmentSetTrueIncludeExtendedClassPropertiesFalsePublic
SoftwareItemDimSoftwareItemDimSystem.SoftwareItemTrueIncludeExtendedClassPropertiesFalsePublic
SoftwareLicenseDimSoftwareLicenseDimProvance.ITAM.SoftwareLicenseTrueIncludeExtendedClassPropertiesFalsePublic
SoftwareLicenseKeyDimSoftwareLicenseKeyDimProvance.ITAM.SoftwareLicenseKeyTrueIncludeExtendedClassPropertiesFalsePublic
SoftwareTitleDimSoftwareTitleDimProvance.ITAM.SoftwareTitleTrueIncludeExtendedClassPropertiesFalsePublic
SoftwareVersionDimSoftwareVersionDimProvance.ITAM.SoftwareVersionTrueIncludeExtendedClassPropertiesFalsePublic
SWLicenseAgtDimSWLicenseAgtDimProvance.ITAM.SoftwareLicenseAgreementTrueIncludeExtendedClassPropertiesFalsePublic
SWMaintAgtDimSWMaintAgtDimProvance.ITAM.SoftwareMaintenanceAgreementTrueIncludeExtendedClassPropertiesFalsePublic

Outriggers (8)

 IDAccessibility
ApprovalStatusApprovalStatusPublic
LicensePricingLicensePricingPublic
LicenseTypeLicenseTypePublic
LicenseUnitLicenseUnitPublic
LicensingProgramLicensingProgramPublic
OwnerTypeOwnerTypePublic
SoftwareAllocationTypeSoftwareAllocationTypePublic
SoftwareCategorySoftwareCategoryPublic

Relationship Facts (31)

 IDDomainTime GrainSource TypeSource DimensionAccessibility
DeviceInstalledSoftwareItemFactDeviceInstalledSoftwareItemFactDomain.ITAssetManagementDailyMicrosoft.Windows.ComputerComputerDimPublic
ExcludedSoftwareItemGroupSoftwareItemFactExcludedSoftwareItemGroupSoftwareItemFactDomain.ITAssetManagementDailyProvance.ITAM.ExcludedSoftwareItemGroupExcludedSoftwareItemGroupDimPublic
LicenseSWMaintAgtFactLicenseSWMaintAgtFactDomain.ITAssetManagementDailyProvance.ITAM.SoftwareLicenseSoftwareLicenseDimPublic
PublisherSoftwareTitleFactPublisherSoftwareTitleFactDomain.ITAssetManagementDailyProvance.ITAM.CompanyCompanyDimPublic
SkuHasDowngradeSoftwareVersionsFactSkuHasDowngradeSoftwareVersionsFactDomain.ITAssetManagementDailyProvance.ITAM.SkuSkuDimPublic
SkuHasUpgradeSoftwareVersionsFactSkuHasUpgradeSoftwareVersionsFactDomain.ITAssetManagementDailyProvance.ITAM.SkuSkuDimPublic
SkuPublisherFactSkuPublisherFactDomain.ITAssetManagementDailyProvance.ITAM.SkuSkuDimPublic
SkuSoftwareTitleFactSkuSoftwareTitleFactDomain.ITAssetManagementDailyProvance.ITAM.SkuSkuDimPublic
SkuSoftwareVersionFactSkuSoftwareVersionFactDomain.ITAssetManagementDailyProvance.ITAM.SkuSkuDimPublic
SoftwareAllocationConfigItemTargetFactSoftwareAllocationConfigItemTargetFactDomain.ITAssetManagementDailyProvance.ITAM.AllocationSoftwareAllocationDimPublic
SoftwareAllocationSetAllocationFactSoftwareAllocationSetAllocationFactDomain.ITAssetManagementDailyProvance.ITAM.AllocationSetSoftwareAllocationSetDimPublic
SoftwareAssignmentConfigItemTargetFactSoftwareAssignmentConfigItemTargetFactDomain.ITAssetManagementDailyProvance.ITAM.AssignmentSoftwareAssignmentDimPublic
SoftwareAssignmentLicenseKeyFactSoftwareAssignmentLicenseKeyFactDomain.ITAssetManagementDailyProvance.ITAM.AssignmentSoftwareAssignmentDimPublic
SoftwareAssignmentSetAssignmentFactSoftwareAssignmentSetAssignmentFactDomain.ITAssetManagementDailyProvance.ITAM.AssignmentSetSoftwareAssignmentSetDimPublic
SoftwareAssignmentSoftwareLicenseFactSoftwareAssignmentSoftwareLicenseFactDomain.ITAssetManagementDailyProvance.ITAM.AssignmentSoftwareAssignmentDimPublic
SoftwareCostCenterFactSoftwareCostCenterFactDomain.ITAssetManagementDailyProvance.ITAM.SoftwareLicenseSoftwareLicenseDimPublic
SoftwareLicenseSkuFactSoftwareLicenseSkuFactDomain.ITAssetManagementDailyProvance.ITAM.SoftwareLicenseSoftwareLicenseDimPublic
SoftwareLicenseSoftwareLicenseKeyFactSoftwareLicenseSoftwareLicenseKeyFactDomain.ITAssetManagementDailyProvance.ITAM.SoftwareLicenseSoftwareLicenseDimPublic
SoftwareLocationFactSoftwareLocationFactDomain.ITAssetManagementDailyProvance.ITAM.SoftwareLicenseSoftwareLicenseDimPublic
SoftwareOrganizationFactSoftwareOrganizationFactDomain.ITAssetManagementDailyProvance.ITAM.SoftwareLicenseSoftwareLicenseDimPublic
SoftwareSupplierFactSoftwareSupplierFactDomain.ITAssetManagementDailyProvance.ITAM.SoftwareLicenseSoftwareLicenseDimPublic
SoftwareTitleAllocationSetFactSoftwareTitleAllocationSetFactDomain.ITAssetManagementDailyProvance.ITAM.SoftwareTitleSoftwareTitleDimPublic
SoftwareTitleAssignmentSetFactSoftwareTitleAssignmentSetFactDomain.ITAssetManagementDailyProvance.ITAM.SoftwareTitleSoftwareTitleDimPublic
SoftwareTitleHasOwnersFactSoftwareTitleHasOwnersFactDomain.ITAssetManagementDailyProvance.ITAM.SoftwareTitleSoftwareTitleDimPublic
SoftwareTitleVersionFactSoftwareTitleVersionFactDomain.ITAssetManagementDailyProvance.ITAM.SoftwareTitleSoftwareTitleDimPublic
SWAgreementContactFactSWAgreementContactFactDomain.ITAssetManagementDailyProvance.ITAM.SoftwareLicenseAgreementSWLicenseAgtDimPublic
SWAgreementLicenseFactSWAgreementLicenseFactDomain.ITAssetManagementDailyProvance.ITAM.SoftwareLicenseSoftwareLicenseDimPublic
SWLicenseAgtPublisherFactSWLicenseAgtPublisherFactDomain.ITAssetManagementDailyProvance.ITAM.SoftwareLicenseAgreementSWLicenseAgtDimPublic
SWMaintAgtContactFactSWMaintAgtContactFactDomain.ITAssetManagementDailyProvance.ITAM.SoftwareMaintenanceAgreementSWMaintAgtDimPublic
SWMaintAgtPublisherFactSWMaintAgtPublisherFactDomain.ITAssetManagementDailyProvance.ITAM.SoftwareMaintenanceAgreementSWMaintAgtDimPublic
VersionDiscoveredItemFactVersionDiscoveredItemFactDomain.ITAssetManagementDailyProvance.ITAM.SoftwareVersionSoftwareVersionDimPublic

Warehouse Modules (1)

 IDETL ModuleWarehouse Module TypeTarget Warehouse EntityAccessibility
TransformSoftwareTitleHasOwnersFactTransformSoftwareTitleHasOwnersFactTransformSoftwareTitleHasOwnersFactProcTransformSoftwareTitleHasOwnersFactPublic