Provance ITAM Core Datawarehouse Library

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

Management Pack Elements

Enumerations (1)

 DisplayNameIDParentAccessibility
Domain.ITAssetManagement[Domain.ITAssetManagement]Domain.ITAssetManagementDomainPublic

Resources (4)

 IDFile NameAccessibility
CommonFuncGetComputerTypeIdResourceCommonFuncGetComputerTypeIdResourceCommonFuncGetComputerTypeId.sqlPublic
TransformAgreementExtensionDimProcResourceTransformAgreementExtensionDimProcResourceTransformAgreementExtensionDimProc.sqlPublic
UninstallGetComputerTypeIdFuncResourceUninstallGetComputerTypeIdFuncResourceUninstallGetComputerTypeIdFunc.sqlPublic
UninstallTransformAgreementExtensionDimProcResourceUninstallTransformAgreementExtensionDimProcResourceUninstallTransformAgreementExtensionDimProc.sqlPublic

Data Warehouse Scripts (2)

 IDInstall ScriptUninstall ScriptUpgrade ScriptUpgrade UnsupportedAccessibility
CommonFunGetComputerTypeIdScriptCommonFunGetComputerTypeIdScriptCommonFuncGetComputerTypeIdResourceUninstallGetComputerTypeIdFuncResourceFalsePublic
TransformAgreementExtensionDimProcTransformAgreementExtensionDimProcTransformAgreementExtensionDimProcResourceUninstallTransformAgreementExtensionDimProcResourceTransformAgreementExtensionDimProcResourceFalsePublic

Dimensions (27)

 IDTargetInferred DimensionHierarchy SupportReconcileAccessibility
AgreementCostEventDimAgreementCostEventDimProvance.ITAM.AgreementCostEventTrueIncludeExtendedClassPropertiesFalsePublic
AgreementDimAgreementDimProvance.ITAM.AgreementTrueIncludeExtendedClassPropertiesFalsePublic
AgreementExtensionDimAgreementExtensionDimProvance.ITAM.AgreementExtensionTrueIncludeExtendedClassPropertiesFalsePublic
BaseCurrencyDimBaseCurrencyDimProvance.ITAM.BaseCurrencyTrueIncludeExtendedClassPropertiesFalsePublic
CompanyDimCompanyDimProvance.ITAM.CompanyTrueIncludeExtendedClassPropertiesFalsePublic
ContactDimContactDimProvance.ITAM.ContactTrueIncludeExtendedClassPropertiesFalsePublic
ContractAdminSettingsDimContractAdminSettingsDimProvance.ITAM.ContractAdminSettingsTrueIncludeExtendedClassPropertiesFalsePublic
ContractDimContractDimProvance.ITAM.ContractTrueIncludeExtendedClassPropertiesFalsePublic
CostCenterDimCostCenterDimProvance.ITAM.CostCenterTrueIncludeExtendedClassPropertiesFalsePublic
CostEventDimCostEventDimProvance.ITAM.CostEventTrueIncludeExtendedClassPropertiesFalsePublic
CurrencyDimCurrencyDimProvance.ITAM.CurrencyTrueIncludeExtendedClassPropertiesFalsePublic
DisposalAgreementDimDisposalAgreementDimProvance.ITAM.DisposalAgreementTrueIncludeExtendedClassPropertiesFalsePublic
DisposalContractDimDisposalContractDimProvance.ITAM.DisposalContractTrueIncludeExtendedClassPropertiesFalsePublic
GlobalAdministrationSettingsDimGlobalAdministrationSettingsDimProvance.ITAM.GlobalAdministrationSettingsTrueIncludeExtendedClassPropertiesFalsePublic
LeaseAgreementDimLeaseAgreementDimProvance.ITAM.LeaseAgreementTrueIncludeExtendedClassPropertiesFalsePublic
LeaseContractDimLeaseContractDimProvance.ITAM.LeaseContractTrueIncludeExtendedClassPropertiesFalsePublic
LocationDimLocationDimProvance.ITAM.LocationTrueIncludeExtendedClassPropertiesFalsePublic
MilestoneDimMilestoneDimProvance.ITAM.MilestoneTrueIncludeExtendedClassPropertiesFalsePublic
OrganizationDimOrganizationDimProvance.ITAM.OrganizationTrueIncludeExtendedClassPropertiesFalsePublic
SupportAgreementDimSupportAgreementDimProvance.ITAM.SupportAgreementTrueIncludeExtendedClassPropertiesFalsePublic
SupportContractDimSupportContractDimProvance.ITAM.SupportContractTrueIncludeExtendedClassPropertiesFalsePublic
SysPrinterDimSysPrinterDimMicrosoft.AD.PrinterTrueExactFalsePublic
SystemUserDimSystemUserDimSystem.UserTrueIncludeExtendedClassPropertiesFalsePublic
URIAttachmentDimURIAttachmentDimProvance.ITAM.URIAttachmentTrueIncludeExtendedClassPropertiesFalsePublic
UserDefinedAgreementDimUserDefinedAgreementDimProvance.ITAM.UserDefinedAgreementTrueIncludeExtendedClassPropertiesFalsePublic
WarrantyAgreementDimWarrantyAgreementDimProvance.ITAM.WarrantyAgreementTrueIncludeExtendedClassPropertiesFalsePublic
WarrantyContractDimWarrantyContractDimProvance.ITAM.WarrantyContractTrueIncludeExtendedClassPropertiesFalsePublic

