Provance ITAM Hardware Datawarehouse Library

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

Management Pack Elements

Show Management Pack References

Resources

Resource (2)

Reporting

DataWarehouseScript (1)

Warehouse

Dimension (3)
Outrigger (3)
Measure (1)
RelationshipFact (16)
Fact (1)
WarehouseModule (1)

Resources (2)

	ID	File Name	Accessibility
	TransformHardwareAssetLifecycleStatusDurationFactResource	TransformHardwareAssetLifecycleStatusDurationFact.sql	Public
	UninstallHardwareAssetLifecycleStatusDurationFactResource	UninstallHardwareAssetLifecycleStatusDurationFact.sql	Public

Data Warehouse Scripts (1)

	ID	Install Script	Uninstall Script	Upgrade Script	Upgrade Unsupported	Accessibility
	TransformHardwareAssetLifecycleStatusDurationFactProc	TransformHardwareAssetLifecycleStatusDurationFactResource	UninstallHardwareAssetLifecycleStatusDurationFactResource	TransformHardwareAssetLifecycleStatusDurationFactResource	False	Public

Dimensions (3)

	ID	Target	Inferred Dimension	Hierarchy Support	Reconcile	Accessibility
	HardwareAssetDim	Provance.ITAM.HardwareAsset	True	IncludeExtendedClassProperties	False	Public
	HardwareCatalogDim	Provance.ITAM.HardwareCatalogItem	True	IncludeExtendedClassProperties	False	Public
	HWDisposalDim	Provance.ITAM.HardwareAssetDisposal	True	IncludeExtendedClassProperties	False	Public

Outriggers (3)

	ID	Accessibility
	HardwareAssetDisposalReason	Public
	HardwareAssetLifecycleStatus	Public
	HardwareAssetType	Public

Measures (1)

	ID	Aggregation	Accessibility
	LifecycleStatusDurationMeasure	Additive	Public

Relationship Facts (16)

	ID	Domain	Time Grain	Source Type	Source Dimension	Accessibility
	DispoalAssetContractFact	Domain.ITAssetManagement	Daily	Provance.ITAM.HardwareAssetDisposal	HWDisposalDim	Public
	HardwareAssetChildHardwareAssetFact	Domain.ITAssetManagement	Daily	Provance.ITAM.HardwareAsset	HardwareAssetDim	Public
	HardwareAssetCIFact	Domain.ITAssetManagement	Daily	Provance.ITAM.HardwareAsset	HardwareAssetDim	Public
	HardwareAssetComputerFact	Domain.ITAssetManagement	Daily	Provance.ITAM.HardwareAsset	HardwareAssetDim	Public
	HardwareAssetCostCenterFact	Domain.ITAssetManagement	Daily	Provance.ITAM.HardwareAsset	HardwareAssetDim	Public
	HardwareAssetDispoalAssetFact	Domain.ITAssetManagement	Daily	Provance.ITAM.HardwareAsset	HardwareAssetDim	Public
	HardwareAssetHardwareCatalogItemFact	Domain.ITAssetManagement	Daily	Provance.ITAM.HardwareAsset	HardwareAssetDim	Public
	HardwareAssetLeaseContractFact	Domain.ITAssetManagement	Daily	Provance.ITAM.HardwareAsset	HardwareAssetDim	Public
	HardwareAssetLocationFact	Domain.ITAssetManagement	Daily	Provance.ITAM.HardwareAsset	HardwareAssetDim	Public
	HardwareAssetOrganizationFact	Domain.ITAssetManagement	Daily	Provance.ITAM.HardwareAsset	HardwareAssetDim	Public
	HardwareAssetOwnerFact	Domain.ITAssetManagement	Daily	Provance.ITAM.HardwareAsset	HardwareAssetDim	Public
	HardwareAssetSupplierFact	Domain.ITAssetManagement	Daily	Provance.ITAM.HardwareAsset	HardwareAssetDim	Public
	HardwareAssetSupportContractFact	Domain.ITAssetManagement	Daily	Provance.ITAM.HardwareAsset	HardwareAssetDim	Public
	HardwareAssetWarrantyContractFact	Domain.ITAssetManagement	Daily	Provance.ITAM.HardwareAsset	HardwareAssetDim	Public
	HardwareCatalogItemManufacturerFact	Domain.ITAssetManagement	Daily	Provance.ITAM.HardwareCatalogItem	HardwareCatalogDim	Public
	HardwareCatalogItemSupplierFact	Domain.ITAssetManagement	Daily	Provance.ITAM.HardwareCatalogItem	HardwareCatalogDim	Public

Facts (1)

	ID	Domain	Time Grain	Accessibility
	HardwareAssetLifecycleStatusDurationFact	Domain.ITAssetManagement	Daily	Public

Warehouse Modules (1)

	ID	ETL Module	Warehouse Module Type	Target Warehouse Entity	Accessibility
	TransformHardwareAssetLifecycleStatusDurationFact	TransformHardwareAssetLifecycleStatusDurationFactProc	Transform	HardwareAssetLifecycleStatusDurationFact	Public