Data Warehouse-Bibliothek für Service Manager Cloud Services

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-StatusoutriggerCloudServicesStatusPublic
CloudServicesSubscriptionVMApprovalRequiredOutrigger für Genehmigung der virtuellen Maschine für Cloudressourcenabonnement erforderlichCloudServicesSubscriptionVMApprovalRequiredPublic

Measures (12)

 DisplayNameIDAggregationAccessibility
CPUCostMeasureCPU-KostenCPUCostMeasureAdditivePublic
MemoryCostMeasureArbeitsspeicherkostenMemoryCostMeasureAdditivePublic
MiscellaneousCostMeasureSonstige KostenMiscellaneousCostMeasureAdditivePublic
StorageCostMeasureSpeicherplatzkostenStorageCostMeasureAdditivePublic
TotalCostMeasureGesamtkostenTotalCostMeasureAdditivePublic
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
CloudServicesVirtualMachineDailyFactTäglicher Fakt für virtuelle MaschineCloudServicesVirtualMachineDailyFactDomain.CloudServicesDailyPublic
CloudServicesVirtualMachineSnapshotFactMomentaufnahmefakt für virtuelle MaschineCloudServicesVirtualMachineSnapshotFactDomain.CloudServicesDailyPublic
CloudServicesVirtualMachineSummaryFactZusammenfassungsfakt für virtuelle MaschineCloudServicesVirtualMachineSummaryFactDomain.CloudServicesDailyPublic
CloudServicesVMCostSettingsDailyFactTägliches Fakt der Kosteneinstellungen für die virtuelle MaschineCloudServicesVMCostSettingsDailyFactDomain.CloudServicesDailyPublic
CloudServicesVMCostSettingsSnapshotFactMomentaufnahmefakt der Kosteneinstellungen für die virtuelle MaschineCloudServicesVMCostSettingsSnapshotFactDomain.CloudServicesDailyPublic

Warehouse Modules (5)

 IDETL ModuleWarehouse Module TypeTarget Warehouse EntityAccessibility
TransformCloudServicesVirtualMachineDailyFactTransformCloudServicesVirtualMachineDailyFactTransformCloudServicesVirtualMachineDailyFactProcTransformCloudServicesVirtualMachineDailyFactPublic
TransformCloudServicesVirtualMachineSnapshotFactTransformCloudServicesVirtualMachineSnapshotFactTransformCloudServicesVirtualMachineSnapshotFactProcTransformCloudServicesVirtualMachineSnapshotFactPublic
TransformCloudServicesVirtualMachineSummaryFactTransformCloudServicesVirtualMachineSummaryFactTransformCloudServicesVirtualMachineSummaryFactProcTransformCloudServicesVirtualMachineSummaryFactPublic
TransformCloudServicesVMCostSettingsDailyFactTransformCloudServicesVMCostSettingsDailyFactTransformCloudServicesVMCostSettingsDailyFactProcTransformCloudServicesVMCostSettingsDailyFactPublic
TransformCloudServicesVMCostSettingsSnapshotFactTransformCloudServicesVMCostSettingsSnapshotFactTransformCloudServicesVMCostSettingsSnapshotFactProcTransformCloudServicesVMCostSettingsSnapshotFactPublic