Service Manager Cloud Services Data Warehouse Library

ServiceManager.CloudServices.DataWarehouse.Library :: 7.5.2020.0 (Management Pack)

Management Pack Elements

Enumerations (1)

 IDParentAccessibility
Domain.CloudServicesDomain.CloudServicesDomainPublic

Resources (10)

 IDFile NameAccessibility
TransformCloudServicesVirtualMachineDailyFactResourceTransformCloudServicesVirtualMachineDailyFactResourceTransformCloudServicesVirtualMachineDailyFact.sqlPublic
TransformCloudServicesVirtualMachineSnapshotFactResourceTransformCloudServicesVirtualMachineSnapshotFactResourceTransformCloudServicesVirtualMachineSnapshotFact.sqlPublic
TransformCloudServicesVirtualMachineSummaryFactResourceTransformCloudServicesVirtualMachineSummaryFactResourceTransformCloudServicesVirtualMachineSummaryFact.sqlPublic
TransformCloudServicesVMCostSettingsDailyFactResourceTransformCloudServicesVMCostSettingsDailyFactResourceTransformCloudServicesVMCostSettingsDailyFact.sqlPublic
TransformCloudServicesVMCostSettingsSnapshotFactResourceTransformCloudServicesVMCostSettingsSnapshotFactResourceTransformCloudServicesVMCostSettingsSnapshotFact.sqlPublic
UninstallCloudServicesVirtualMachineDailyFactResourceUninstallCloudServicesVirtualMachineDailyFactResourceUninstallCloudServicesVirtualMachineDailyFact.sqlPublic
UninstallCloudServicesVirtualMachineSnapshotFactResourceUninstallCloudServicesVirtualMachineSnapshotFactResourceUninstallCloudServicesVirtualMachineSnapshotFact.sqlPublic
UninstallCloudServicesVirtualMachineSummaryFactResourceUninstallCloudServicesVirtualMachineSummaryFactResourceUninstallCloudServicesVirtualMachineSummaryFact.sqlPublic
UninstallCloudServicesVMCostSettingsDailyFactResourceUninstallCloudServicesVMCostSettingsDailyFactResourceUninstallCloudServicesVMCostSettingsDailyFact.sqlPublic
UninstallCloudServicesVMCostSettingsSnapshotFactResourceUninstallCloudServicesVMCostSettingsSnapshotFactResourceUninstallCloudServicesVMCostSettingsSnapshotFact.sqlPublic

Data Warehouse Scripts (5)

 IDInstall ScriptUninstall ScriptUpgrade ScriptUpgrade UnsupportedAccessibility
TransformCloudServicesVirtualMachineDailyFactProcTransformCloudServicesVirtualMachineDailyFactProcTransformCloudServicesVirtualMachineDailyFactResourceUninstallCloudServicesVirtualMachineDailyFactResourceTransformCloudServicesVirtualMachineDailyFactResourceFalsePublic
TransformCloudServicesVirtualMachineSnapshotFactProcTransformCloudServicesVirtualMachineSnapshotFactProcTransformCloudServicesVirtualMachineSnapshotFactResourceUninstallCloudServicesVirtualMachineSnapshotFactResourceTransformCloudServicesVirtualMachineSnapshotFactResourceFalsePublic
TransformCloudServicesVirtualMachineSummaryFactProcTransformCloudServicesVirtualMachineSummaryFactProcTransformCloudServicesVirtualMachineSummaryFactResourceUninstallCloudServicesVirtualMachineSummaryFactResourceTransformCloudServicesVirtualMachineSummaryFactResourceFalsePublic
TransformCloudServicesVMCostSettingsDailyFactProcTransformCloudServicesVMCostSettingsDailyFactProcTransformCloudServicesVMCostSettingsDailyFactResourceUninstallCloudServicesVMCostSettingsDailyFactResourceTransformCloudServicesVMCostSettingsDailyFactResourceFalsePublic
TransformCloudServicesVMCostSettingsSnapshotFactProcTransformCloudServicesVMCostSettingsSnapshotFactProcTransformCloudServicesVMCostSettingsSnapshotFactResourceUninstallCloudServicesVMCostSettingsSnapshotFactResourceTransformCloudServicesVMCostSettingsSnapshotFactResourceFalsePublic

