Service Manager Chargeback Data Warehouse Infrastructure Library

ServiceManager.Chargeback.DataWarehouse.Infrastructure :: 7.7.16.0 (Management Pack)

This Management Pack contains Data Warehouse elements specific to infrastructure chargeback.

Management Pack Elements

Resources (8)

 IDFile NameAccessibility
TransformInfraChargebackDailyFactResourceTransformInfraChargebackDailyFactResourceTransformInfraChargebackDailyFact.sqlPublic
TransformInfraChargebackMonthlyFactResourceTransformInfraChargebackMonthlyFactResourceTransformInfraChargebackMonthlyFact.sqlPublic
TransformVirtualDiskDriveSnapshotFactResourceTransformVirtualDiskDriveSnapshotFactResourceTransformVirtualDiskDriveSnapshotFact.sqlPublic
TransformVirtualNicSnapshotFactResourceTransformVirtualNicSnapshotFactResourceTransformVirtualNicSnapshotFact.sqlPublic
UninstallInfraChargebackDailyFactResourceUninstallInfraChargebackDailyFactResourceUninstallInfraChargebackDailyFact.sqlPublic
UninstallInfraChargebackMonthlyFactResourceUninstallInfraChargebackMonthlyFactResourceUninstallInfraChargebackMonthlyFact.sqlPublic
UninstallVirtualDiskDriveSnapshotFactResourceUninstallVirtualDiskDriveSnapshotFactResourceUninstallVirtualDiskDriveSnapshotFact.sqlPublic
UninstallVirtualNicSnapshotFactResourceUninstallVirtualNicSnapshotFactResourceUninstallVirtualNicSnapshotFact.sqlPublic

Data Warehouse Scripts (4)

 IDInstall ScriptUninstall ScriptUpgrade ScriptUpgrade UnsupportedAccessibility
TransformInfraChargebackDailyFactProcTransformInfraChargebackDailyFactProcTransformInfraChargebackDailyFactResourceUninstallInfraChargebackDailyFactResourceTransformInfraChargebackDailyFactResourceFalsePublic
TransformInfraChargebackMonthlyFactProcTransformInfraChargebackMonthlyFactProcTransformInfraChargebackMonthlyFactResourceUninstallInfraChargebackMonthlyFactResourceTransformInfraChargebackMonthlyFactResourceFalsePublic
TransformVirtualDiskDriveSnapshotFactProcTransformVirtualDiskDriveSnapshotFactProcTransformVirtualDiskDriveSnapshotFactResourceUninstallVirtualDiskDriveSnapshotFactResourceTransformVirtualDiskDriveSnapshotFactResourceFalsePublic
TransformVirtualNicSnapshotFactProcTransformVirtualNicSnapshotFactProcTransformVirtualNicSnapshotFactResourceUninstallVirtualNicSnapshotFactResourceTransformVirtualNicSnapshotFactResourceFalsePublic

Dimensions (5)

 DisplayNameIDTargetInferred DimensionHierarchy SupportReconcileAccessibility
PrivateCloudDimPrivate Cloud DimensionPrivateCloudDimMicrosoft.SystemCenter.VirtualMachineManager.PrivateCloudTrueIncludeExtendedClassPropertiesTruePublic
UserRoleDimUser Role DimensionUserRoleDimMicrosoft.SystemCenter.VirtualMachineManager.UserRoleTrueIncludeExtendedClassPropertiesTruePublic
VirtualDiskDriveDimVirtual Disk Drive DimensionVirtualDiskDriveDimMicrosoft.SystemCenter.VirtualMachineManager.VirtualDiskDriveTrueIncludeExtendedClassPropertiesTruePublic
VirtualMachineDimVirtual Machine DimensionVirtualMachineDimMicrosoft.SystemCenter.VirtualMachineManager.VirtualMachineTrueIncludeExtendedClassPropertiesTruePublic
VirtualNicDimVirtual Nic DimensionVirtualNicDimMicrosoft.SystemCenter.VirtualMachineManager.Network.VNicTrueIncludeExtendedClassPropertiesTruePublic

Measures (15)

 DisplayNameIDAggregationAccessibility
