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

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

Management Pack Elements

Show Management Pack References

TypeDefinitions

EntityTypes

EnumerationValue (1)

Resources

Resource (4)

Reporting

DataWarehouseScript (2)

Warehouse

Dimension (27)
Outrigger (13)
RelationshipFact (35)
WarehouseModule (1)

Enumerations (1)

	DisplayName	ID	Parent	Accessibility
	[Domain.ITAssetManagement]	Domain.ITAssetManagement	Domain	Public

Resources (4)

ID	File Name	Accessibility
CommonFuncGetComputerTypeIdResource	CommonFuncGetComputerTypeId.sql	Public
TransformAgreementExtensionDimProcResource	TransformAgreementExtensionDimProc.sql	Public
UninstallGetComputerTypeIdFuncResource	UninstallGetComputerTypeIdFunc.sql	Public
UninstallTransformAgreementExtensionDimProcResource	UninstallTransformAgreementExtensionDimProc.sql	Public

Data Warehouse Scripts (2)

	ID	Install Script	Uninstall Script	Upgrade Script	Upgrade Unsupported	Accessibility
	CommonFunGetComputerTypeIdScript	CommonFuncGetComputerTypeIdResource	UninstallGetComputerTypeIdFuncResource		False	Public
	TransformAgreementExtensionDimProc	TransformAgreementExtensionDimProcResource	UninstallTransformAgreementExtensionDimProcResource	TransformAgreementExtensionDimProcResource	False	Public

Dimensions (27)

ID	Target	Inferred Dimension	Hierarchy Support	Reconcile	Accessibility
AgreementCostEventDim	Provance.ITAM.AgreementCostEvent	True	IncludeExtendedClassProperties	False	Public
AgreementDim	Provance.ITAM.Agreement	True	IncludeExtendedClassProperties	False	Public
AgreementExtensionDim	Provance.ITAM.AgreementExtension	True	IncludeExtendedClassProperties	False	Public
BaseCurrencyDim	Provance.ITAM.BaseCurrency	True	IncludeExtendedClassProperties	False	Public
CompanyDim	Provance.ITAM.Company	True	IncludeExtendedClassProperties	False	Public
ContactDim	Provance.ITAM.Contact	True	IncludeExtendedClassProperties	False	Public
ContractAdminSettingsDim	Provance.ITAM.ContractAdminSettings	True	IncludeExtendedClassProperties	False	Public
ContractDim	Provance.ITAM.Contract	True	IncludeExtendedClassProperties	False	Public
CostCenterDim	Provance.ITAM.CostCenter	True	IncludeExtendedClassProperties	False	Public
CostEventDim	Provance.ITAM.CostEvent	True	IncludeExtendedClassProperties	False	Public
CurrencyDim	Provance.ITAM.Currency	True	IncludeExtendedClassProperties	False	Public
DisposalAgreementDim	Provance.ITAM.DisposalAgreement	True	IncludeExtendedClassProperties	False	Public
DisposalContractDim	Provance.ITAM.DisposalContract	True	IncludeExtendedClassProperties	False	Public
GlobalAdministrationSettingsDim	Provance.ITAM.GlobalAdministrationSettings	True	IncludeExtendedClassProperties	False	Public
LeaseAgreementDim	Provance.ITAM.LeaseAgreement	True	IncludeExtendedClassProperties	False	Public
LeaseContractDim	Provance.ITAM.LeaseContract	True	IncludeExtendedClassProperties	False	Public
LocationDim	Provance.ITAM.Location	True	IncludeExtendedClassProperties	False	Public
MilestoneDim	Provance.ITAM.Milestone	True	IncludeExtendedClassProperties	False	Public
OrganizationDim	Provance.ITAM.Organization	True	IncludeExtendedClassProperties	False	Public
SupportAgreementDim	Provance.ITAM.SupportAgreement	True	IncludeExtendedClassProperties	False	Public
SupportContractDim	Provance.ITAM.SupportContract	True	IncludeExtendedClassProperties	False	Public
SysPrinterDim	Microsoft.AD.Printer	True	Exact	False	Public
SystemUserDim	System.User	True	IncludeExtendedClassProperties	False	Public
URIAttachmentDim	Provance.ITAM.URIAttachment	True	IncludeExtendedClassProperties	False	Public
UserDefinedAgreementDim	Provance.ITAM.UserDefinedAgreement	True	IncludeExtendedClassProperties	False	Public
WarrantyAgreementDim	Provance.ITAM.WarrantyAgreement	True	IncludeExtendedClassProperties	False	Public
WarrantyContractDim	Provance.ITAM.WarrantyContract	True	IncludeExtendedClassProperties	False	Public

Outriggers (13)

	ID	Accessibility
	AgreementCostEventType	Public
	AgreementLifeCycleStatus	Public
	AgreementType	Public
	ContractTimeFrequency	Public
	ContractTimeUnit	Public
	ContractTransferability	Public
	CostEventType	Public
	EntityStatus	Public
	LocationType	Public
	MilestoneType	Public
	OrganizationType	Public
	URIAttachmentType	Public
	UserDefinedAgreementType	Public

Relationship Facts (35)