Outriggers (13)

 IDAccessibility
AgreementCostEventTypeAgreementCostEventTypePublic
AgreementLifeCycleStatusAgreementLifeCycleStatusPublic
AgreementTypeAgreementTypePublic
ContractTimeFrequencyContractTimeFrequencyPublic
ContractTimeUnitContractTimeUnitPublic
ContractTransferabilityContractTransferabilityPublic
CostEventTypeCostEventTypePublic
EntityStatusEntityStatusPublic
LocationTypeLocationTypePublic
MilestoneTypeMilestoneTypePublic
OrganizationTypeOrganizationTypePublic
URIAttachmentTypeURIAttachmentTypePublic
UserDefinedAgreementTypeUserDefinedAgreementTypePublic

Relationship Facts (35)

 IDDomainTime GrainSource TypeSource DimensionAccessibility
AgreementChildAgreementFactAgreementChildAgreementFactDomain.ITAssetManagementDailyProvance.ITAM.AgreementAgreementDimPublic
AgreementCompanyFactAgreementCompanyFactDomain.ITAssetManagementDailyProvance.ITAM.AgreementAgreementDimPublic
AgreementContractFactAgreementContractFactDomain.ITAssetManagementDailyProvance.ITAM.AgreementAgreementDimPublic
AgreementCostCenterFactAgreementCostCenterFactDomain.ITAssetManagementDailyProvance.ITAM.AgreementAgreementDimPublic
AgreementCostEventMilestoneFactAgreementCostEventMilestoneFactDomain.ITAssetManagementDailyProvance.ITAM.AgreementCostEventAgreementCostEventDimPublic
AgreementLocationFactAgreementLocationFactDomain.ITAssetManagementDailyProvance.ITAM.AgreementAgreementDimPublic
AgreementOrganizationFactAgreementOrganizationFactDomain.ITAssetManagementDailyProvance.ITAM.AgreementAgreementDimPublic
AgreementSystemUserFactAgreementSystemUserFactDomain.ITAssetManagementDailyProvance.ITAM.AgreementAgreementDimPublic
CompanyContactFactCompanyContactFactDomain.ITAssetManagementDailyProvance.ITAM.CompanyCompanyDimPublic
ConfigItemCostEventFactConfigItemCostEventFactDomain.ITAssetManagementDailySystem.ConfigItemConfigItemDimPublic
ConfigItemMilestoneFactConfigItemMilestoneFactDomain.ITAssetManagementDailySystem.ConfigItemConfigItemDimPublic
ConfigItemURIAttachmentFactConfigItemURIAttachmentFactDomain.ITAssetManagementDailySystem.ConfigItemConfigItemDimPublic
ContactSystemUserFactContactSystemUserFactDomain.ITAssetManagementDailyProvance.ITAM.ContactContactDimPublic
ContractContactFactContractContactFactDomain.ITAssetManagementDailyProvance.ITAM.ContractContractDimPublic
CostCenterChildCostCenterFactCostCenterChildCostCenterFactDomain.ITAssetManagementDailyProvance.ITAM.CostCenterCostCenterDimPublic
CostCenterContactFactCostCenterContactFactDomain.ITAssetManagementDailyProvance.ITAM.CostCenterCostCenterDimPublic
CostEventChangeFactCostEventChangeFactDomain.ITAssetManagementDailyProvance.ITAM.CostEventCostEventDimPublic
CostEventCostCenterFactCostEventCostCenterFactDomain.ITAssetManagementDailyProvance.ITAM.CostEventCostEventDimPublic
CostEventIncidentFactCostEventIncidentFactDomain.ITAssetManagementDailyProvance.ITAM.CostEventCostEventDimPublic
CostEventLocationFactCostEventLocationFactDomain.ITAssetManagementDailyProvance.ITAM.CostEventCostEventDimPublic
CostEventOrganizationFactCostEventOrganizationFactDomain.ITAssetManagementDailyProvance.ITAM.CostEventCostEventDimPublic
CostEventSupplierFactCostEventSupplierFactDomain.ITAssetManagementDailyProvance.ITAM.CostEventCostEventDimPublic
CostEventUserFactCostEventUserFactDomain.ITAssetManagementDailyProvance.ITAM.CostEventCostEventDimPublic
DisposalAgreementContractFactDisposalAgreementContractFactDomain.ITAssetManagementDailyProvance.ITAM.DisposalAgreementDisposalAgreementDimPublic
LeaseAgreementContactFactLeaseAgreementContactFactDomain.ITAssetManagementDailyProvance.ITAM.LeaseAgreementLeaseAgreementDimPublic
LeaseAgreementContractFactLeaseAgreementContractFactDomain.ITAssetManagementDailyProvance.ITAM.LeaseAgreementLeaseAgreementDimPublic
LocationChildLocationFactLocationChildLocationFactDomain.ITAssetManagementDailyProvance.ITAM.LocationLocationDimPublic
LocationContactFactLocationContactFactDomain.ITAssetManagementDailyProvance.ITAM.LocationLocationDimPublic
OrganizationChildOrganizationFactOrganizationChildOrganizationFactDomain.ITAssetManagementDailyProvance.ITAM.OrganizationOrganizationDimPublic
OrganizationContactFactOrganizationContactFactDomain.ITAssetManagementDailyProvance.ITAM.OrganizationOrganizationDimPublic
SupportAgreementContractFactSupportAgreementContractFactDomain.ITAssetManagementDailyProvance.ITAM.SupportAgreementSupportAgreementDimPublic
UserDefinedAgreementAgreementFactUserDefinedAgreementAgreementFactDomain.ITAssetManagementDailyProvance.ITAM.UserDefinedAgreementUserDefinedAgreementDimPublic
UserDefinedAgreementContactFactUserDefinedAgreementContactFactDomain.ITAssetManagementDailyProvance.ITAM.UserDefinedAgreementUserDefinedAgreementDimPublic
WarrantyAgreementContactFactWarrantyAgreementContactFactDomain.ITAssetManagementDailyProvance.ITAM.WarrantyAgreementWarrantyAgreementDimPublic
WarrantyAgreementContractFactWarrantyAgreementContractFactDomain.ITAssetManagementDailyProvance.ITAM.WarrantyAgreementWarrantyAgreementDimPublic

Warehouse Modules (1)

 IDETL ModuleWarehouse Module TypeTarget Warehouse EntityAccessibility
TransformAgreementExtensionDimTransformAgreementExtensionDimTransformAgreementExtensionDimProcTransformAgreementExtensionDimPublic