Service Manager Compliance Warehouse Library

ServiceManager.Compliance.Library.Datawarehouse :: 7.5.1510.3 (Management Pack)

• Show Management Pack XML
• Get Management Pack data in Excel format
• ServiceManager.GRC.Library.Datawarehouse.mpb

Management Pack Elements

Resources (10)

	ID	File Name	Accessibility
	InstallTransformApplicabilityGroupDimResource	InstallTransformApplicabilityGroupDim.sql	Public
	InstallTransformControlActivityStatusDurationFactResource	InstallTransformControlActivityStatusDurationFact.sql	Public
	InstallTransformControlObjectiveStatusDurationFactResource	InstallTransformControlObjectiveStatusDurationFact.sql	Public
	InstallTransformManagedEntityResultFactResource	InstallTransformManagedEntityResultFact.sql	Public
	InstallTransformProgramContainsControlActivitiesFactResource	InstallTransformProgramContainsControlActivitiesFact.sql	Public
	UninstallTranformManagedEntityResultFactResource	UninstallTransformManagedEntityResultFact.sql	Public
	UninstallTransformApplicabilityGroupDimResource	UninstallTransformApplicabilityGroupDim.sql	Public
	UninstallTransformControlActivityStatusDurationFactResource	UninstallTransformControlActivityStatusDurationFact.sql	Public
	UninstallTransformControlObjectiveStatusDurationFactResource	UninstallTransformControlObjectiveStatusDurationFact.sql	Public
	UninstallTransformProgramContainsControlActivitiesFactResource	UninstallTransformProgramContainsControlActivitiesFact.sql	Public

Data Warehouse Scripts (5)

	ID	Install Script	Uninstall Script	Upgrade Script	Upgrade Unsupported	Accessibility
	TransformApplicabilityGroupDimProc	InstallTransformApplicabilityGroupDimResource	UninstallTransformApplicabilityGroupDimResource		False	Public
	TransformControlActivityStatusDurationFactProc	InstallTransformControlActivityStatusDurationFactResource	UninstallTransformControlActivityStatusDurationFactResource		False	Public
	TransformControlObjectiveStatusDurationFactProc	InstallTransformControlObjectiveStatusDurationFactResource	UninstallTransformControlObjectiveStatusDurationFactResource		False	Public
	TransformManagedEntityResultFactProc	InstallTransformManagedEntityResultFactResource	UninstallTranformManagedEntityResultFactResource		False	Public
	TransformProgramContainsControlActivitiesFactProc	InstallTransformProgramContainsControlActivitiesFactResource	UninstallTransformProgramContainsControlActivitiesFactResource		False	Public

Dimensions (11)

	DisplayName	ID	Target	Inferred Dimension	Hierarchy Support	Reconcile	Accessibility
	AuthorityDocument Citation Dim	AuthorityDocumentCitationDim	System.Compliance.Citation	True	IncludeExtendedClassProperties	False	Public
	AuthorityDocument Dim	AuthorityDocumentDim	System.Compliance.AuthorityDocument	True	IncludeExtendedClassProperties	False	Public
	Category Dim	CategoryDim	System.Compliance.Category	True	IncludeExtendedClassProperties	False	Public
	Control Activity Dim	ControlActivityDim	System.Compliance.ControlActivity	True	IncludeExtendedClassProperties	False	Public
	Control Activity Result Dim	ControlActivityResultDim	System.Compliance.ControlActivityResult	True	IncludeExtendedClassProperties	False	Public
	Control Objective Dim	ControlObjectiveDim	System.Compliance.ControlObjective	True	IncludeExtendedClassProperties	False	Public
	Manual Control Activity Dim	ManualControlActivityDim	System.Compliance.ManualControlActivity	True	IncludeExtendedClassProperties	False	Public
	Program Dim	ProgramDim	System.Compliance.Program	True	IncludeExtendedClassProperties	False	Public
	Risk Dim	RiskDim	System.Compliance.Risk	True	IncludeExtendedClassProperties	False	Public
	ApplicabilityGroupDim	ApplicabilityGroupDim	System.Compliance.ApplicabilityGroup	True	IncludeExtendedClassProperties	False	Public
	MERSourceDim	MERSourceDim	System.Compliance.ManagedEntityResultSource	True	IncludeExtendedClassProperties	False	Public