ID	Domain	Time Grain	Source Type	Source Dimension	Accessibility
AgreementChildAgreementFact	Domain.ITAssetManagement	Daily	Provance.ITAM.Agreement	AgreementDim	Public
AgreementCompanyFact	Domain.ITAssetManagement	Daily	Provance.ITAM.Agreement	AgreementDim	Public
AgreementContractFact	Domain.ITAssetManagement	Daily	Provance.ITAM.Agreement	AgreementDim	Public
AgreementCostCenterFact	Domain.ITAssetManagement	Daily	Provance.ITAM.Agreement	AgreementDim	Public
AgreementCostEventMilestoneFact	Domain.ITAssetManagement	Daily	Provance.ITAM.AgreementCostEvent	AgreementCostEventDim	Public
AgreementLocationFact	Domain.ITAssetManagement	Daily	Provance.ITAM.Agreement	AgreementDim	Public
AgreementOrganizationFact	Domain.ITAssetManagement	Daily	Provance.ITAM.Agreement	AgreementDim	Public
AgreementSystemUserFact	Domain.ITAssetManagement	Daily	Provance.ITAM.Agreement	AgreementDim	Public
CompanyContactFact	Domain.ITAssetManagement	Daily	Provance.ITAM.Company	CompanyDim	Public
ConfigItemCostEventFact	Domain.ITAssetManagement	Daily	System.ConfigItem	ConfigItemDim	Public
ConfigItemMilestoneFact	Domain.ITAssetManagement	Daily	System.ConfigItem	ConfigItemDim	Public
ConfigItemURIAttachmentFact	Domain.ITAssetManagement	Daily	System.ConfigItem	ConfigItemDim	Public
ContactSystemUserFact	Domain.ITAssetManagement	Daily	Provance.ITAM.Contact	ContactDim	Public
ContractContactFact	Domain.ITAssetManagement	Daily	Provance.ITAM.Contract	ContractDim	Public
CostCenterChildCostCenterFact	Domain.ITAssetManagement	Daily	Provance.ITAM.CostCenter	CostCenterDim	Public
CostCenterContactFact	Domain.ITAssetManagement	Daily	Provance.ITAM.CostCenter	CostCenterDim	Public
CostEventChangeFact	Domain.ITAssetManagement	Daily	Provance.ITAM.CostEvent	CostEventDim	Public
CostEventCostCenterFact	Domain.ITAssetManagement	Daily	Provance.ITAM.CostEvent	CostEventDim	Public
CostEventIncidentFact	Domain.ITAssetManagement	Daily	Provance.ITAM.CostEvent	CostEventDim	Public
CostEventLocationFact	Domain.ITAssetManagement	Daily	Provance.ITAM.CostEvent	CostEventDim	Public
CostEventOrganizationFact	Domain.ITAssetManagement	Daily	Provance.ITAM.CostEvent	CostEventDim	Public
CostEventSupplierFact	Domain.ITAssetManagement	Daily	Provance.ITAM.CostEvent	CostEventDim	Public
CostEventUserFact	Domain.ITAssetManagement	Daily	Provance.ITAM.CostEvent	CostEventDim	Public
DisposalAgreementContractFact	Domain.ITAssetManagement	Daily	Provance.ITAM.DisposalAgreement	DisposalAgreementDim	Public
LeaseAgreementContactFact	Domain.ITAssetManagement	Daily	Provance.ITAM.LeaseAgreement	LeaseAgreementDim	Public
LeaseAgreementContractFact	Domain.ITAssetManagement	Daily	Provance.ITAM.LeaseAgreement	LeaseAgreementDim	Public
LocationChildLocationFact	Domain.ITAssetManagement	Daily	Provance.ITAM.Location	LocationDim	Public
LocationContactFact	Domain.ITAssetManagement	Daily	Provance.ITAM.Location	LocationDim	Public
OrganizationChildOrganizationFact	Domain.ITAssetManagement	Daily	Provance.ITAM.Organization	OrganizationDim	Public
OrganizationContactFact	Domain.ITAssetManagement	Daily	Provance.ITAM.Organization	OrganizationDim	Public
SupportAgreementContractFact	Domain.ITAssetManagement	Daily	Provance.ITAM.SupportAgreement	SupportAgreementDim	Public
UserDefinedAgreementAgreementFact	Domain.ITAssetManagement	Daily	Provance.ITAM.UserDefinedAgreement	UserDefinedAgreementDim	Public
UserDefinedAgreementContactFact	Domain.ITAssetManagement	Daily	Provance.ITAM.UserDefinedAgreement	UserDefinedAgreementDim	Public
WarrantyAgreementContactFact	Domain.ITAssetManagement	Daily	Provance.ITAM.WarrantyAgreement	WarrantyAgreementDim	Public
WarrantyAgreementContractFact	Domain.ITAssetManagement	Daily	Provance.ITAM.WarrantyAgreement	WarrantyAgreementDim	Public

Warehouse Modules (1)

	ID	ETL Module	Warehouse Module Type	Target Warehouse Entity	Accessibility
	TransformAgreementExtensionDim	TransformAgreementExtensionDimProc	Transform	AgreementExtensionDim	Public