Библиотека Provance ITAM Hardware Datawarehouse Library

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

Management Pack Elements

Resources (2)

 IDFile NameAccessibility
TransformHardwareAssetLifecycleStatusDurationFactResourceTransformHardwareAssetLifecycleStatusDurationFactResourceTransformHardwareAssetLifecycleStatusDurationFact.sqlPublic
UninstallHardwareAssetLifecycleStatusDurationFactResourceUninstallHardwareAssetLifecycleStatusDurationFactResourceUninstallHardwareAssetLifecycleStatusDurationFact.sqlPublic

Data Warehouse Scripts (1)

 IDInstall ScriptUninstall ScriptUpgrade ScriptUpgrade UnsupportedAccessibility
TransformHardwareAssetLifecycleStatusDurationFactProcTransformHardwareAssetLifecycleStatusDurationFactProcTransformHardwareAssetLifecycleStatusDurationFactResourceUninstallHardwareAssetLifecycleStatusDurationFactResourceTransformHardwareAssetLifecycleStatusDurationFactResourceFalsePublic

Dimensions (3)

 IDTargetInferred DimensionHierarchy SupportReconcileAccessibility
HardwareAssetDimHardwareAssetDimProvance.ITAM.HardwareAssetTrueIncludeExtendedClassPropertiesFalsePublic
HardwareCatalogDimHardwareCatalogDimProvance.ITAM.HardwareCatalogItemTrueIncludeExtendedClassPropertiesFalsePublic
HWDisposalDimHWDisposalDimProvance.ITAM.HardwareAssetDisposalTrueIncludeExtendedClassPropertiesFalsePublic

Outriggers (3)

 IDAccessibility
HardwareAssetDisposalReasonHardwareAssetDisposalReasonPublic
HardwareAssetLifecycleStatusHardwareAssetLifecycleStatusPublic
HardwareAssetTypeHardwareAssetTypePublic

Measures (1)

 IDAggregationAccessibility
LifecycleStatusDurationMeasureLifecycleStatusDurationMeasureAdditivePublic

Relationship Facts (16)

 IDDomainTime GrainSource TypeSource DimensionAccessibility
DispoalAssetContractFactDispoalAssetContractFactDomain.ITAssetManagementDailyProvance.ITAM.HardwareAssetDisposalHWDisposalDimPublic
HardwareAssetChildHardwareAssetFactHardwareAssetChildHardwareAssetFactDomain.ITAssetManagementDailyProvance.ITAM.HardwareAssetHardwareAssetDimPublic
HardwareAssetCIFactHardwareAssetCIFactDomain.ITAssetManagementDailyProvance.ITAM.HardwareAssetHardwareAssetDimPublic
HardwareAssetComputerFactHardwareAssetComputerFactDomain.ITAssetManagementDailyProvance.ITAM.HardwareAssetHardwareAssetDimPublic
HardwareAssetCostCenterFactHardwareAssetCostCenterFactDomain.ITAssetManagementDailyProvance.ITAM.HardwareAssetHardwareAssetDimPublic
HardwareAssetDispoalAssetFactHardwareAssetDispoalAssetFactDomain.ITAssetManagementDailyProvance.ITAM.HardwareAssetHardwareAssetDimPublic
HardwareAssetHardwareCatalogItemFactHardwareAssetHardwareCatalogItemFactDomain.ITAssetManagementDailyProvance.ITAM.HardwareAssetHardwareAssetDimPublic
HardwareAssetLeaseContractFactHardwareAssetLeaseContractFactDomain.ITAssetManagementDailyProvance.ITAM.HardwareAssetHardwareAssetDimPublic
HardwareAssetLocationFactHardwareAssetLocationFactDomain.ITAssetManagementDailyProvance.ITAM.HardwareAssetHardwareAssetDimPublic
HardwareAssetOrganizationFactHardwareAssetOrganizationFactDomain.ITAssetManagementDailyProvance.ITAM.HardwareAssetHardwareAssetDimPublic
HardwareAssetOwnerFactHardwareAssetOwnerFactDomain.ITAssetManagementDailyProvance.ITAM.HardwareAssetHardwareAssetDimPublic
HardwareAssetSupplierFactHardwareAssetSupplierFactDomain.ITAssetManagementDailyProvance.ITAM.HardwareAssetHardwareAssetDimPublic
HardwareAssetSupportContractFactHardwareAssetSupportContractFactDomain.ITAssetManagementDailyProvance.ITAM.HardwareAssetHardwareAssetDimPublic
HardwareAssetWarrantyContractFactHardwareAssetWarrantyContractFactDomain.ITAssetManagementDailyProvance.ITAM.HardwareAssetHardwareAssetDimPublic
HardwareCatalogItemManufacturerFactHardwareCatalogItemManufacturerFactDomain.ITAssetManagementDailyProvance.ITAM.HardwareCatalogItemHardwareCatalogDimPublic
HardwareCatalogItemSupplierFactHardwareCatalogItemSupplierFactDomain.ITAssetManagementDailyProvance.ITAM.HardwareCatalogItemHardwareCatalogDimPublic

Facts (1)

 IDDomainTime GrainAccessibility
HardwareAssetLifecycleStatusDurationFactHardwareAssetLifecycleStatusDurationFactDomain.ITAssetManagementDailyPublic

Warehouse Modules (1)

 IDETL ModuleWarehouse Module TypeTarget Warehouse EntityAccessibility
TransformHardwareAssetLifecycleStatusDurationFactTransformHardwareAssetLifecycleStatusDurationFactTransformHardwareAssetLifecycleStatusDurationFactProcTransformHardwareAssetLifecycleStatusDurationFactPublic