Dimensions (9)

 IDTargetInferred DimensionHierarchy SupportReconcileAccessibility
CloudServicesLogicalNetworkDimCloudServicesLogicalNetworkDimServiceManager.CloudServices.Extended.LogicalNetworkTrueIncludeExtendedClassPropertiesTruePublic
CloudServicesResourceCriteriaDimCloudServicesResourceCriteriaDimServiceManager.CloudServices.ResourceCriteriaTrueIncludeExtendedClassPropertiesTruePublic
CloudServicesServiceTemplateDimCloudServicesServiceTemplateDimServiceManager.CloudServices.Extended.ServiceTemplateTrueIncludeExtendedClassPropertiesTruePublic
CloudServicesSubscriptionDimCloudServicesSubscriptionDimServiceManager.CloudServices.VMMCloudResourcesSubscriptionTrueIncludeExtendedClassPropertiesTruePublic
CloudServicesTenantDimCloudServicesTenantDimServiceManager.CloudServices.TenantTrueIncludeExtendedClassPropertiesTruePublic
CloudServicesVirtualMachineDimCloudServicesVirtualMachineDimServiceManager.CloudServices.Extended.VirtualMachineTrueIncludeExtendedClassPropertiesTruePublic
CloudServicesVMTemplateDimCloudServicesVMTemplateDimServiceManager.CloudServices.Extended.VMTemplateTrueIncludeExtendedClassPropertiesTruePublic
MicrosoftADUserBaseDimMicrosoftADUserBaseDimMicrosoft.AD.UserBaseTrueIncludeExtendedClassPropertiesTruePublic
SystemCostCenterDimSystemCostCenterDimSystem.CostCenterTrueIncludeExtendedClassPropertiesTruePublic

Outriggers (2)

 DisplayNameIDAccessibility
CloudServicesStatusCloud Services Status OutriggerCloudServicesStatusPublic
CloudServicesSubscriptionVMApprovalRequiredCloud Resources Subscription VM Approval Required OutriggerCloudServicesSubscriptionVMApprovalRequiredPublic

Measures (12)

 DisplayNameIDAggregationAccessibility
CPUCostMeasureCPU CostCPUCostMeasureAdditivePublic
MemoryCostMeasureMemory CostMemoryCostMeasureAdditivePublic
MiscellaneousCostMeasureMiscellaneous CostMiscellaneousCostMeasureAdditivePublic
StorageCostMeasureStorage CostStorageCostMeasureAdditivePublic
TotalCostMeasureTotal CostTotalCostMeasureAdditivePublic
CPUCountMeasureCPUCountMeasureCPUCountMeasureAdditivePublic
MemoryGBMeasureMemoryGBMeasureMemoryGBMeasureAdditivePublic
PerDayMiscellaneousCostMeasurePerDayMiscellaneousCostMeasurePerDayMiscellaneousCostMeasureAdditivePublic
PerUnitCPUCostMeasurePerUnitCPUCostMeasurePerUnitCPUCostMeasureAdditivePublic
PerUnitMemoryCostMeasurePerUnitMemoryCostMeasurePerUnitMemoryCostMeasureAdditivePublic
PerUnitStorageCostMeasurePerUnitStorageCostMeasurePerUnitStorageCostMeasureAdditivePublic
StorageGBMeasureStorageGBMeasureStorageGBMeasureAdditivePublic

Relationship Facts (9)

 IDDomainTime GrainSource TypeSource DimensionAccessibility
