Provance Common Datawarehouse Library

Provance.Common.Datawarehouse :: 3.0.2125.0 (Management Pack)

Management Pack Elements

Show Management Pack References

TypeDefinitions

EntityTypes

EnumerationValue (1)

Resources

Resource (2)

Reporting

DataWarehouseScript (1)

Warehouse

Dimension (13)
Outrigger (2)
Measure (1)
RelationshipFact (14)
Fact (1)
WarehouseModule (1)

Enumerations (1)

	ID	Parent	Accessibility
	Provance.Domain	Domain	Public

Resources (2)

	ID	File Name	Accessibility
	TransformProvanceAgreementLifeCycleDurationFactProcResource	TransformProvanceAgreementLifeCycleDurationFactProc.sql	Public
	UninstallProvanceAgreementLifeCycleDurationFactProcResource	UninstallProvanceAgreementLifeCycleDurationFactProc.sql	Public

Data Warehouse Scripts (1)

	ID	Install Script	Uninstall Script	Upgrade Script	Upgrade Unsupported	Accessibility
	TransformProvanceAgreementLifeCycleDurationFactProc	TransformProvanceAgreementLifeCycleDurationFactProcResource	UninstallProvanceAgreementLifeCycleDurationFactProcResource	TransformProvanceAgreementLifeCycleDurationFactProcResource	False	Public

Dimensions (13)

	ID	Target	Inferred Dimension	Hierarchy Support	Reconcile	Accessibility
	ProvanceAgreementDim	Provance.Class.Agreement	True	IncludeExtendedClassProperties	False	Public
	ProvanceCompanyDim	Provance.Class.Company	True	IncludeExtendedClassProperties	False	Public
	ProvanceContactDim	Provance.Class.Contact	True	IncludeExtendedClassProperties	False	Public
	ProvanceCostCenterDim	Provance.Class.CostCenter	True	IncludeExtendedClassProperties	False	Public
	ProvanceInvoiceDim	Provance.Class.Invoice	True	IncludeExtendedClassProperties	False	Public
	ProvanceInvoiceLanguageDim	Provance.Class.Language	True	IncludeExtendedClassProperties	False	Public
	ProvanceInvoiceLineItemDim	Provance.Class.InvoiceLineItem	True	IncludeExtendedClassProperties	False	Public
	ProvanceLocationDim	Provance.Class.Location	True	IncludeExtendedClassProperties	False	Public
	ProvanceOrganizationDim	Provance.Class.Organization	True	IncludeExtendedClassProperties	False	Public
	ProvancePurchaseLineItemDim	Provance.Class.PurchaseLineItem	True	IncludeExtendedClassProperties	False	Public
	ProvancePurchaseOrderDim	Provance.Class.PurchaseOrder	True	IncludeExtendedClassProperties	False	Public
	ProvanceSubnetDim	Provance.Class.Subnet	True	IncludeExtendedClassProperties	False	Public
	ProvanceUserDefinedAgreementDim	Provance.Class.UserDefinedAgreement	True	IncludeExtendedClassProperties	False	Public

Outriggers (2)

	ID	Accessibility
	ProvanceAgreementLifeCycle	Public
	ProvanceUserDefinedAgreementType	Public

Measures (1)

	ID	Aggregation	Accessibility
	LifeCycleDuration	Additive	Public

Relationship Facts (14)

	ID	Domain	Time Grain	Source Type	Source Dimension	Accessibility
	ProvanceAgreementHasContactFact	Provance.Domain	Daily	Provance.Class.Agreement	ProvanceAgreementDim	Public
	ProvanceAgreementHasCostCenterFact	Provance.Domain	Daily	Provance.Class.Agreement	ProvanceAgreementDim	Public
	ProvanceAgreementHasInvoiceFact	Provance.Domain	Daily	Provance.Class.Agreement	ProvanceAgreementDim	Public
	ProvanceAgreementHasLocationFact	Provance.Domain	Daily	Provance.Class.Agreement	ProvanceAgreementDim	Public
	ProvanceAgreementHasOrganizationFact	Provance.Domain	Daily	Provance.Class.Agreement	ProvanceAgreementDim	Public
	ProvanceAgreementHasPurchaseOrderFact	Provance.Domain	Daily	Provance.Class.Agreement	ProvanceAgreementDim	Public
	ProvanceAgreementHasSupplierFact	Provance.Domain	Daily	Provance.Class.Agreement	ProvanceAgreementDim	Public
	ProvanceAgreementHasUserFact	Provance.Domain	Daily	Provance.Class.Agreement	ProvanceAgreementDim	Public
	ProvanceAgreementIsRelatedToAgreementFact	Provance.Domain	Daily	Provance.Class.Agreement	ProvanceAgreementDim	Public
	ProvanceContactIsForCompanyFact	Provance.Domain	Daily	Provance.Class.Contact	ProvanceContactDim	Public
	ProvanceCostCenterIsContainedByCostCenterFact	Provance.Domain	Daily	Provance.Class.CostCenter	ProvanceCostCenterDim	Public
	ProvanceLocationIsContainedByLocationFact	Provance.Domain	Daily	Provance.Class.Location	ProvanceLocationDim	Public
	ProvanceOrganizationIsContainedByOrganizationFact	Provance.Domain	Daily	Provance.Class.Organization	ProvanceOrganizationDim	Public
	ProvanceProvanceSubnetIsForLocationFact	Provance.Domain	Daily	Provance.Class.Subnet	ProvanceSubnetDim	Public

Facts (1)

	ID	Domain	Time Grain	Accessibility
	ProvanceAgreementLifeCycleDurationFact	Provance.Domain	Daily	Public

Warehouse Modules (1)

	ID	ETL Module	Warehouse Module Type	Target Warehouse Entity	Accessibility
	TransformProvanceAgreementLifeCycleDurationFact	TransformProvanceAgreementLifeCycleDurationFactProc	Transform	ProvanceAgreementLifeCycleDurationFact	Public