Outriggers (22)

	DisplayName	ID	Accessibility
	AuthorityDocumentCategory Enumeration	AuthorityDocumentCategory	Public
	AuthorityDocumentType Enumeration	AuthorityDocumentType	Public
	Control Activity Result Outrigger	CAResult	Public
	Control Activity Status Outrigger	CAStatus	Public
	Control Activity Type Outrigger	CAType	Public
	Control Objective Status Outrigger	COStatus	Public
	Managed Entity Result result Outrigger	MERResult	Public
	Managed Entity Result Result Type Outrigger	MERResultType	Public
	RiskShared Outrigger	PolicyItemShared	Public
	RiskClassification Outrigger	RiskClassification	Public
	RiskControlLevel Outrigger	RiskControlLevel	Public
	RiskImpact Outrigger	RiskImpact	Public
	RiskLikelihood Outrigger	RiskLikelihood	Public
	RiskRank Outrigger	RiskRank	Public
	Status Outrigger	RiskStatus	Public
	Status Outrigger	Status	Public
	CAScore	CAScore	Public
	CATechnology	CATechnology	Public
	ComplianceSourceName	ComplianceSourceName	Public
	COType	COType	Public
	Level	Level	Public
	Priority	Priority	Public

Relationship Facts (60)

	DisplayName	ID	Domain	Time Grain	Source Type	Source Dimension	Accessibility
	Applicable Group Config Items Fact	ApplicableGroupConfigItemFact	Domain.InstanceManagement	Daily	System.Compliance.ApplicabilityGroup	ApplicabilityGroupDim	Public
	AuthorityDcoument Has AuthorityDocument Citation Fact	AuthorityDocumentHasCitationFact	Domain.InstanceManagement	Daily	System.Compliance.AuthorityDocument	AuthorityDocumentDim	Public
	ControlActivity AuthorityDocument Fact	CAAuthorityDocFact	Domain.InstanceManagement	Daily	System.Compliance.ControlActivity	ControlActivityDim	Public
	ControlActivity contains ControlActivity Fact	CAHasCAFact	Domain.InstanceManagement	Daily	System.Compliance.ControlActivity	ControlActivityDim	Public
	Category contains Category Fact	CategoryContainsCategoryFact	Domain.InstanceManagement	Daily	System.Compliance.Category	CategoryDim	Public
	Category contains Risk Fact	CategoryContainsRiskFact	Domain.InstanceManagement	Daily	System.Compliance.Category	CategoryDim	Public
	Category Coowned by user Fact	CategoryCoOwnedByUserFact	Domain.InstanceManagement	Daily	System.Compliance.Category	CategoryDim	Public
	Category contains ControlObjective Fact	CategoryHasCOFact	Domain.InstanceManagement	Daily	System.Compliance.Category	CategoryDim	Public
	Category owned by user Fact	CategoryOwnedByUserFact	Domain.InstanceManagement	Daily	System.Compliance.Category	CategoryDim	Public
	ControlObjective contains ControlActivity Fact	COHasCAFact	Domain.InstanceManagement	Daily	System.Compliance.ControlObjective	ControlObjectiveDim	Public
	ControlObjective contains ControlObjective Fact	COHasCOFact	Domain.InstanceManagement	Daily	System.Compliance.ControlObjective	ControlObjectiveDim	Public
	Compliance Control Activity Applicability Group Fact	ComplianceControlActivityApplicabilityGroupFact	Domain.InstanceManagement	Daily	System.Compliance.ControlActivity	ControlActivityDim	Public
	ControlActivity assigned to user Fact	ControlActivityAssignedToUserFact	Domain.InstanceManagement	Daily	System.Compliance.ControlActivity	ControlActivityDim	Public
	ControlActivity Contains FileAttachment Fact	ControlActivityContainsFileAttachmentFact	Domain.InstanceManagement	Daily	System.Compliance.ControlActivity	ControlActivityDim	Public
	ControlActivity Contains Software Fact	ControlActivityContainsSoftwareFact	Domain.InstanceManagement	Daily	System.Compliance.ControlActivity	ControlActivityDim	Public
	ControlActivity owned by user Fact	ControlActivityOwnedByUserFact	Domain.InstanceManagement	Daily	System.Compliance.ControlActivity	ControlActivityDim	Public
	ControlActivity Related Incident Fact	ControlActivityRelatedToIncidentFact	Domain.InstanceManagement	Daily	System.Compliance.ControlActivity	ControlActivityDim	Public
	ControlActivity RelatedWorkItem Fact	ControlActivityRelatedToWorkItemFact	Domain.InstanceManagement	Daily	System.Compliance.ControlActivity	ControlActivityDim	Public
	ControlActivity relates to Risk Fact	ControlActivityRelatesToRiskFact	Domain.InstanceManagement	Daily	System.Compliance.ControlActivity	ControlActivityDim	Public
	Control Activity Result Owned by User Fact	ControlActivityResultOwnedByUserFact	Domain.InstanceManagement	Daily	System.Compliance.ControlActivityResult	ControlActivityResultDim	Public
	Control Objective assigned to user Fact	ControlObjectiveAssignedToUserFact	Domain.InstanceManagement	Daily	System.Compliance.ControlObjective	ControlObjectiveDim	Public
	ControlObjective Citation Fact	ControlObjectiveCitationFact	Domain.InstanceManagement	Daily	System.Compliance.ControlObjective	ControlObjectiveDim	Public
	ControlObjective Contains FileAttachment Fact	ControlObjectiveContainsFileAttachmentFact	Domain.InstanceManagement	Daily	System.Compliance.ControlObjective	ControlObjectiveDim	Public
	ControlObjective Contains Manual Activity Fact	ControlObjectiveContainsManualActivityFact	Domain.InstanceManagement	Daily	System.Compliance.ControlObjective	ControlObjectiveDim	Public
	ControlObjective Contains ReviewActivity Fact	ControlObjectiveContainsReviewActivityFact	Domain.InstanceManagement	Daily	System.Compliance.ControlObjective	ControlObjectiveDim	Public
	Control Objective owned by user Fact	ControlObjectiveOwnedByUserFact	Domain.InstanceManagement	Daily	System.Compliance.ControlObjective	ControlObjectiveDim	Public
	ControlObjective Related Incident Fact	ControlObjectiveRelatedToIncidentFact	Domain.InstanceManagement	Daily	System.WorkItem.Incident	IncidentDim	Public
	ControlObjective RelatedWorkItem Fact	ControlObjectiveRelatedToWorkItemFact	Domain.InstanceManagement	Daily	System.WorkItem	WorkItemDim	Public
	ControlObjective relates ro Risk Fact	ControlObjectiveRelatesToRiskFact	Domain.InstanceManagement	Daily	System.Compliance.ControlObjective	ControlObjectiveDim	Public
	Manual Control Activity contains Control Activity Result Fact	MCAContainsCARFact	Domain.InstanceManagement	Daily	System.Compliance.ManualControlActivity	ManualControlActivityDim	Public
	Program Approver Fact	ProgramApproverFact	Domain.InstanceManagement	Daily	System.Compliance.Program	ProgramDim	Public
	Program Contains ControlActivity Fact	ProgramContainsControlActivitiesFact	Domain.InstanceManagement	Daily	System.Compliance.Program	ProgramDim	Public
	Program Contains Risks Fact	ProgramContainsRisksFact	Domain.InstanceManagement	Daily	System.Compliance.Program	ProgramDim	Public
	Program CoOwned By User Fact	ProgramCoOwnedByUserFact	Domain.InstanceManagement	Daily	System.Compliance.Program	ProgramDim	Public
	Program Contains Categories Fact	ProgramHasCategoriesFact	Domain.InstanceManagement	Daily	System.Compliance.Program	ProgramDim	Public
	Program Contains ControlObjectives Fact	ProgramHasCOFact	Domain.InstanceManagement	Daily	System.Compliance.Program	ProgramDim	Public
	Program Owned by User Fact	ProgramOwnedByUserFact	Domain.InstanceManagement	Daily	System.Compliance.Program	ProgramDim	Public
	Program Contains ConfigItems Fact	ProgramScopeFact	Domain.InstanceManagement	Daily	System.Compliance.Program	ProgramDim	Public
	Risk assigned to user Fact	RiskAssignedToUserFact	Domain.InstanceManagement	Daily	System.Compliance.Risk	RiskDim	Public
	Risk Contains FileAttachment Fact	RiskContainsFileAttachmentFact	Domain.InstanceManagement	Daily	System.Compliance.Risk	RiskDim	Public
	Risk Contains ManualActivity Fact	RiskContainsManualActivityFact	Domain.InstanceManagement	Daily	System.Compliance.Risk	RiskDim	Public
	Risk Contains ReviewActivity Fact	RiskContainsReviewActivityFact	Domain.InstanceManagement	Daily	System.Compliance.Risk	RiskDim	Public
	Risk contains Risk Fact	RiskContainsRiskFact	Domain.InstanceManagement	Daily	System.Compliance.Risk	RiskDim	Public
	Risk owned by user Fact	RiskOwnedByUserFact	Domain.InstanceManagement	Daily	System.Compliance.Risk	RiskDim	Public
	Risk Related To Incident Fact	RiskRelatedToIncidentFact	Domain.InstanceManagement	Daily	System.WorkItem.Incident	IncidentDim	Public
	Risk Related To WorkItem Fact	RiskRelatedToWorkItemFact	Domain.InstanceManagement	Daily	System.WorkItem	WorkItemDim	Public
	Risk relates to ControlObjective	RiskRelatesToControlObjectiveFact	Domain.InstanceManagement	Daily	System.Compliance.Risk	RiskDim	Public
	ConfigItemContainsConfigItemFact	ConfigItemContainsConfigItemFact	Domain.InstanceManagement	Daily	System.ConfigItem	ConfigItemDim	Public
	ControlActivityCreatedByUserFact	ControlActivityCreatedByUserFact	Domain.InstanceManagement	Daily	System.Compliance.ControlActivity	ControlActivityDim	Public
	ControlActivityModifiedByUserFact	ControlActivityModifiedByUserFact	Domain.InstanceManagement	Daily	System.Compliance.ControlActivity	ControlActivityDim	Public
	ControlObjectiveCreatedByUserFact	ControlObjectiveCreatedByUserFact	Domain.InstanceManagement	Daily	System.Compliance.ControlObjective	ControlObjectiveDim	Public
	ControlObjectiveModifiedByUserFact	ControlObjectiveModifiedByUserFact	Domain.InstanceManagement	Daily	System.Compliance.ControlObjective	ControlObjectiveDim	Public
	ExceptionRelatesToCAFact	ExceptionRelatesToCAFact	Domain.InstanceManagement	Daily	System.WorkItem.Exception	ExceptionDim	Public
	ExceptionRelatesToProgramFact	ExceptionRelatesToProgramFact	Domain.InstanceManagement	Daily	System.WorkItem.Exception	ExceptionDim	Public
	ProgramCreatedByUserFact	ProgramCreatedByUserFact	Domain.InstanceManagement	Daily	System.Compliance.Program	ProgramDim	Public
	ProgramModifiedByUserFact	ProgramModifiedByUserFact	Domain.InstanceManagement	Daily	System.Compliance.Program	ProgramDim	Public
	ProgramRelatesToADFact	ProgramRelatesToADFact	Domain.InstanceManagement	Daily	System.Compliance.Program	ProgramDim	Public
	RiskCreatedByUserFact	RiskCreatedByUserFact	Domain.InstanceManagement	Daily	System.Compliance.Risk	RiskDim	Public
	RiskModifiedByUserFact	RiskModifiedByUserFact	Domain.InstanceManagement	Daily	System.Compliance.Risk	RiskDim	Public
	ServiceHasGroupsFact	ServiceHasGroupsFact	Domain.InstanceManagement	Daily	System.ConfigItem	ConfigItemDim	Public

Facts (3)

	ID	Domain	Time Grain	Accessibility
	ControlActivityStatusDurationFact	Domain.InstanceManagement	Daily	Public
	ControlObjectiveStatusDurationFact	Domain.InstanceManagement	Daily	Public
	ManagedEntityResultFact	Domain.InstanceManagement	Daily	Public

Warehouse Modules (5)

	ID	ETL Module	Warehouse Module Type	Target Warehouse Entity	Accessibility
	TransformApplicabilityGroupDim	TransformApplicabilityGroupDimProc	Transform	ApplicabilityGroupDim	Public
	TransformControlActivityStatusDurationFact	TransformControlActivityStatusDurationFactProc	Transform	ControlActivityStatusDurationFact	Public
	TransformControlObjectiveStatusDurationFact	TransformControlObjectiveStatusDurationFactProc	Transform	ControlObjectiveStatusDurationFact	Public
	TransformManagedEntityResultFact	TransformManagedEntityResultFactProc	Transform	ManagedEntityResultFact	Public
	TransformProgramContainsControlActivitiesFact	TransformProgramContainsControlActivitiesFactProc	Transform	ProgramContainsControlActivitiesFact	Public