Service Manager Activity Management Data Warehouse Library

ServiceManager.ActivityManagement.Library.Datawarehouse :: 7.7.16.0 (Management Pack)

Management Pack Elements

Show Management Pack References

Warehouse

Dimension (3)
Outrigger (6)
Measure (3)
RelationshipFact (5)
Fact (3)

Dimensions (3)

	DisplayName	ID	Target	Inferred Dimension	Hierarchy Support	Reconcile	Accessibility
	Activity Dimension	ActivityDim	System.WorkItem.Activity	True	IncludeExtendedClassProperties	False	Public
	ReviewActivityDim	ReviewActivityDim	System.WorkItem.Activity.ReviewActivity	True	IncludeDerivedClassProperties	False	Public
	ReviewerDim	ReviewerDim	System.Reviewer	True	IncludeExtendedClassProperties	False	Public

Outriggers (6)

	DisplayName	ID	Accessibility
	Activity Area Outrigger	ActivityArea	Public
	Activity Priority Outrigger	ActivityPriority	Public
	Activity Stage Outrigger	ActivityStage	Public
	Activity Status Outrigger	ActivityStatus	Public
	ReviewActivityApproval	ReviewActivityApproval	Public
	ReviewerDecision	ReviewerDecision	Public

Measures (3)

	DisplayName	ID	Aggregation	Accessibility
	Activity Stage Total Time Measure	ActivityStageTotalTimeMeasure	Additive	Public
	Reviewer Decision Support Group Total Time Measure	ReviewerDecisionTotalTimeMeasure	Additive	Public
	ActivityTotalTimeMeasure	ActivityTotalTimeMeasure	Additive	Public

Relationship Facts (5)

	ID	Domain	Time Grain	Source Type	Source Dimension	Accessibility
	DependentActivityDependsOnWorkItem	Domain.ActivityManagement	Daily	System.WorkItem.Activity	ActivityDim	Public
	ReviewActivityHasReviewerFact	Domain.ActivityManagement	Daily	System.WorkItem.Activity	ActivityDim	Public
	ReviewerIsUserFact	Domain.ActivityManagement	Daily	System.Reviewer	ReviewerDim	Public
	ReviewerVotedByUserFact	Domain.ActivityManagement	Daily	System.Reviewer	ReviewerDim	Public
	WorkItemContainsActivityFact	Domain.ActivityManagement	Daily	System.WorkItem	WorkItemDim	Public

Facts (3)

	DisplayName	ID	Domain	Time Grain	Accessibility
	Activity Stage Status Duration Fact	ActivityStageDurationFact	Domain.ActivityManagement	Daily	Public
	Reviewer Decision Support Group Status Duration Fact	ReviewerDecisionDurationFact	Domain.ActivityManagement	Daily	Public
	ActivityStatusDurationFact	ActivityStatusDurationFact	Domain.ActivityManagement	Daily	Public