CloudServicesSubscriptionHasUsersFactCloudServicesSubscriptionHasUsersFactDomain.CloudServicesDailyServiceManager.CloudServices.VMMCloudResourcesSubscriptionCloudServicesSubscriptionDimPublic
CloudServicesSubscriptionRelatesToLogicalNetworkFactCloudServicesSubscriptionRelatesToLogicalNetworkFactDomain.CloudServicesDailyServiceManager.CloudServices.VMMCloudResourcesSubscriptionCloudServicesSubscriptionDimPublic
CloudServicesSubscriptionRelatesToServiceTemplateFactCloudServicesSubscriptionRelatesToServiceTemplateFactDomain.CloudServicesDailyServiceManager.CloudServices.VMMCloudResourcesSubscriptionCloudServicesSubscriptionDimPublic
CloudServicesSubscriptionRelatesToVirtualMachineFactCloudServicesSubscriptionRelatesToVirtualMachineFactDomain.CloudServicesDailyServiceManager.CloudServices.VMMCloudResourcesSubscriptionCloudServicesSubscriptionDimPublic
CloudServicesSubscriptionRelatesToVMTemplateFactCloudServicesSubscriptionRelatesToVMTemplateFactDomain.CloudServicesDailyServiceManager.CloudServices.VMMCloudResourcesSubscriptionCloudServicesSubscriptionDimPublic
CloudServicesSubscriptionToResourceCriteriaFactCloudServicesSubscriptionToResourceCriteriaFactDomain.CloudServicesDailyServiceManager.CloudServices.VMMCloudResourcesSubscriptionCloudServicesSubscriptionDimPublic
CloudServicesTenantContainsSubscriptionFactCloudServicesTenantContainsSubscriptionFactDomain.CloudServicesDailyServiceManager.CloudServices.TenantCloudServicesTenantDimPublic
CloudServicesTenantHasAdminsFactCloudServicesTenantHasAdminsFactDomain.CloudServicesDailyServiceManager.CloudServices.TenantCloudServicesTenantDimPublic
CloudServicesTenantHasCostCenterFactCloudServicesTenantHasCostCenterFactDomain.CloudServicesDailyServiceManager.CloudServices.TenantCloudServicesTenantDimPublic

Facts (5)

 DisplayNameIDDomainTime GrainAccessibility
CloudServicesVirtualMachineDailyFactVirtual Machine Daily FactCloudServicesVirtualMachineDailyFactDomain.CloudServicesDailyPublic
CloudServicesVirtualMachineSnapshotFactVirtual Machine Snapshot FactCloudServicesVirtualMachineSnapshotFactDomain.CloudServicesDailyPublic
CloudServicesVirtualMachineSummaryFactVirtual Machine Summary FactCloudServicesVirtualMachineSummaryFactDomain.CloudServicesDailyPublic
CloudServicesVMCostSettingsDailyFactVM Cost Settings Daily FactCloudServicesVMCostSettingsDailyFactDomain.CloudServicesDailyPublic
CloudServicesVMCostSettingsSnapshotFactVM Cost Settings Snapshot FactCloudServicesVMCostSettingsSnapshotFactDomain.CloudServicesDailyPublic

Warehouse Modules (5)

 IDETL ModuleWarehouse Module TypeTarget Warehouse EntityAccessibility
TransformCloudServicesVirtualMachineDailyFactTransformCloudServicesVirtualMachineDailyFactTransformCloudServicesVirtualMachineDailyFactProcTransformCloudServicesVirtualMachineDailyFactPublic
TransformCloudServicesVirtualMachineSnapshotFactTransformCloudServicesVirtualMachineSnapshotFactTransformCloudServicesVirtualMachineSnapshotFactProcTransformCloudServicesVirtualMachineSnapshotFactPublic
TransformCloudServicesVirtualMachineSummaryFactTransformCloudServicesVirtualMachineSummaryFactTransformCloudServicesVirtualMachineSummaryFactProcTransformCloudServicesVirtualMachineSummaryFactPublic
TransformCloudServicesVMCostSettingsDailyFactTransformCloudServicesVMCostSettingsDailyFactTransformCloudServicesVMCostSettingsDailyFactProcTransformCloudServicesVMCostSettingsDailyFactPublic
TransformCloudServicesVMCostSettingsSnapshotFactTransformCloudServicesVMCostSettingsSnapshotFactTransformCloudServicesVMCostSettingsSnapshotFactProcTransformCloudServicesVMCostSettingsSnapshotFactPublic