CoresCostMeasureCores Cost MeasureCoresCostMeasureAdditivePublic
CoresCountMeasureCores Count MeasureCoresCountMeasureAdditivePublic
DynamicalVHDTypeCostMeasureDynamical VHD Type Cost MeasureDynamicalVHDTypeCostMeasureAdditivePublic
DynamicalVHDTypeCountMeasureDynamical VHD Type Count MeasureDynamicalVHDTypeCountMeasureAdditivePublic
HighAvailabilityCostMeasureHigh Availability Cost MeasureHighAvailabilityCostMeasureAdditivePublic
HighAvailabilityCountMeasureHigh Availability Count MeasureHighAvailabilityCountMeasureAdditivePublic
MemoryCountMeasureMemory Count MeasureMemoryCountMeasureAdditivePublic
MemoryTotalCostMeasureMemory Cost MeasureMemoryTotalCostMeasureAdditivePublic
PaddingMeasurePadding MeasurePaddingMeasureAdditivePublic
PrivateCloudMembershipCostMeasurePrivate Cloud Membership Cost MeasurePrivateCloudMembershipCostMeasureAdditivePublic
StaticIPCostMeasureStatic IP Cost MeasureStaticIPCostMeasureAdditivePublic
StaticIPCountMeasureStatic IP Count MeasureStaticIPCountMeasureAdditivePublic
StorageCountMeasureStorage Count MeasureStorageCountMeasureAdditivePublic
StorageTotalCostMeasureStorage Cost MeasureStorageTotalCostMeasureAdditivePublic
VMBaseCostMeasureVM Base Cost MeasureVMBaseCostMeasureAdditivePublic

Relationship Facts (6)

 DisplayNameIDDomainTime GrainSource TypeSource DimensionAccessibility
PrivateCloudContainsVirtualMachineFactPrivate Cloud Contains Virtual Machine FactPrivateCloudContainsVirtualMachineFactDomain.ServiceManagerChargebackDailyMicrosoft.SystemCenter.VirtualMachineManager.PrivateCloudPrivateCloudDimPublic
PrivateCloudRelatesToDefaultUsageFactPrivate Cloud Relates To Default Usage FactPrivateCloudRelatesToDefaultUsageFactDomain.ServiceManagerChargebackDailyMicrosoft.SystemCenter.VirtualMachineManager.PrivateCloudPrivateCloudDimPublic
PrivateCloudRelatesToUsageFactPrivate Cloud Relates To Usage FactPrivateCloudRelatesToUsageFactDomain.ServiceManagerChargebackDailyMicrosoft.SystemCenter.VirtualMachineManager.PrivateCloudPrivateCloudDimPublic
UserRoleRelatesToUsageFactUser Role Relates To Usage FactUserRoleRelatesToUsageFactDomain.ServiceManagerChargebackDailyMicrosoft.SystemCenter.VirtualMachineManager.UserRoleUserRoleDimPublic
VirtualMachineContainsVirtualDiskDriveFactVirtual Machine Contains Virtual Disk Drive FactVirtualMachineContainsVirtualDiskDriveFactDomain.ServiceManagerChargebackDailyMicrosoft.SystemCenter.VirtualMachineManager.VirtualMachineVirtualMachineDimPublic
VirtualMachineHostsVNicFactVirtual Machine Hosts VNic FactVirtualMachineHostsVNicFactDomain.ServiceManagerChargebackDailyMicrosoft.SystemCenter.VirtualMachineManager.VirtualMachineVirtualMachineDimPublic

Facts (4)

 DisplayNameIDDomainTime GrainAccessibility
InfraChargebackDailyFactInfrastructure Chargeback Daily FactInfraChargebackDailyFactDomain.ServiceManagerChargebackDailyPublic
InfraChargebackMonthlyFactInfrastructure Chargeback Monthly FactInfraChargebackMonthlyFactDomain.ServiceManagerChargebackDailyPublic
VirtualDiskDriveSnapshotFactVirtual Disk Drive Snapshot FactVirtualDiskDriveSnapshotFactDomain.ServiceManagerChargebackDailyPublic
VirtualNicSnapshotFactVirtual Nic Snapshot FactVirtualNicSnapshotFactDomain.ServiceManagerChargebackDailyPublic

Warehouse Modules (4)

 IDETL ModuleWarehouse Module TypeTarget Warehouse EntityAccessibility
TransformInfraChargebackDailyFactTransformInfraChargebackDailyFactTransformInfraChargebackDailyFactProcTransformInfraChargebackDailyFactPublic
TransformInfraChargebackMonthlyFactTransformInfraChargebackMonthlyFactTransformInfraChargebackMonthlyFactProcTransformInfraChargebackMonthlyFactPublic
TransformVirtualDiskDriveSnapshotFactTransformVirtualDiskDriveSnapshotFactTransformVirtualDiskDriveSnapshotFactProcTransformVirtualDiskDriveSnapshotFactPublic
TransformVirtualNicSnapshotFactTransformVirtualNicSnapshotFactTransformVirtualNicSnapshotFactProcTransformVirtualNicSnapshotFactPublic