Schema Documentation

Source: dwh_performance OData endpoint — Cloud Insights

Tables found: 74  |  Associations: 167

Table of Contents

Key Relationships Between Tables

application_volume_hourly_performance_fact

Referenced (parent) tableFK columnParent PK
application_dimensionapplicationTktk
application_group_dimensionapplicationGroupTktk
business_entity_dimensionbusinessEntityTktk
date_dimensiondateTktk
service_level_dimensionserviceLevelTktk
tier_dimensiontierTktk
time_dimensiontimeTktk

disk_daily_performance_fact

Referenced (parent) tableFK columnParent PK
date_dimensiondateTktk
disk_dimensiondiskTktk
storage_dimensionstorageTktk
storage_pool_dimensionstoragePoolTktk

disk_hourly_performance_fact

Referenced (parent) tableFK columnParent PK
date_dimensiondateTktk
disk_dimensiondiskTktk
storage_dimensionstorageTktk
storage_pool_dimensionstoragePoolTktk
time_dimensiontimeTktk

host_vm_daily_performance_fact

Referenced (parent) tableFK columnParent PK
date_dimensiondateTktk
host_dimensionhostTktk

host_vm_hourly_performance_fact

Referenced (parent) tableFK columnParent PK
date_dimensiondateTktk
host_dimensionhostTktk
time_dimensiontimeTktk

host_volume_hourly_performance_fact

Referenced (parent) tableFK columnParent PK
business_entity_dimensionbusinessEntityTktk
date_dimensiondateTktk
host_dimensionhostTktk
host_group_dimensionhostGroupTktk
service_level_dimensionserviceLevelTktk
tier_dimensiontierTktk
time_dimensiontimeTktk

internal_volume_daily_performance_fact

Referenced (parent) tableFK columnParent PK
application_dimensionapplicationTktk
application_group_dimensionapplicationGroupTktk
business_entity_dimensionbusinessEntityTktk
date_dimensiondateTktk
internal_volume_dimensioninternalVolumeTktk
k8s_namespace_dimensionk8sNamespaceTktk
k8s_namespace_group_dimensionk8sNamespaceGroupTktk
service_level_dimensionserviceLevelTktk
storage_dimensionstorageTktk
storage_node_dimensionstorageNodeTktk
storage_pool_dimensionstoragePoolTktk
tier_dimensiontierTktk

internal_volume_hourly_performance_fact

Referenced (parent) tableFK columnParent PK
application_dimensionapplicationTktk
application_group_dimensionapplicationGroupTktk
business_entity_dimensionbusinessEntityTktk
date_dimensiondateTktk
internal_volume_dimensioninternalVolumeTktk
k8s_namespace_dimensionk8sNamespaceTktk
k8s_namespace_group_dimensionk8sNamespaceGroupTktk
service_level_dimensionserviceLevelTktk
storage_dimensionstorageTktk
storage_node_dimensionstorageNodeTktk
storage_pool_dimensionstoragePoolTktk
tier_dimensiontierTktk
time_dimensiontimeTktk

qtree_daily_performance_fact

Referenced (parent) tableFK columnParent PK
application_dimensionapplicationTktk
application_group_dimensionapplicationGroupTktk
business_entity_dimensionbusinessEntityTktk
date_dimensiondateTktk
internal_volume_dimensioninternalVolumeTktk
k8s_namespace_dimensionk8sNamespaceTktk
k8s_namespace_group_dimensionk8sNamespaceGroupTktk
qtree_dimensionqtreeTktk
service_level_dimensionserviceLevelTktk
storage_dimensionstorageTktk
storage_pool_dimensionstoragePoolTktk
tier_dimensiontierTktk

qtree_hourly_performance_fact

Referenced (parent) tableFK columnParent PK
application_dimensionapplicationTktk
application_group_dimensionapplicationGroupTktk
business_entity_dimensionbusinessEntityTktk
date_dimensiondateTktk
internal_volume_dimensioninternalVolumeTktk
k8s_namespace_dimensionk8sNamespaceTktk
k8s_namespace_group_dimensionk8sNamespaceGroupTktk
qtree_dimensionqtreeTktk
service_level_dimensionserviceLevelTktk
storage_dimensionstorageTktk
storage_pool_dimensionstoragePoolTktk
tier_dimensiontierTktk
time_dimensiontimeTktk

storage_node_daily_performance_fact

Referenced (parent) tableFK columnParent PK
date_dimensiondateTktk
storage_dimensionstorageTktk
storage_node_dimensionstorageNodeTktk
tier_dimensiontierTktk

storage_node_hourly_performance_fact

Referenced (parent) tableFK columnParent PK
date_dimensiondateTktk
storage_dimensionstorageTktk
storage_node_dimensionstorageNodeTktk
tier_dimensiontierTktk
time_dimensiontimeTktk

switch_performance_for_host_hourly_fact

Referenced (parent) tableFK columnParent PK
application_dimensionapplicationTktk
application_group_dimensionapplicationGroupTktk
business_entity_dimensionbusinessEntityTktk
date_dimensiondateTktk
host_dimensionhostTktk
time_dimensiontimeTktk

switch_performance_for_port_hourly_fact

Referenced (parent) tableFK columnParent PK
connected_device_dimensionconnectedDeviceTktk
date_dimensiondateTktk
fabric_dimensionfabricTktk
port_dimensionportTktk
switch_dimensionswitchTktk
time_dimensiontimeTktk

switch_performance_for_storage_hourly_fact

Referenced (parent) tableFK columnParent PK
date_dimensiondateTktk
storage_dimensionstorageTktk
time_dimensiontimeTktk

switch_performance_for_tape_hourly_fact

Referenced (parent) tableFK columnParent PK
date_dimensiondateTktk
tape_dimensiontapeTktk
time_dimensiontimeTktk

time_dimension

Referenced (parent) tableFK columnParent PK
date_dimensiondateTktk

vm_daily_performance_fact

Referenced (parent) tableFK columnParent PK
application_dimensionapplicationTktk
application_group_dimensionapplicationGroupTktk
business_entity_dimensionbusinessEntityTktk
date_dimensiondateTktk
host_dimensionhostTktk
k8s_node_dimensionk8sNodeTktk
vm_dimensionvmTktk

vm_hourly_performance_fact

Referenced (parent) tableFK columnParent PK
application_dimensionapplicationTktk
application_group_dimensionapplicationGroupTktk
business_entity_dimensionbusinessEntityTktk
date_dimensiondateTktk
host_dimensionhostTktk
k8s_node_dimensionk8sNodeTktk
time_dimensiontimeTktk
vm_dimensionvmTktk

vmdk_daily_performance_fact

Referenced (parent) tableFK columnParent PK
datastore_dimensiondataStoreTktk
date_dimensiondateTktk
host_dimensionhostTktk
service_level_dimensionserviceLevelTktk
storage_dimensionstorageTktk
tier_dimensiontierTktk
vm_dimensionvmTktk
vmdk_dimensionvmdkTktk

vmdk_hourly_performance_fact

Referenced (parent) tableFK columnParent PK
datastore_dimensiondataStoreTktk
date_dimensiondateTktk
host_dimensionhostTktk
service_level_dimensionserviceLevelTktk
storage_dimensionstorageTktk
tier_dimensiontierTktk
time_dimensiontimeTktk
vm_dimensionvmTktk
vmdk_dimensionvmdkTktk

volume_daily_performance_fact

Referenced (parent) tableFK columnParent PK
application_dimensionapplicationTktk
application_group_dimensionapplicationGroupTktk
business_entity_dimensionbusinessEntityTktk
date_dimensiondateTktk
host_dimensionhostTktk
host_group_dimensionhostGroupTktk
k8s_namespace_dimensionk8sNamespaceTktk
k8s_namespace_group_dimensionk8sNamespaceGroupTktk
service_level_dimensionserviceLevelTktk
storage_dimensionstorageTktk
storage_node_dimensionstorageNodeTktk
storage_pool_dimensionstoragePoolTktk
tier_dimensiontierTktk
volume_dimensionvolumeTktk

volume_hourly_performance_fact

Referenced (parent) tableFK columnParent PK
application_dimensionapplicationTktk
application_group_dimensionapplicationGroupTktk
business_entity_dimensionbusinessEntityTktk
date_dimensiondateTktk
host_dimensionhostTktk
host_group_dimensionhostGroupTktk
k8s_namespace_dimensionk8sNamespaceTktk
k8s_namespace_group_dimensionk8sNamespaceGroupTktk
service_level_dimensionserviceLevelTktk
storage_dimensionstorageTktk
storage_node_dimensionstorageNodeTktk
storage_pool_dimensionstoragePoolTktk
tier_dimensiontierTktk
time_dimensiontimeTktk
volume_dimensionvolumeTktk

Tables & Fields

PK Primary Key  FK Foreign Key  NOT NULL Required field

application_dimension↑ top

Entity Set(s): application_dimension

FieldTypeNullable
tkInt32Yes
nameStringYes
descriptionStringYes
priorityStringYes
urlStringYes
idInt32Yes
latestStringYes
dateTkInt32Yes

Navigation Properties (Joins)

Nav PropertyRelated EntityCardinality / Join
qtree_hourly_performance_factqtree_hourly_performance_factmany
volume_hourly_performance_factvolume_hourly_performance_factmany
application_volume_hourly_performance_factapplication_volume_hourly_performance_factmany
qtree_daily_performance_factqtree_daily_performance_factmany
vm_hourly_performance_factvm_hourly_performance_factmany
internal_volume_daily_performance_factinternal_volume_daily_performance_factmany
internal_volume_hourly_performance_factinternal_volume_hourly_performance_factmany
vm_daily_performance_factvm_daily_performance_factmany
switch_performance_for_host_hourly_factswitch_performance_for_host_hourly_factmany
volume_daily_performance_factvolume_daily_performance_factmany

application_group_bridge↑ top

Entity Set(s): application_group_bridge

FieldTypeNullable
appGroupTkInt32Yes
appTkInt32Yes
isRepStringYes

application_group_dimension↑ top

Entity Set(s): application_group_dimension

FieldTypeNullable
tkInt32Yes
repAppStringYes
repAppTkInt32Yes
cardinalityInt32Yes
dateTkInt32Yes

Navigation Properties (Joins)

Nav PropertyRelated EntityCardinality / Join
qtree_hourly_performance_factqtree_hourly_performance_factmany
volume_hourly_performance_factvolume_hourly_performance_factmany
application_volume_hourly_performance_factapplication_volume_hourly_performance_factmany
qtree_daily_performance_factqtree_daily_performance_factmany
vm_hourly_performance_factvm_hourly_performance_factmany
internal_volume_daily_performance_factinternal_volume_daily_performance_factmany
internal_volume_hourly_performance_factinternal_volume_hourly_performance_factmany
vm_daily_performance_factvm_daily_performance_factmany
switch_performance_for_host_hourly_factswitch_performance_for_host_hourly_factmany
volume_daily_performance_factvolume_daily_performance_factmany

application_volume_hourly_performance_fact↑ top

Entity Set(s): application_volume_hourly_performance_fact

FieldTypeNullable
tkPKInt64Yes
timeTkFK
time_dimension.tk
Int32Yes
dateTkFK
date_dimension.tk
Int32Yes
applicationTkFK
application_dimension.tk
Int32Yes
applicationGroupTkFK
application_group_dimension.tk
Int32Yes
tierTkFK
tier_dimension.tk
Int32Yes
serviceLevelTkFK
service_level_dimension.tk
Int32Yes
businessEntityTkFK
business_entity_dimension.tk
Int32Yes
readResponseTimeDoubleYes
writeResponseTimeDoubleYes
totalResponseTimeDoubleYes
totalResponseTimeMaxDoubleYes
readThroughputDoubleYes
writeThroughputDoubleYes
sumOfAveragesVolumeThroughputDoubleYes
maxOfMaxVolumeThroughputDoubleYes
sumOfMaxVolumeThroughputDoubleYes
readIopsDoubleYes
writeIopsDoubleYes
sumOfAveragesVolumeIopsDoubleYes
maxOfMaxVolumeIopsDoubleYes
sumOfMaxVolumeIopsDoubleYes
readCacheHitRatioDoubleYes
writeCacheHitRatioDoubleYes
totalCacheHitRatioDoubleYes
totalCacheHitRatioMaxDoubleYes
writePendingInt64Yes
readIoDensityDoubleYes
writeIoDensityDoubleYes
totalIoDensityDoubleYes
totalIoDensityMaxDoubleYes
compressionSavingsPercentDoubleYes
compressionSavingsSpaceDoubleYes
totalTimeToFullDoubleYes
confidenceIntervalTimeToFullDoubleYes

Navigation Properties (Joins)

Nav PropertyRelated EntityCardinality / Join
service_level_dimensionservice_level_dimensionone
JOIN: serviceLevelTk = service_level_dimension.tk
tier_dimensiontier_dimensionone
JOIN: tierTk = tier_dimension.tk
business_entity_dimensionbusiness_entity_dimensionone
JOIN: businessEntityTk = business_entity_dimension.tk
application_dimensionapplication_dimensionone
JOIN: applicationTk = application_dimension.tk
time_dimensiontime_dimensionone
JOIN: timeTk = time_dimension.tk
date_dimensiondate_dimensionone
JOIN: dateTk = date_dimension.tk
application_group_dimensionapplication_group_dimensionone
JOIN: applicationGroupTk = application_group_dimension.tk

business_entity_dimension↑ top

Entity Set(s): business_entity_dimension

FieldTypeNullable
tkInt32Yes
fullnameStringYes
tenantStringYes
lobStringYes
businessUnitStringYes
projectStringYes
idInt32Yes
latestStringYes
dateTkInt32Yes

Navigation Properties (Joins)

Nav PropertyRelated EntityCardinality / Join
qtree_hourly_performance_factqtree_hourly_performance_factmany
volume_hourly_performance_factvolume_hourly_performance_factmany
application_volume_hourly_performance_factapplication_volume_hourly_performance_factmany
qtree_daily_performance_factqtree_daily_performance_factmany
vm_hourly_performance_factvm_hourly_performance_factmany
host_volume_hourly_performance_facthost_volume_hourly_performance_factmany
internal_volume_daily_performance_factinternal_volume_daily_performance_factmany
internal_volume_hourly_performance_factinternal_volume_hourly_performance_factmany
vm_daily_performance_factvm_daily_performance_factmany
switch_performance_for_host_hourly_factswitch_performance_for_host_hourly_factmany
volume_daily_performance_factvolume_daily_performance_factmany

capacity_volume_fact_current↑ top

Entity Set(s): capacity_volume_fact_current

FieldTypeNullable
chargebackFactTkInt32Yes
volumeIdInt32Yes
storageIdInt32Yes
volumeNameStringYes
volumeTypeStringYes
thinProvisionedStringYes
isVirtualStringYes
snapshotStringYes
technologyTypeStringYes
physicalUsableMBInt64Yes
physicalRawMBInt64Yes
provisionedUsableMBInt64Yes
provisionedRawMBInt64Yes

cluster_switch_dimension↑ top

Entity Set(s): cluster_switch_dimension

FieldTypeNullable
tkInt32Yes
identifierStringYes
nameStringYes
addressStringYes
serialNumberStringYes
networkStringYes
versionStringYes
modelStringYes
monitoredStringYes
monitoringEnabledStringYes
monitoringReasonStringYes
idInt32Yes
latestStringYes
dateTkInt32Yes

cluster_switch_port_daily_metrics_fact↑ top

Entity Set(s): cluster_switch_port_daily_metrics_fact

FieldTypeNullable
tkPKInt64Yes
dateTkInt32Yes
clusterSwitchPortTkInt32Yes
clusterSwitchTkInt32Yes
storageTkInt32Yes
storageNodeTkInt32Yes
receiveBytesDoubleYes
transmitBytesDoubleYes
totalBytesDoubleYes
receiveDiscardsDoubleYes
transmitDiscardsDoubleYes
totalDiscardsDoubleYes
receiveErrorsDoubleYes
transmitErrorsDoubleYes
totalErrorsDoubleYes
receivePacketsDoubleYes
transmitPacketsDoubleYes
totalPacketsDoubleYes
timestampPKInt64Yes

cluster_switch_port_dimension↑ top

Entity Set(s): cluster_switch_port_dimension

FieldTypeNullable
tkInt32Yes
identifierStringYes
nameStringYes
duplexTypeStringYes
storageNodePortNameStringYes
storageNodePortMtuStringYes
portIndexStringYes
islStringYes
macAddressStringYes
mtuStringYes
numberStringYes
typeStringYes
speedStringYes
idInt32Yes
latestStringYes
dateTkInt32Yes

cluster_switch_port_hourly_metrics_fact↑ top

Entity Set(s): cluster_switch_port_hourly_metrics_fact

FieldTypeNullable
tkPKInt64Yes
timeTkInt32Yes
dateTkInt32Yes
clusterSwitchPortTkInt32Yes
clusterSwitchTkInt32Yes
storageTkInt32Yes
storageNodeTkInt32Yes
receiveBytesDoubleYes
transmitBytesDoubleYes
totalBytesDoubleYes
receiveDiscardsDoubleYes
transmitDiscardsDoubleYes
totalDiscardsDoubleYes
receiveErrorsDoubleYes
transmitErrorsDoubleYes
totalErrorsDoubleYes
receivePacketsDoubleYes
transmitPacketsDoubleYes
totalPacketsDoubleYes
timestampPKInt64Yes

connected_device_dimension↑ top

Entity Set(s): connected_device_dimension

FieldTypeNullable
tkInt32Yes
identifierStringYes
nameStringYes
manufacturerStringYes
modelStringYes
typeStringYes
firmwareStringYes
idInt32Yes
latestStringYes
dateTkInt32Yes

Navigation Properties (Joins)

Nav PropertyRelated EntityCardinality / Join
switch_performance_for_port_hourly_factswitch_performance_for_port_hourly_factmany

datastore_dimension↑ top

Entity Set(s): datastore_dimension

FieldTypeNullable
tkInt32Yes
naturalKeyStringYes
nameStringYes
moidStringYes
virtualCenterIpStringYes
urlStringYes
idInt32Yes
latestStringYes
dateTkInt32Yes

Navigation Properties (Joins)

Nav PropertyRelated EntityCardinality / Join
vmdk_hourly_performance_factvmdk_hourly_performance_factmany
vmdk_daily_performance_factvmdk_daily_performance_factmany

date_dimension↑ top

Entity Set(s): date_dimension

FieldTypeNullable
tkInt32Yes
fullDateDateTimeOffsetYes
dayInMonthByteYes
dayInYearInt32Yes
dateYearInt32Yes
yearLabelStringYes
monthNumByteYes
monthLabelStringYes
dayInWeekNumByteYes
quarterByteYes
quarterLabelStringYes
dayInQuarterInt32Yes
repQuarterByteYes
repMonthByteYes
repWeekByteYes
repDayByteYes
repMonthOrLatestByteYes
sspFlagByteYes
latestStringYes
futureStringYes

Navigation Properties (Joins)

Nav PropertyRelated EntityCardinality / Join
host_vm_daily_performance_facthost_vm_daily_performance_factmany
time_dimensiontime_dimensionmany
vm_hourly_performance_factvm_hourly_performance_factmany
switch_performance_for_port_hourly_factswitch_performance_for_port_hourly_factmany
host_volume_hourly_performance_facthost_volume_hourly_performance_factmany
internal_volume_daily_performance_factinternal_volume_daily_performance_factmany
vm_daily_performance_factvm_daily_performance_factmany
switch_performance_for_tape_hourly_factswitch_performance_for_tape_hourly_factmany
switch_performance_for_host_hourly_factswitch_performance_for_host_hourly_factmany
switch_performance_for_storage_hourly_factswitch_performance_for_storage_hourly_factmany
storage_node_hourly_performance_factstorage_node_hourly_performance_factmany
qtree_hourly_performance_factqtree_hourly_performance_factmany
vmdk_hourly_performance_factvmdk_hourly_performance_factmany
volume_hourly_performance_factvolume_hourly_performance_factmany
application_volume_hourly_performance_factapplication_volume_hourly_performance_factmany
qtree_daily_performance_factqtree_daily_performance_factmany
storage_node_daily_performance_factstorage_node_daily_performance_factmany
disk_hourly_performance_factdisk_hourly_performance_factmany
disk_daily_performance_factdisk_daily_performance_factmany
internal_volume_hourly_performance_factinternal_volume_hourly_performance_factmany
volume_daily_performance_factvolume_daily_performance_factmany
vmdk_daily_performance_factvmdk_daily_performance_factmany
host_vm_hourly_performance_facthost_vm_hourly_performance_factmany

disk_daily_performance_fact↑ top

Entity Set(s): disk_daily_performance_fact

FieldTypeNullable
tkPKInt32Yes
dateTkFK
date_dimension.tk
Int32Yes
diskTkFK
disk_dimension.tk
Int32Yes
storageTkFK
storage_dimension.tk
Int32Yes
storagePoolTkFK
storage_pool_dimension.tk
Int32Yes
readThroughputDoubleYes
writeThroughputDoubleYes
totalThroughputDoubleYes
totalThroughputMaxDoubleYes
readIopsDoubleYes
writeIopsDoubleYes
totalIopsDoubleYes
totalIopsMaxDoubleYes
readUtilizationDoubleYes
writeUtilizationDoubleYes
totalUtilizationDoubleYes
totalUtilizationMaxDoubleYes
accessedInt32Yes
timestampPKInt64Yes

Navigation Properties (Joins)

Nav PropertyRelated EntityCardinality / Join
storage_dimensionstorage_dimensionone
JOIN: storageTk = storage_dimension.tk
storage_pool_dimensionstorage_pool_dimensionone
JOIN: storagePoolTk = storage_pool_dimension.tk
date_dimensiondate_dimensionone
JOIN: dateTk = date_dimension.tk
disk_dimensiondisk_dimensionone
JOIN: diskTk = disk_dimension.tk

disk_dimension↑ top

Entity Set(s): disk_dimension

FieldTypeNullable
tkInt32Yes
identifierStringYes
storageIdentifierStringYes
nameStringYes
speedInt32Yes
locationStringYes
roleStringYes
vendorStringYes
modelStringYes
typeStringYes
diskGroupStringYes
statusStringYes
serialNumberStringYes
urlStringYes
idInt32Yes
latestStringYes
dateTkInt32Yes

Navigation Properties (Joins)

Nav PropertyRelated EntityCardinality / Join
disk_hourly_performance_factdisk_hourly_performance_factmany
disk_daily_performance_factdisk_daily_performance_factmany

disk_hourly_performance_fact↑ top

Entity Set(s): disk_hourly_performance_fact

FieldTypeNullable
tkPKInt64Yes
timeTkFK
time_dimension.tk
Int32Yes
dateTkFK
date_dimension.tk
Int32Yes
diskTkFK
disk_dimension.tk
Int32Yes
storageTkFK
storage_dimension.tk
Int32Yes
storagePoolTkFK
storage_pool_dimension.tk
Int32Yes
readThroughputDoubleYes
writeThroughputDoubleYes
totalThroughputDoubleYes
totalThroughputMaxDoubleYes
readIopsDoubleYes
writeIopsDoubleYes
totalIopsDoubleYes
totalIopsMaxDoubleYes
readUtilizationDoubleYes
writeUtilizationDoubleYes
totalUtilizationDoubleYes
totalUtilizationMaxDoubleYes
accessedInt32Yes
timestampPKInt64Yes

Navigation Properties (Joins)

Nav PropertyRelated EntityCardinality / Join
storage_dimensionstorage_dimensionone
JOIN: storageTk = storage_dimension.tk
time_dimensiontime_dimensionone
JOIN: timeTk = time_dimension.tk
storage_pool_dimensionstorage_pool_dimensionone
JOIN: storagePoolTk = storage_pool_dimension.tk
date_dimensiondate_dimensionone
JOIN: dateTk = date_dimension.tk
disk_dimensiondisk_dimensionone
JOIN: diskTk = disk_dimension.tk

fabric_dimension↑ top

Entity Set(s): fabric_dimension

FieldTypeNullable
tkInt32Yes
identifierStringYes
wwnStringYes
nameStringYes
vsanEnabledStringYes
vsanIdStringYes
zoningEnabledStringYes
urlStringYes
idInt32Yes
latestStringYes
dateTkInt32Yes

Navigation Properties (Joins)

Nav PropertyRelated EntityCardinality / Join
switch_performance_for_port_hourly_factswitch_performance_for_port_hourly_factmany

host_dimension↑ top

Entity Set(s): host_dimension

FieldTypeNullable
tkInt32Yes
nameStringYes
identifierStringYes
ipStringYes
osStringYes
modelStringYes
manufacturerStringYes
urlStringYes
idInt32Yes
latestStringYes
dateTkInt32Yes
dataCenterStringYes

Navigation Properties (Joins)

Nav PropertyRelated EntityCardinality / Join
host_vm_daily_performance_facthost_vm_daily_performance_factmany
vmdk_hourly_performance_factvmdk_hourly_performance_factmany
volume_hourly_performance_factvolume_hourly_performance_factmany
vm_hourly_performance_factvm_hourly_performance_factmany
host_volume_hourly_performance_facthost_volume_hourly_performance_factmany
vm_daily_performance_factvm_daily_performance_factmany
switch_performance_for_host_hourly_factswitch_performance_for_host_hourly_factmany
volume_daily_performance_factvolume_daily_performance_factmany
vmdk_daily_performance_factvmdk_daily_performance_factmany
host_vm_hourly_performance_facthost_vm_hourly_performance_factmany

host_group_bridge↑ top

Entity Set(s): host_group_bridge

FieldTypeNullable
hostGroupTkInt32Yes
hostTkInt32Yes
isRepStringYes

host_group_dimension↑ top

Entity Set(s): host_group_dimension

FieldTypeNullable
tkInt32Yes
repHostStringYes
repHostTkInt32Yes
cardinalityInt32Yes
dateTkInt32Yes

Navigation Properties (Joins)

Nav PropertyRelated EntityCardinality / Join
volume_hourly_performance_factvolume_hourly_performance_factmany
host_volume_hourly_performance_facthost_volume_hourly_performance_factmany
volume_daily_performance_factvolume_daily_performance_factmany

host_vm_daily_performance_fact↑ top

Entity Set(s): host_vm_daily_performance_fact

FieldTypeNullable
tkPKInt32Yes
dateTkFK
date_dimension.tk
Int32Yes
hostTkFK
host_dimension.tk
Int32Yes
readIopsDoubleYes
writeIopsDoubleYes
totalIopsDoubleYes
totalIopsMaxDoubleYes
readThroughputDoubleYes
writeThroughputDoubleYes
totalThroughputDoubleYes
totalThroughputMaxDoubleYes
readResponseTimeDoubleYes
writeResponseTimeDoubleYes
totalResponseTimeDoubleYes
totalResponseTimeMaxDoubleYes
ipReceiveThroughputDoubleYes
ipTransmitThroughputDoubleYes
ipTotalThroughputDoubleYes
ipTotalThroughputMaxDoubleYes
cpuUtilizationDoubleYes
maxOfAvgCpuUtilizationDoubleYes
memoryUtilizationDoubleYes
maxOfAvgMemoryUtilizationDoubleYes
swapInRateDoubleYes
maxOfAvgSwapInRateDoubleYes
swapOutRateDoubleYes
maxOfAvgSwapOutRateDoubleYes
swapTotalRateDoubleYes
swapTotalRateMaxDoubleYes
timestampPKInt64Yes

Navigation Properties (Joins)

Nav PropertyRelated EntityCardinality / Join
host_dimensionhost_dimensionone
JOIN: hostTk = host_dimension.tk
date_dimensiondate_dimensionone
JOIN: dateTk = date_dimension.tk

host_vm_hourly_performance_fact↑ top

Entity Set(s): host_vm_hourly_performance_fact

FieldTypeNullable
tkPKInt64Yes
timeTkFK
time_dimension.tk
Int32Yes
dateTkFK
date_dimension.tk
Int32Yes
hostTkFK
host_dimension.tk
Int32Yes
readIopsDoubleYes
writeIopsDoubleYes
totalIopsDoubleYes
totalIopsMaxDoubleYes
readThroughputDoubleYes
writeThroughputDoubleYes
totalThroughputDoubleYes
totalThroughputMaxDoubleYes
readResponseTimeDoubleYes
writeResponseTimeDoubleYes
totalResponseTimeDoubleYes
totalResponseTimeMaxDoubleYes
ipReceiveThroughputDoubleYes
ipTransmitThroughputDoubleYes
ipTotalThroughputDoubleYes
ipTotalThroughputMaxDoubleYes
cpuUtilizationDoubleYes
memoryUtilizationDoubleYes
swapInRateDoubleYes
swapOutRateDoubleYes
swapTotalRateDoubleYes
swapTotalRateMaxDoubleYes
timestampPKInt64Yes

Navigation Properties (Joins)

Nav PropertyRelated EntityCardinality / Join
time_dimensiontime_dimensionone
JOIN: timeTk = time_dimension.tk
host_dimensionhost_dimensionone
JOIN: hostTk = host_dimension.tk
date_dimensiondate_dimensionone
JOIN: dateTk = date_dimension.tk

host_volume_hourly_performance_fact↑ top

Entity Set(s): host_volume_hourly_performance_fact

FieldTypeNullable
tkPKInt64Yes
timeTkFK
time_dimension.tk
Int32Yes
dateTkFK
date_dimension.tk
Int32Yes
hostTkFK
host_dimension.tk
Int32Yes
hostGroupTkFK
host_group_dimension.tk
Int32Yes
tierTkFK
tier_dimension.tk
Int32Yes
serviceLevelTkFK
service_level_dimension.tk
Int32Yes
businessEntityTkFK
business_entity_dimension.tk
Int32Yes
readResponseTimeDoubleYes
writeResponseTimeDoubleYes
totalResponseTimeDoubleYes
totalResponseTimeMaxDoubleYes
readThroughputDoubleYes
writeThroughputDoubleYes
sumOfAveragesVolumeThroughputDoubleYes
maxOfMaxVolumeThroughputDoubleYes
sumOfMaxVolumeThroughputDoubleYes
readIopsDoubleYes
writeIopsDoubleYes
sumOfAveragesVolumeIopsDoubleYes
maxOfMaxVolumeIopsDoubleYes
sumOfMaxVolumeIopsDoubleYes
readCacheHitRatioDoubleYes
writeCacheHitRatioDoubleYes
totalCacheHitRatioDoubleYes
totalCacheHitRatioMaxDoubleYes
writePendingInt64Yes
readIoDensityDoubleYes
writeIoDensityDoubleYes
totalIoDensityDoubleYes
totalIoDensityMaxDoubleYes
compressionSavingsPercentDoubleYes
compressionSavingsSpaceDoubleYes
totalTimeToFullDoubleYes
confidenceIntervalTimeToFullDoubleYes

Navigation Properties (Joins)

Nav PropertyRelated EntityCardinality / Join
service_level_dimensionservice_level_dimensionone
JOIN: serviceLevelTk = service_level_dimension.tk
tier_dimensiontier_dimensionone
JOIN: tierTk = tier_dimension.tk
business_entity_dimensionbusiness_entity_dimensionone
JOIN: businessEntityTk = business_entity_dimension.tk
time_dimensiontime_dimensionone
JOIN: timeTk = time_dimension.tk
host_group_dimensionhost_group_dimensionone
JOIN: hostGroupTk = host_group_dimension.tk
host_dimensionhost_dimensionone
JOIN: hostTk = host_dimension.tk
date_dimensiondate_dimensionone
JOIN: dateTk = date_dimension.tk

internal_volume_daily_performance_fact↑ top

Entity Set(s): internal_volume_daily_performance_fact

FieldTypeNullable
tkPKInt32Yes
dateTkFK
date_dimension.tk
Int32Yes
internalVolumeTkFK
internal_volume_dimension.tk
Int32Yes
storageTkFK
storage_dimension.tk
Int32Yes
virtualStorageTkInt32Yes
storageNodeTkFK
storage_node_dimension.tk
Int32Yes
storagePoolTkFK
storage_pool_dimension.tk
Int32Yes
applicationTkFK
application_dimension.tk
Int32Yes
applicationGroupTkFK
application_group_dimension.tk
Int32Yes
tierTkFK
tier_dimension.tk
Int32Yes
serviceLevelTkFK
service_level_dimension.tk
Int32Yes
businessEntityTkFK
business_entity_dimension.tk
Int32Yes
k8sNamespaceTkFK
k8s_namespace_dimension.tk
Int32Yes
k8sNamespaceGroupTkFK
k8s_namespace_group_dimension.tk
Int32Yes
readResponseTimeDoubleYes
writeResponseTimeDoubleYes
totalResponseTimeDoubleYes
totalResponseTimeMaxDoubleYes
readThroughputDoubleYes
writeThroughputDoubleYes
totalThroughputDoubleYes
totalThroughputMaxDoubleYes
readIopsDoubleYes
writeIopsDoubleYes
totalIopsDoubleYes
totalIopsMaxDoubleYes
writePendingInt64Yes
readIoDensityDoubleYes
writeIoDensityDoubleYes
totalIoDensityDoubleYes
totalIoDensityMaxDoubleYes
objectCountDoubleYes
filesystemCapacityPhysicalUsedDoubleYes
filesystemCapacityPhysicalAvailableDoubleYes
filesystemCapacityLogicalUsedDoubleYes
totalTimeToFullDoubleYes
confidenceIntervalTimeToFullDoubleYes
accessedInt32Yes
frontendStringYes
backendStringYes
timestampPKInt64Yes

Navigation Properties (Joins)

Nav PropertyRelated EntityCardinality / Join
service_level_dimensionservice_level_dimensionone
JOIN: serviceLevelTk = service_level_dimension.tk
internal_volume_dimensioninternal_volume_dimensionone
JOIN: internalVolumeTk = internal_volume_dimension.tk
storage_node_dimensionstorage_node_dimensionone
JOIN: storageNodeTk = storage_node_dimension.tk
storage_dimensionstorage_dimensionone
JOIN: storageTk = storage_dimension.tk
tier_dimensiontier_dimensionone
JOIN: tierTk = tier_dimension.tk
business_entity_dimensionbusiness_entity_dimensionone
JOIN: businessEntityTk = business_entity_dimension.tk
application_dimensionapplication_dimensionone
JOIN: applicationTk = application_dimension.tk
storage_pool_dimensionstorage_pool_dimensionone
JOIN: storagePoolTk = storage_pool_dimension.tk
date_dimensiondate_dimensionone
JOIN: dateTk = date_dimension.tk
k8s_namespace_group_dimensionk8s_namespace_group_dimensionone
JOIN: k8sNamespaceGroupTk = k8s_namespace_group_dimension.tk
application_group_dimensionapplication_group_dimensionone
JOIN: applicationGroupTk = application_group_dimension.tk
k8s_namespace_dimensionk8s_namespace_dimensionone
JOIN: k8sNamespaceTk = k8s_namespace_dimension.tk

internal_volume_dimension↑ top

Entity Set(s): internal_volume_dimension

FieldTypeNullable
tkInt32Yes
nameStringYes
identifierStringYes
storagePoolIdentifierStringYes
storageNameStringYes
storageIPStringYes
typeStringYes
virtualStorageStringYes
spaceGuaranteeStringYes
thinProvisioningSupportedStringYes
thinProvisionedStringYes
uuidStringYes
flexGroupIdentifierStringYes
urlStringYes
idInt32Yes
latestStringYes
dateTkInt32Yes

Navigation Properties (Joins)

Nav PropertyRelated EntityCardinality / Join
qtree_hourly_performance_factqtree_hourly_performance_factmany
qtree_daily_performance_factqtree_daily_performance_factmany
internal_volume_daily_performance_factinternal_volume_daily_performance_factmany
internal_volume_hourly_performance_factinternal_volume_hourly_performance_factmany

internal_volume_hourly_performance_fact↑ top

Entity Set(s): internal_volume_hourly_performance_fact

FieldTypeNullable
tkPKInt64Yes
timeTkFK
time_dimension.tk
Int32Yes
dateTkFK
date_dimension.tk
Int32Yes
internalVolumeTkFK
internal_volume_dimension.tk
Int32Yes
storageTkFK
storage_dimension.tk
Int32Yes
virtualStorageTkInt32Yes
storageNodeTkFK
storage_node_dimension.tk
Int32Yes
storagePoolTkFK
storage_pool_dimension.tk
Int32Yes
applicationTkFK
application_dimension.tk
Int32Yes
applicationGroupTkFK
application_group_dimension.tk
Int32Yes
tierTkFK
tier_dimension.tk
Int32Yes
serviceLevelTkFK
service_level_dimension.tk
Int32Yes
businessEntityTkFK
business_entity_dimension.tk
Int32Yes
k8sNamespaceTkFK
k8s_namespace_dimension.tk
Int32Yes
k8sNamespaceGroupTkFK
k8s_namespace_group_dimension.tk
Int32Yes
readResponseTimeDoubleYes
writeResponseTimeDoubleYes
totalResponseTimeDoubleYes
totalResponseTimeMaxDoubleYes
readThroughputDoubleYes
writeThroughputDoubleYes
totalThroughputDoubleYes
totalThroughputMaxDoubleYes
readIopsDoubleYes
writeIopsDoubleYes
totalIopsDoubleYes
totalIopsMaxDoubleYes
writePendingInt64Yes
readIoDensityDoubleYes
writeIoDensityDoubleYes
totalIoDensityDoubleYes
totalIoDensityMaxDoubleYes
objectCountDoubleYes
filesystemCapacityPhysicalUsedDoubleYes
filesystemCapacityPhysicalAvailableDoubleYes
filesystemCapacityLogicalUsedDoubleYes
totalTimeToFullDoubleYes
confidenceIntervalTimeToFullDoubleYes
accessedInt32Yes
frontendStringYes
backendStringYes
timestampPKInt64Yes

Navigation Properties (Joins)

Nav PropertyRelated EntityCardinality / Join
internal_volume_dimensioninternal_volume_dimensionone
JOIN: internalVolumeTk = internal_volume_dimension.tk
storage_node_dimensionstorage_node_dimensionone
JOIN: storageNodeTk = storage_node_dimension.tk
storage_dimensionstorage_dimensionone
JOIN: storageTk = storage_dimension.tk
business_entity_dimensionbusiness_entity_dimensionone
JOIN: businessEntityTk = business_entity_dimension.tk
k8s_namespace_group_dimensionk8s_namespace_group_dimensionone
JOIN: k8sNamespaceGroupTk = k8s_namespace_group_dimension.tk
application_group_dimensionapplication_group_dimensionone
JOIN: applicationGroupTk = application_group_dimension.tk
k8s_namespace_dimensionk8s_namespace_dimensionone
JOIN: k8sNamespaceTk = k8s_namespace_dimension.tk
service_level_dimensionservice_level_dimensionone
JOIN: serviceLevelTk = service_level_dimension.tk
tier_dimensiontier_dimensionone
JOIN: tierTk = tier_dimension.tk
application_dimensionapplication_dimensionone
JOIN: applicationTk = application_dimension.tk
time_dimensiontime_dimensionone
JOIN: timeTk = time_dimension.tk
storage_pool_dimensionstorage_pool_dimensionone
JOIN: storagePoolTk = storage_pool_dimension.tk
date_dimensiondate_dimensionone
JOIN: dateTk = date_dimension.tk

k8s_cluster_daily_metrics_fact↑ top

Entity Set(s): k8s_cluster_daily_metrics_fact

FieldTypeNullable
tkPKInt64Yes
dateTkInt32Yes
clusterTkInt32Yes
allocatableCpuSaturationDoubleYes
capacityCpuSaturationDoubleYes
allocatableMemorySaturationDoubleYes
capacityMemorySaturationDoubleYes
allocatableCpuCoresDoubleYes
capacityCpuCoresDoubleYes
usageCpuCoresDoubleYes
requestsCpuCoresDoubleYes
limitsCpuCoresDoubleYes
allocatableMemoryBytesDoubleYes
capacityMemoryBytesDoubleYes
limitsMemoryBytesDoubleYes
requestsMemoryBytesDoubleYes
usageMemoryBytesDoubleYes
timestampPKInt64Yes

k8s_cluster_dimension↑ top

Entity Set(s): k8s_cluster_dimension

FieldTypeNullable
tkInt32Yes
identifierStringYes
nameStringYes
idInt32Yes
latestStringYes
dateTkInt32Yes

k8s_cluster_hourly_metrics_fact↑ top

Entity Set(s): k8s_cluster_hourly_metrics_fact

FieldTypeNullable
tkPKInt64Yes
timeTkInt32Yes
dateTkInt32Yes
clusterTkInt32Yes
allocatableCpuSaturationDoubleYes
capacityCpuSaturationDoubleYes
allocatableMemorySaturationDoubleYes
capacityMemorySaturationDoubleYes
allocatableCpuCoresDoubleYes
capacityCpuCoresDoubleYes
usageCpuCoresDoubleYes
requestsCpuCoresDoubleYes
limitsCpuCoresDoubleYes
allocatableMemoryBytesDoubleYes
capacityMemoryBytesDoubleYes
limitsMemoryBytesDoubleYes
requestsMemoryBytesDoubleYes
usageMemoryBytesDoubleYes
timestampPKInt64Yes

k8s_namespace_daily_metrics_fact↑ top

Entity Set(s): k8s_namespace_daily_metrics_fact

FieldTypeNullable
tkPKInt64Yes
dateTkInt32Yes
namespaceTkInt32Yes
clusterTkInt32Yes
cpuHardLimitDoubleYes
cpuUsedLimitDoubleYes
cpuHardRequestDoubleYes
cpuUsedRequestDoubleYes
memoryHardLimitDoubleYes
memoryUsedLimitDoubleYes
memoryHardRequestDoubleYes
memoryUsedRequestDoubleYes
timestampPKInt64Yes

k8s_namespace_dimension↑ top

Entity Set(s): k8s_namespace_dimension

FieldTypeNullable
tkInt32Yes
identifierStringYes
nameStringYes
clusterNameStringYes
idInt32Yes
latestStringYes
dateTkInt32Yes

Navigation Properties (Joins)

Nav PropertyRelated EntityCardinality / Join
qtree_hourly_performance_factqtree_hourly_performance_factmany
volume_hourly_performance_factvolume_hourly_performance_factmany
qtree_daily_performance_factqtree_daily_performance_factmany
internal_volume_daily_performance_factinternal_volume_daily_performance_factmany
internal_volume_hourly_performance_factinternal_volume_hourly_performance_factmany
volume_daily_performance_factvolume_daily_performance_factmany

k8s_namespace_group_bridge↑ top

Entity Set(s): k8s_namespace_group_bridge

FieldTypeNullable
k8sNamespaceGroupTkInt32Yes
k8sNamespaceTkInt32Yes
isRepStringYes

k8s_namespace_group_dimension↑ top

Entity Set(s): k8s_namespace_group_dimension

FieldTypeNullable
tkInt32Yes
repK8sNamespaceStringYes
repK8sNamespaceTkInt32Yes
cardinalityInt32Yes
dateTkInt32Yes

Navigation Properties (Joins)

Nav PropertyRelated EntityCardinality / Join
qtree_hourly_performance_factqtree_hourly_performance_factmany
volume_hourly_performance_factvolume_hourly_performance_factmany
qtree_daily_performance_factqtree_daily_performance_factmany
internal_volume_daily_performance_factinternal_volume_daily_performance_factmany
internal_volume_hourly_performance_factinternal_volume_hourly_performance_factmany
volume_daily_performance_factvolume_daily_performance_factmany

k8s_namespace_hourly_metrics_fact↑ top

Entity Set(s): k8s_namespace_hourly_metrics_fact

FieldTypeNullable
tkPKInt64Yes
timeTkInt32Yes
dateTkInt32Yes
namespaceTkInt32Yes
clusterTkInt32Yes
cpuHardLimitDoubleYes
cpuUsedLimitDoubleYes
cpuHardRequestDoubleYes
cpuUsedRequestDoubleYes
memoryHardLimitDoubleYes
memoryUsedLimitDoubleYes
memoryHardRequestDoubleYes
memoryUsedRequestDoubleYes
timestampPKInt64Yes

k8s_node_daily_metrics_fact↑ top

Entity Set(s): k8s_node_daily_metrics_fact

FieldTypeNullable
tkPKInt64Yes
dateTkInt32Yes
nodeTkInt32Yes
clusterTkInt32Yes
vmTkInt32Yes
allocatableCpuSaturationDoubleYes
capacityCpuSaturationDoubleYes
allocatableMemorySaturationDoubleYes
capacityMemorySaturationDoubleYes
allocatableMemoryBytesDoubleYes
capacityMemoryBytesDoubleYes
memoryUsageBytesDoubleYes
cpuUsageNanocoresDoubleYes
allocatableCpuDoubleYes
capacityCpuDoubleYes
timestampPKInt64Yes

k8s_node_dimension↑ top

Entity Set(s): k8s_node_dimension

FieldTypeNullable
tkInt32Yes
identifierStringYes
nameStringYes
clusterNameStringYes
internalIpStringYes
osImageStringYes
idInt32Yes
latestStringYes
dateTkInt32Yes

Navigation Properties (Joins)

Nav PropertyRelated EntityCardinality / Join
vm_hourly_performance_factvm_hourly_performance_factmany
vm_daily_performance_factvm_daily_performance_factmany

k8s_node_hourly_metrics_fact↑ top

Entity Set(s): k8s_node_hourly_metrics_fact

FieldTypeNullable
tkPKInt64Yes
timeTkInt32Yes
dateTkInt32Yes
nodeTkInt32Yes
clusterTkInt32Yes
vmTkInt32Yes
allocatableCpuSaturationDoubleYes
capacityCpuSaturationDoubleYes
allocatableMemorySaturationDoubleYes
capacityMemorySaturationDoubleYes
allocatableMemoryBytesDoubleYes
capacityMemoryBytesDoubleYes
memoryUsageBytesDoubleYes
cpuUsageNanocoresDoubleYes
allocatableCpuDoubleYes
capacityCpuDoubleYes
timestampPKInt64Yes

k8s_pv_dimension↑ top

Entity Set(s): k8s_pv_dimension

FieldTypeNullable
tkInt32Yes
identifierStringYes
nameStringYes
clusterNameStringYes
phaseStringYes
pvcNameStringYes
storageClassStringYes
idInt32Yes
latestStringYes
dateTkInt32Yes

k8s_pvc_daily_metrics_fact↑ top

Entity Set(s): k8s_pvc_daily_metrics_fact

FieldTypeNullable
tkPKInt64Yes
dateTkInt32Yes
pvcTkInt32Yes
clusterTkInt32Yes
namespaceTkInt32Yes
pvTkInt32Yes
readIopsDoubleYes
writeIopsDoubleYes
totalIopsDoubleYes
readThroughputDoubleYes
writeThroughputDoubleYes
totalThroughputDoubleYes
readLatencyDoubleYes
writeLatencyDoubleYes
totalLatencyDoubleYes
timestampPKInt64Yes

k8s_pvc_dimension↑ top

Entity Set(s): k8s_pvc_dimension

FieldTypeNullable
tkInt32Yes
identifierStringYes
nameStringYes
clusterNameStringYes
namespaceNameStringYes
pvNameStringYes
phaseStringYes
idInt32Yes
latestStringYes
dateTkInt32Yes

k8s_pvc_hourly_metrics_fact↑ top

Entity Set(s): k8s_pvc_hourly_metrics_fact

FieldTypeNullable
tkPKInt64Yes
timeTkInt32Yes
dateTkInt32Yes
pvcTkInt32Yes
clusterTkInt32Yes
namespaceTkInt32Yes
pvTkInt32Yes
readIopsDoubleYes
writeIopsDoubleYes
totalIopsDoubleYes
readThroughputDoubleYes
writeThroughputDoubleYes
totalThroughputDoubleYes
readLatencyDoubleYes
writeLatencyDoubleYes
totalLatencyDoubleYes
timestampPKInt64Yes

k8s_workload_daily_metrics_fact↑ top

Entity Set(s): k8s_workload_daily_metrics_fact

FieldTypeNullable
tkPKInt64Yes
dateTkInt32Yes
workloadTkInt32Yes
clusterTkInt32Yes
namespaceTkInt32Yes
usageCpuCoresDoubleYes
requestCpuCoresDoubleYes
limitCpuCoresDoubleYes
usageMemoryBytesDoubleYes
requestMemoryBytesDoubleYes
limitMemoryBytesDoubleYes
runningPodCountInt32Yes
desiredPodCountInt32Yes
timestampPKInt64Yes

k8s_workload_dimension↑ top

Entity Set(s): k8s_workload_dimension

FieldTypeNullable
tkInt32Yes
identifierStringYes
nameStringYes
clusterNameStringYes
namespaceNameStringYes
typeStringYes
idInt32Yes
latestStringYes
dateTkInt32Yes

k8s_workload_hourly_metrics_fact↑ top

Entity Set(s): k8s_workload_hourly_metrics_fact

FieldTypeNullable
tkPKInt64Yes
timeTkInt32Yes
dateTkInt32Yes
workloadTkInt32Yes
clusterTkInt32Yes
namespaceTkInt32Yes
usageCpuCoresDoubleYes
requestCpuCoresDoubleYes
limitCpuCoresDoubleYes
usageMemoryBytesDoubleYes
requestMemoryBytesDoubleYes
limitMemoryBytesDoubleYes
runningPodCountInt32Yes
desiredPodCountInt32Yes
timestampPKInt64Yes

port_dimension↑ top

Entity Set(s): port_dimension

FieldTypeNullable
tkInt32Yes
wwnStringYes
nameStringYes
gbicTypeStringYes
typeStringYes
speedStringYes
isGeneratedStringYes
urlStringYes
idInt32Yes
latestStringYes
dateTkInt32Yes

Navigation Properties (Joins)

Nav PropertyRelated EntityCardinality / Join
switch_performance_for_port_hourly_factswitch_performance_for_port_hourly_factmany

qtree_daily_performance_fact↑ top

Entity Set(s): qtree_daily_performance_fact

FieldTypeNullable
tkPKInt32Yes
dateTkFK
date_dimension.tk
Int32Yes
qtreeTkFK
qtree_dimension.tk
Int32Yes
storageTkFK
storage_dimension.tk
Int32Yes
storagePoolTkFK
storage_pool_dimension.tk
Int32Yes
internalVolumeTkFK
internal_volume_dimension.tk
Int32Yes
virtualStorageTkInt32Yes
tierTkFK
tier_dimension.tk
Int32Yes
serviceLevelTkFK
service_level_dimension.tk
Int32Yes
applicationTkFK
application_dimension.tk
Int32Yes
applicationGroupTkFK
application_group_dimension.tk
Int32Yes
businessEntityTkFK
business_entity_dimension.tk
Int32Yes
k8sNamespaceTkFK
k8s_namespace_dimension.tk
Int32Yes
k8sNamespaceGroupTkFK
k8s_namespace_group_dimension.tk
Int32Yes
totalIopsDoubleYes
totalIopsMaxDoubleYes
timestampPKInt64Yes

Navigation Properties (Joins)

Nav PropertyRelated EntityCardinality / Join
service_level_dimensionservice_level_dimensionone
JOIN: serviceLevelTk = service_level_dimension.tk
internal_volume_dimensioninternal_volume_dimensionone
JOIN: internalVolumeTk = internal_volume_dimension.tk
storage_dimensionstorage_dimensionone
JOIN: storageTk = storage_dimension.tk
tier_dimensiontier_dimensionone
JOIN: tierTk = tier_dimension.tk
business_entity_dimensionbusiness_entity_dimensionone
JOIN: businessEntityTk = business_entity_dimension.tk
application_dimensionapplication_dimensionone
JOIN: applicationTk = application_dimension.tk
qtree_dimensionqtree_dimensionone
JOIN: qtreeTk = qtree_dimension.tk
storage_pool_dimensionstorage_pool_dimensionone
JOIN: storagePoolTk = storage_pool_dimension.tk
date_dimensiondate_dimensionone
JOIN: dateTk = date_dimension.tk
k8s_namespace_group_dimensionk8s_namespace_group_dimensionone
JOIN: k8sNamespaceGroupTk = k8s_namespace_group_dimension.tk
application_group_dimensionapplication_group_dimensionone
JOIN: applicationGroupTk = application_group_dimension.tk
k8s_namespace_dimensionk8s_namespace_dimensionone
JOIN: k8sNamespaceTk = k8s_namespace_dimension.tk

qtree_dimension↑ top

Entity Set(s): qtree_dimension

FieldTypeNullable
tkInt32Yes
nameStringYes
identifierStringYes
storageIdentifierStringYes
typeStringYes
urlStringYes
idInt32Yes
latestStringYes
dateTkInt32Yes

Navigation Properties (Joins)

Nav PropertyRelated EntityCardinality / Join
qtree_hourly_performance_factqtree_hourly_performance_factmany
qtree_daily_performance_factqtree_daily_performance_factmany

qtree_hourly_performance_fact↑ top

Entity Set(s): qtree_hourly_performance_fact

FieldTypeNullable
tkPKInt64Yes
timeTkFK
time_dimension.tk
Int32Yes
dateTkFK
date_dimension.tk
Int32Yes
qtreeTkFK
qtree_dimension.tk
Int32Yes
storageTkFK
storage_dimension.tk
Int32Yes
storagePoolTkFK
storage_pool_dimension.tk
Int32Yes
internalVolumeTkFK
internal_volume_dimension.tk
Int32Yes
virtualStorageTkInt32Yes
tierTkFK
tier_dimension.tk
Int32Yes
serviceLevelTkFK
service_level_dimension.tk
Int32Yes
applicationTkFK
application_dimension.tk
Int32Yes
applicationGroupTkFK
application_group_dimension.tk
Int32Yes
businessEntityTkFK
business_entity_dimension.tk
Int32Yes
k8sNamespaceTkFK
k8s_namespace_dimension.tk
Int32Yes
k8sNamespaceGroupTkFK
k8s_namespace_group_dimension.tk
Int32Yes
totalIopsDoubleYes
totalIopsMaxDoubleYes
timestampPKInt64Yes

Navigation Properties (Joins)

Nav PropertyRelated EntityCardinality / Join
internal_volume_dimensioninternal_volume_dimensionone
JOIN: internalVolumeTk = internal_volume_dimension.tk
storage_dimensionstorage_dimensionone
JOIN: storageTk = storage_dimension.tk
business_entity_dimensionbusiness_entity_dimensionone
JOIN: businessEntityTk = business_entity_dimension.tk
k8s_namespace_group_dimensionk8s_namespace_group_dimensionone
JOIN: k8sNamespaceGroupTk = k8s_namespace_group_dimension.tk
application_group_dimensionapplication_group_dimensionone
JOIN: applicationGroupTk = application_group_dimension.tk
k8s_namespace_dimensionk8s_namespace_dimensionone
JOIN: k8sNamespaceTk = k8s_namespace_dimension.tk
service_level_dimensionservice_level_dimensionone
JOIN: serviceLevelTk = service_level_dimension.tk
tier_dimensiontier_dimensionone
JOIN: tierTk = tier_dimension.tk
application_dimensionapplication_dimensionone
JOIN: applicationTk = application_dimension.tk
time_dimensiontime_dimensionone
JOIN: timeTk = time_dimension.tk
qtree_dimensionqtree_dimensionone
JOIN: qtreeTk = qtree_dimension.tk
storage_pool_dimensionstorage_pool_dimensionone
JOIN: storagePoolTk = storage_pool_dimension.tk
date_dimensiondate_dimensionone
JOIN: dateTk = date_dimension.tk

service_level_dimension↑ top

Entity Set(s): service_level_dimension

FieldTypeNullable
tkInt32Yes
nameStringYes
sequenceInt32Yes
costDoubleYes
idInt32Yes
latestStringYes
dateTkInt32Yes

Navigation Properties (Joins)

Nav PropertyRelated EntityCardinality / Join
qtree_hourly_performance_factqtree_hourly_performance_factmany
vmdk_hourly_performance_factvmdk_hourly_performance_factmany
volume_hourly_performance_factvolume_hourly_performance_factmany
application_volume_hourly_performance_factapplication_volume_hourly_performance_factmany
qtree_daily_performance_factqtree_daily_performance_factmany
host_volume_hourly_performance_facthost_volume_hourly_performance_factmany
internal_volume_daily_performance_factinternal_volume_daily_performance_factmany
internal_volume_hourly_performance_factinternal_volume_hourly_performance_factmany
volume_daily_performance_factvolume_daily_performance_factmany
vmdk_daily_performance_factvmdk_daily_performance_factmany

storage_dimension↑ top

Entity Set(s): storage_dimension

FieldTypeNullable
tkInt32Yes
nameStringYes
identifierStringYes
ipStringYes
modelStringYes
manufacturerStringYes
serialNumberStringYes
microcodeVersionStringYes
familyStringYes
urlStringYes
idInt32Yes
latestStringYes
dateTkInt32Yes
dataCenterStringYes

Navigation Properties (Joins)

Nav PropertyRelated EntityCardinality / Join
internal_volume_daily_performance_factinternal_volume_daily_performance_factmany
switch_performance_for_storage_hourly_factswitch_performance_for_storage_hourly_factmany
storage_node_hourly_performance_factstorage_node_hourly_performance_factmany
qtree_hourly_performance_factqtree_hourly_performance_factmany
vmdk_hourly_performance_factvmdk_hourly_performance_factmany
volume_hourly_performance_factvolume_hourly_performance_factmany
qtree_daily_performance_factqtree_daily_performance_factmany
storage_node_daily_performance_factstorage_node_daily_performance_factmany
disk_hourly_performance_factdisk_hourly_performance_factmany
disk_daily_performance_factdisk_daily_performance_factmany
internal_volume_hourly_performance_factinternal_volume_hourly_performance_factmany
volume_daily_performance_factvolume_daily_performance_factmany
vmdk_daily_performance_factvmdk_daily_performance_factmany

storage_node_daily_performance_fact↑ top

Entity Set(s): storage_node_daily_performance_fact

FieldTypeNullable
tkPKInt32Yes
dateTkFK
date_dimension.tk
Int32Yes
storageTkFK
storage_dimension.tk
Int32Yes
storageNodeTkFK
storage_node_dimension.tk
Int32Yes
tierTkFK
tier_dimension.tk
Int32Yes
readResponseTimeDoubleYes
writeResponseTimeDoubleYes
totalResponseTimeDoubleYes
totalResponseTimeMaxDoubleYes
readThroughputDoubleYes
writeThroughputDoubleYes
totalThroughputDoubleYes
totalThroughputMaxDoubleYes
readIopsDoubleYes
writeIopsDoubleYes
totalIopsDoubleYes
totalIopsMaxDoubleYes
diskReadsReplacedDoubleYes
cacheHitRatioDoubleYes
utilizationDoubleYes
utilizationMaxDoubleYes
readFileSystemIopsDoubleYes
writeFileSystemIopsDoubleYes
readFileSystemThroughputDoubleYes
writeFileSystemThroughputDoubleYes
portUtilizationDoubleYes
portErrorsInt64Yes
portTrafficDoubleYes
accessedInt32Yes
timestampPKInt64Yes

Navigation Properties (Joins)

Nav PropertyRelated EntityCardinality / Join
storage_node_dimensionstorage_node_dimensionone
JOIN: storageNodeTk = storage_node_dimension.tk
storage_dimensionstorage_dimensionone
JOIN: storageTk = storage_dimension.tk
tier_dimensiontier_dimensionone
JOIN: tierTk = tier_dimension.tk
date_dimensiondate_dimensionone
JOIN: dateTk = date_dimension.tk

storage_node_dimension↑ top

Entity Set(s): storage_node_dimension

FieldTypeNullable
tkInt32Yes
nameStringYes
identifierStringYes
versionStringYes
modelStringYes
serialNumberStringYes
siteNameStringYes
urlStringYes
idInt32Yes
latestStringYes
dateTkInt32Yes

Navigation Properties (Joins)

Nav PropertyRelated EntityCardinality / Join
volume_hourly_performance_factvolume_hourly_performance_factmany
storage_node_daily_performance_factstorage_node_daily_performance_factmany
internal_volume_daily_performance_factinternal_volume_daily_performance_factmany
internal_volume_hourly_performance_factinternal_volume_hourly_performance_factmany
volume_daily_performance_factvolume_daily_performance_factmany
storage_node_hourly_performance_factstorage_node_hourly_performance_factmany

storage_node_hourly_performance_fact↑ top

Entity Set(s): storage_node_hourly_performance_fact

FieldTypeNullable
tkPKInt32Yes
timeTkFK
time_dimension.tk
Int32Yes
dateTkFK
date_dimension.tk
Int32Yes
storageTkFK
storage_dimension.tk
Int32Yes
storageNodeTkFK
storage_node_dimension.tk
Int32Yes
tierTkFK
tier_dimension.tk
Int32Yes
readResponseTimeDoubleYes
writeResponseTimeDoubleYes
totalResponseTimeDoubleYes
totalResponseTimeMaxDoubleYes
readThroughputDoubleYes
writeThroughputDoubleYes
totalThroughputDoubleYes
totalThroughputMaxDoubleYes
readIopsDoubleYes
writeIopsDoubleYes
totalIopsDoubleYes
totalIopsMaxDoubleYes
diskReadsReplacedDoubleYes
cacheHitRatioDoubleYes
utilizationDoubleYes
utilizationMaxDoubleYes
readFileSystemIopsDoubleYes
writeFileSystemIopsDoubleYes
readFileSystemThroughputDoubleYes
writeFileSystemThroughputDoubleYes
portUtilizationDoubleYes
portErrorsInt64Yes
portTrafficDoubleYes
accessedInt32Yes
timestampPKInt64Yes

Navigation Properties (Joins)

Nav PropertyRelated EntityCardinality / Join
storage_node_dimensionstorage_node_dimensionone
JOIN: storageNodeTk = storage_node_dimension.tk
storage_dimensionstorage_dimensionone
JOIN: storageTk = storage_dimension.tk
tier_dimensiontier_dimensionone
JOIN: tierTk = tier_dimension.tk
time_dimensiontime_dimensionone
JOIN: timeTk = time_dimension.tk
date_dimensiondate_dimensionone
JOIN: dateTk = date_dimension.tk

storage_pool_dimension↑ top

Entity Set(s): storage_pool_dimension

FieldTypeNullable
tkInt32Yes
identifierStringYes
nameStringYes
storageNameStringYes
storageIPStringYes
typeStringYes
redundancyStringYes
thinProvisioningSupportedStringYes
isVirtualStringYes
usesFlashPoolsStringYes
urlStringYes
idInt32Yes
latestStringYes
dateTkInt32Yes

Navigation Properties (Joins)

Nav PropertyRelated EntityCardinality / Join
qtree_hourly_performance_factqtree_hourly_performance_factmany
volume_hourly_performance_factvolume_hourly_performance_factmany
qtree_daily_performance_factqtree_daily_performance_factmany
disk_hourly_performance_factdisk_hourly_performance_factmany
disk_daily_performance_factdisk_daily_performance_factmany
internal_volume_daily_performance_factinternal_volume_daily_performance_factmany
internal_volume_hourly_performance_factinternal_volume_hourly_performance_factmany
volume_daily_performance_factvolume_daily_performance_factmany

switch_dimension↑ top

Entity Set(s): switch_dimension

FieldTypeNullable
tkInt32Yes
wwnStringYes
nameStringYes
identifierStringYes
ipStringYes
modelStringYes
manufacturerStringYes
firmwareStringYes
serialNumberStringYes
npvStringYes
isGeneratedStringYes
typeStringYes
urlStringYes
idInt32Yes
latestStringYes
dateTkInt32Yes
dataCenterStringYes
switchLevelStringYes

Navigation Properties (Joins)

Nav PropertyRelated EntityCardinality / Join
switch_performance_for_port_hourly_factswitch_performance_for_port_hourly_factmany

switch_performance_for_host_hourly_fact↑ top

Entity Set(s): switch_performance_for_host_hourly_fact

FieldTypeNullable
tkPKInt64Yes
timeTkFK
time_dimension.tk
Int32Yes
dateTkFK
date_dimension.tk
Int32Yes
hostTkFK
host_dimension.tk
Int32Yes
applicationTkFK
application_dimension.tk
Int32Yes
applicationGroupTkFK
application_group_dimension.tk
Int32Yes
businessEntityTkFK
business_entity_dimension.tk
Int32Yes
rxTrafficDoubleYes
txTrafficDoubleYes
totalTrafficDoubleYes
errorRateFlagStringYes
crcErrorRateFlagStringYes
syncLossCountInt64Yes
signalLossCountInt64Yes
class3DiscardCountInt64Yes
frameTooShortCountInt64Yes
frameTooLongCountInt64Yes
bbCreditErrorCountInt64Yes
rxDoubleYes
txDoubleYes
rxMaxDoubleYes
txMaxDoubleYes
trafficUtilizationTotalDoubleYes
trafficUtilizationTotalMaxDoubleYes
rxLinkResetsInt64Yes
txLinkResetsInt64Yes
balanceIndexInt32Yes
weightedBalanceIndexInt32Yes
portSpeedInt32Yes
portCountInt32Yes
portErrorsLinkFailureInt64Yes
bbCreditZeroRxInt64Yes
bbCreditZeroTxInt64Yes
bbCreditZeroMsTxDoubleYes
bbCreditZeroTotalInt64Yes
trafficRateTxDoubleYes
trafficRateRxDoubleYes
trafficRateTotalDoubleYes
trafficFrameRateTxDoubleYes
trafficFrameRateRxDoubleYes
trafficFrameRateTotalDoubleYes
trafficFrameSizeAvgTxInt64Yes
trafficFrameSizeAvgRxInt64Yes
portErrorsTimeoutDiscardTxInt64Yes
portErrorsCrcInt64Yes
portErrorsEncInInt64Yes
portErrorsEncOutInt64Yes

Navigation Properties (Joins)

Nav PropertyRelated EntityCardinality / Join
business_entity_dimensionbusiness_entity_dimensionone
JOIN: businessEntityTk = business_entity_dimension.tk
application_dimensionapplication_dimensionone
JOIN: applicationTk = application_dimension.tk
time_dimensiontime_dimensionone
JOIN: timeTk = time_dimension.tk
host_dimensionhost_dimensionone
JOIN: hostTk = host_dimension.tk
date_dimensiondate_dimensionone
JOIN: dateTk = date_dimension.tk
application_group_dimensionapplication_group_dimensionone
JOIN: applicationGroupTk = application_group_dimension.tk

switch_performance_for_port_hourly_fact↑ top

Entity Set(s): switch_performance_for_port_hourly_fact

FieldTypeNullable
tkPKInt64Yes
timeTkFK
time_dimension.tk
Int32Yes
dateTkFK
date_dimension.tk
Int32Yes
portTkFK
port_dimension.tk
Int32Yes
switchTkFK
switch_dimension.tk
Int32Yes
fabricTkFK
fabric_dimension.tk
Int32Yes
connectedDeviceTkFK
connected_device_dimension.tk
Int32Yes
connectivityTypeStringYes
islStringYes
rxTrafficDoubleYes
txTrafficDoubleYes
totalTrafficDoubleYes
errorRateFlagStringYes
crcErrorRateFlagStringYes
syncLossCountInt64Yes
signalLossCountInt64Yes
class3DiscardCountInt64Yes
frameTooShortCountInt64Yes
frameTooLongCountInt64Yes
bbCreditErrorCountInt64Yes
rxDoubleYes
txDoubleYes
rxMaxDoubleYes
txMaxDoubleYes
trafficUtilizationTotalDoubleYes
trafficUtilizationTotalMaxDoubleYes
rxLinkResetsInt64Yes
txLinkResetsInt64Yes
portErrorsLinkFailureInt64Yes
bbCreditZeroRxInt64Yes
bbCreditZeroTxInt64Yes
bbCreditZeroMsTxDoubleYes
bbCreditZeroTotalInt64Yes
trafficRateTxDoubleYes
trafficRateRxDoubleYes
trafficRateTotalDoubleYes
trafficFrameRateTxDoubleYes
trafficFrameRateRxDoubleYes
trafficFrameRateTotalDoubleYes
trafficFrameSizeAvgTxInt64Yes
trafficFrameSizeAvgRxInt64Yes
portErrorsTimeoutDiscardTxInt64Yes
portErrorsCrcInt64Yes
portErrorsEncInInt64Yes
portErrorsEncOutInt64Yes
timestampPKInt64Yes

Navigation Properties (Joins)

Nav PropertyRelated EntityCardinality / Join
connected_device_dimensionconnected_device_dimensionone
JOIN: connectedDeviceTk = connected_device_dimension.tk
fabric_dimensionfabric_dimensionone
JOIN: fabricTk = fabric_dimension.tk
port_dimensionport_dimensionone
JOIN: portTk = port_dimension.tk
time_dimensiontime_dimensionone
JOIN: timeTk = time_dimension.tk
date_dimensiondate_dimensionone
JOIN: dateTk = date_dimension.tk
switch_dimensionswitch_dimensionone
JOIN: switchTk = switch_dimension.tk

switch_performance_for_storage_hourly_fact↑ top

Entity Set(s): switch_performance_for_storage_hourly_fact

FieldTypeNullable
tkPKInt64Yes
timeTkFK
time_dimension.tk
Int32Yes
dateTkFK
date_dimension.tk
Int32Yes
storageTkFK
storage_dimension.tk
Int32Yes
rxTrafficDoubleYes
txTrafficDoubleYes
totalTrafficDoubleYes
errorRateFlagStringYes
crcErrorRateFlagStringYes
syncLossCountInt64Yes
signalLossCountInt64Yes
class3DiscardCountInt64Yes
frameTooShortCountInt64Yes
frameTooLongCountInt64Yes
bbCreditErrorCountInt64Yes
rxDoubleYes
txDoubleYes
rxMaxDoubleYes
txMaxDoubleYes
trafficUtilizationTotalDoubleYes
trafficUtilizationTotalMaxDoubleYes
rxLinkResetsInt64Yes
txLinkResetsInt64Yes
balanceIndexInt32Yes
weightedBalanceIndexInt32Yes
portSpeedInt32Yes
portCountInt32Yes
portErrorsLinkFailureInt64Yes
bbCreditZeroRxInt64Yes
bbCreditZeroTxInt64Yes
bbCreditZeroMsTxDoubleYes
bbCreditZeroTotalInt64Yes
trafficRateTxDoubleYes
trafficRateRxDoubleYes
trafficRateTotalDoubleYes
trafficFrameRateTxDoubleYes
trafficFrameRateRxDoubleYes
trafficFrameRateTotalDoubleYes
trafficFrameSizeAvgTxInt64Yes
trafficFrameSizeAvgRxInt64Yes
portErrorsTimeoutDiscardTxInt64Yes
portErrorsCrcInt64Yes
portErrorsEncInInt64Yes
portErrorsEncOutInt64Yes

Navigation Properties (Joins)

Nav PropertyRelated EntityCardinality / Join
storage_dimensionstorage_dimensionone
JOIN: storageTk = storage_dimension.tk
time_dimensiontime_dimensionone
JOIN: timeTk = time_dimension.tk
date_dimensiondate_dimensionone
JOIN: dateTk = date_dimension.tk

switch_performance_for_tape_hourly_fact↑ top

Entity Set(s): switch_performance_for_tape_hourly_fact

FieldTypeNullable
tkPKInt64Yes
timeTkFK
time_dimension.tk
Int32Yes
dateTkFK
date_dimension.tk
Int32Yes
tapeTkFK
tape_dimension.tk
Int32Yes
rxTrafficDoubleYes
txTrafficDoubleYes
totalTrafficDoubleYes
errorRateFlagStringYes
crcErrorRateFlagStringYes
syncLossCountInt64Yes
signalLossCountInt64Yes
class3DiscardCountInt64Yes
frameTooShortCountInt64Yes
frameTooLongCountInt64Yes
bbCreditErrorCountInt64Yes
rxDoubleYes
txDoubleYes
rxMaxDoubleYes
txMaxDoubleYes
trafficUtilizationTotalDoubleYes
trafficUtilizationTotalMaxDoubleYes
rxLinkResetsInt64Yes
txLinkResetsInt64Yes
balanceIndexInt32Yes
weightedBalanceIndexInt32Yes
portSpeedInt32Yes
portCountInt32Yes
portErrorsLinkFailureInt64Yes
bbCreditZeroRxInt64Yes
bbCreditZeroTxInt64Yes
bbCreditZeroMsTxDoubleYes
bbCreditZeroTotalInt64Yes
trafficRateTxDoubleYes
trafficRateRxDoubleYes
trafficRateTotalDoubleYes
trafficFrameRateTxDoubleYes
trafficFrameRateRxDoubleYes
trafficFrameRateTotalDoubleYes
trafficFrameSizeAvgTxInt64Yes
trafficFrameSizeAvgRxInt64Yes
portErrorsTimeoutDiscardTxInt64Yes
portErrorsCrcInt64Yes
portErrorsEncInInt64Yes
portErrorsEncOutInt64Yes

Navigation Properties (Joins)

Nav PropertyRelated EntityCardinality / Join
time_dimensiontime_dimensionone
JOIN: timeTk = time_dimension.tk
date_dimensiondate_dimensionone
JOIN: dateTk = date_dimension.tk
tape_dimensiontape_dimensionone
JOIN: tapeTk = tape_dimension.tk

tape_dimension↑ top

Entity Set(s): tape_dimension

FieldTypeNullable
tkInt32Yes
nameStringYes
identifierStringYes
ipStringYes
manufacturerStringYes
serialNumberStringYes
idInt32Yes
latestStringYes
dateTkInt32Yes

Navigation Properties (Joins)

Nav PropertyRelated EntityCardinality / Join
switch_performance_for_tape_hourly_factswitch_performance_for_tape_hourly_factmany

tier_dimension↑ top

Entity Set(s): tier_dimension

FieldTypeNullable
tkInt32Yes
nameStringYes
sequenceInt32Yes
costDoubleYes
idInt32Yes
latestStringYes
dateTkInt32Yes

Navigation Properties (Joins)

Nav PropertyRelated EntityCardinality / Join
qtree_hourly_performance_factqtree_hourly_performance_factmany
vmdk_hourly_performance_factvmdk_hourly_performance_factmany
volume_hourly_performance_factvolume_hourly_performance_factmany
application_volume_hourly_performance_factapplication_volume_hourly_performance_factmany
qtree_daily_performance_factqtree_daily_performance_factmany
storage_node_daily_performance_factstorage_node_daily_performance_factmany
host_volume_hourly_performance_facthost_volume_hourly_performance_factmany
internal_volume_daily_performance_factinternal_volume_daily_performance_factmany
internal_volume_hourly_performance_factinternal_volume_hourly_performance_factmany
volume_daily_performance_factvolume_daily_performance_factmany
vmdk_daily_performance_factvmdk_daily_performance_factmany
storage_node_hourly_performance_factstorage_node_hourly_performance_factmany

time_dimension↑ top

Entity Set(s): time_dimension

FieldTypeNullable
tkPKInt32Yes
hourDateTimeDateTimeOffsetYes
hourByteYes
minuteByteYes
secondByteYes
microsecondInt32Yes
dateTkFK
date_dimension.tk
Int32Yes

Navigation Properties (Joins)

Nav PropertyRelated EntityCardinality / Join
date_dimensiondate_dimensionone
JOIN: dateTk = date_dimension.tk
vm_hourly_performance_factvm_hourly_performance_factmany
switch_performance_for_port_hourly_factswitch_performance_for_port_hourly_factmany
host_volume_hourly_performance_facthost_volume_hourly_performance_factmany
switch_performance_for_tape_hourly_factswitch_performance_for_tape_hourly_factmany
switch_performance_for_host_hourly_factswitch_performance_for_host_hourly_factmany
switch_performance_for_storage_hourly_factswitch_performance_for_storage_hourly_factmany
storage_node_hourly_performance_factstorage_node_hourly_performance_factmany
qtree_hourly_performance_factqtree_hourly_performance_factmany
vmdk_hourly_performance_factvmdk_hourly_performance_factmany
volume_hourly_performance_factvolume_hourly_performance_factmany
application_volume_hourly_performance_factapplication_volume_hourly_performance_factmany
disk_hourly_performance_factdisk_hourly_performance_factmany
internal_volume_hourly_performance_factinternal_volume_hourly_performance_factmany
host_vm_hourly_performance_facthost_vm_hourly_performance_factmany

vm_daily_performance_fact↑ top

Entity Set(s): vm_daily_performance_fact

FieldTypeNullable
tkPKInt32Yes
dateTkFK
date_dimension.tk
Int32Yes
hostTkFK
host_dimension.tk
Int32Yes
vmTkFK
vm_dimension.tk
Int32Yes
businessEntityTkFK
business_entity_dimension.tk
Int32Yes
applicationTkFK
application_dimension.tk
Int32Yes
applicationGroupTkFK
application_group_dimension.tk
Int32Yes
k8sNodeTkFK
k8s_node_dimension.tk
Int32Yes
readIopsDoubleYes
writeIopsDoubleYes
totalIopsDoubleYes
totalIopsMaxDoubleYes
readThroughputDoubleYes
writeThroughputDoubleYes
totalThroughputDoubleYes
totalThroughputMaxDoubleYes
readResponseTimeDoubleYes
writeResponseTimeDoubleYes
totalResponseTimeDoubleYes
totalResponseTimeMaxDoubleYes
ipReceiveThroughputDoubleYes
ipTransmitThroughputDoubleYes
ipTotalThroughputDoubleYes
ipTotalThroughputMaxDoubleYes
cpuUtilizationDoubleYes
maxOfAvgCpuUtilizationDoubleYes
maxOfMaxCpuUtilizationDoubleYes
memoryUtilizationDoubleYes
maxOfAvgMemoryUtilizationDoubleYes
maxOfMaxMemoryUtilizationDoubleYes
swapInRateDoubleYes
maxOfAvgSwapInRateDoubleYes
swapOutRateDoubleYes
maxOfAvgSwapOutRateDoubleYes
swapTotalRateDoubleYes
swapTotalRateMaxDoubleYes
processorsInt32Yes
memoryInt64Yes
cpuCoSchedulingDelayTimePercentDoubleYes
cpuDemandToEntitlementPercentDoubleYes
cpuIdleTimePercentDoubleYes
waitingToBeScheduledTimePercentDoubleYes
cpuTotalWaitTimePercentDoubleYes
timestampPKInt64Yes

Navigation Properties (Joins)

Nav PropertyRelated EntityCardinality / Join
business_entity_dimensionbusiness_entity_dimensionone
JOIN: businessEntityTk = business_entity_dimension.tk
k8s_node_dimensionk8s_node_dimensionone
JOIN: k8sNodeTk = k8s_node_dimension.tk
application_dimensionapplication_dimensionone
JOIN: applicationTk = application_dimension.tk
host_dimensionhost_dimensionone
JOIN: hostTk = host_dimension.tk
vm_dimensionvm_dimensionone
JOIN: vmTk = vm_dimension.tk
date_dimensiondate_dimensionone
JOIN: dateTk = date_dimension.tk
application_group_dimensionapplication_group_dimensionone
JOIN: applicationGroupTk = application_group_dimension.tk

vm_dimension↑ top

Entity Set(s): vm_dimension

FieldTypeNullable
tkInt32Yes
nameStringYes
naturalKeyStringYes
osStringYes
virtualCenterIpStringYes
ipsStringYes
urlStringYes
idInt32Yes
latestStringYes
dateTkInt32Yes

Navigation Properties (Joins)

Nav PropertyRelated EntityCardinality / Join
vmdk_hourly_performance_factvmdk_hourly_performance_factmany
vm_hourly_performance_factvm_hourly_performance_factmany
vm_daily_performance_factvm_daily_performance_factmany
vmdk_daily_performance_factvmdk_daily_performance_factmany

vm_hourly_performance_fact↑ top

Entity Set(s): vm_hourly_performance_fact

FieldTypeNullable
tkPKInt64Yes
timeTkFK
time_dimension.tk
Int32Yes
dateTkFK
date_dimension.tk
Int32Yes
hostTkFK
host_dimension.tk
Int32Yes
vmTkFK
vm_dimension.tk
Int32Yes
businessEntityTkFK
business_entity_dimension.tk
Int32Yes
applicationTkFK
application_dimension.tk
Int32Yes
applicationGroupTkFK
application_group_dimension.tk
Int32Yes
k8sNodeTkFK
k8s_node_dimension.tk
Int32Yes
readIopsDoubleYes
writeIopsDoubleYes
totalIopsDoubleYes
totalIopsMaxDoubleYes
readThroughputDoubleYes
writeThroughputDoubleYes
totalThroughputDoubleYes
totalThroughputMaxDoubleYes
readResponseTimeDoubleYes
writeResponseTimeDoubleYes
totalResponseTimeDoubleYes
totalResponseTimeMaxDoubleYes
ipReceiveThroughputDoubleYes
ipTransmitThroughputDoubleYes
ipTotalThroughputDoubleYes
ipTotalThroughputMaxDoubleYes
cpuUtilizationDoubleYes
memoryUtilizationDoubleYes
cpuUtilizationMaxDoubleYes
memoryUtilizationMaxDoubleYes
swapInRateDoubleYes
swapOutRateDoubleYes
swapTotalRateDoubleYes
swapTotalRateMaxDoubleYes
processorsInt32Yes
memoryInt64Yes
cpuCoSchedulingDelayTimePercentDoubleYes
cpuDemandToEntitlementPercentDoubleYes
cpuIdleTimePercentDoubleYes
waitingToBeScheduledTimePercentDoubleYes
cpuTotalWaitTimePercentDoubleYes
timestampPKInt64Yes

Navigation Properties (Joins)

Nav PropertyRelated EntityCardinality / Join
business_entity_dimensionbusiness_entity_dimensionone
JOIN: businessEntityTk = business_entity_dimension.tk
k8s_node_dimensionk8s_node_dimensionone
JOIN: k8sNodeTk = k8s_node_dimension.tk
application_dimensionapplication_dimensionone
JOIN: applicationTk = application_dimension.tk
time_dimensiontime_dimensionone
JOIN: timeTk = time_dimension.tk
host_dimensionhost_dimensionone
JOIN: hostTk = host_dimension.tk
vm_dimensionvm_dimensionone
JOIN: vmTk = vm_dimension.tk
date_dimensiondate_dimensionone
JOIN: dateTk = date_dimension.tk
application_group_dimensionapplication_group_dimensionone
JOIN: applicationGroupTk = application_group_dimension.tk

vmdk_daily_performance_fact↑ top

Entity Set(s): vmdk_daily_performance_fact

FieldTypeNullable
tkPKInt32Yes
dateTkFK
date_dimension.tk
Int32Yes
vmdkTkFK
vmdk_dimension.tk
Int32Yes
dataStoreTkFK
datastore_dimension.tk
Int32Yes
vmTkFK
vm_dimension.tk
Int32Yes
hostTkFK
host_dimension.tk
Int32Yes
tierTkFK
tier_dimension.tk
Int32Yes
serviceLevelTkFK
service_level_dimension.tk
Int32Yes
storageTkFK
storage_dimension.tk
Int32Yes
readIopsDoubleYes
writeIopsDoubleYes
totalIopsDoubleYes
totalIopsMaxDoubleYes
readThroughputDoubleYes
writeThroughputDoubleYes
totalThroughputDoubleYes
totalThroughputMaxDoubleYes
readResponseTimeDoubleYes
writeResponseTimeDoubleYes
totalResponseTimeDoubleYes
totalResponseTimeMaxDoubleYes
timestampPKInt64Yes

Navigation Properties (Joins)

Nav PropertyRelated EntityCardinality / Join
service_level_dimensionservice_level_dimensionone
JOIN: serviceLevelTk = service_level_dimension.tk
storage_dimensionstorage_dimensionone
JOIN: storageTk = storage_dimension.tk
tier_dimensiontier_dimensionone
JOIN: tierTk = tier_dimension.tk
datastore_dimensiondatastore_dimensionone
JOIN: dataStoreTk = datastore_dimension.tk
host_dimensionhost_dimensionone
JOIN: hostTk = host_dimension.tk
vm_dimensionvm_dimensionone
JOIN: vmTk = vm_dimension.tk
vmdk_dimensionvmdk_dimensionone
JOIN: vmdkTk = vmdk_dimension.tk
date_dimensiondate_dimensionone
JOIN: dateTk = date_dimension.tk

vmdk_dimension↑ top

Entity Set(s): vmdk_dimension

FieldTypeNullable
tkInt32Yes
naturalKeyStringYes
nameStringYes
typeStringYes
urlStringYes
idInt32Yes
latestStringYes
dateTkInt32Yes

Navigation Properties (Joins)

Nav PropertyRelated EntityCardinality / Join
vmdk_hourly_performance_factvmdk_hourly_performance_factmany
vmdk_daily_performance_factvmdk_daily_performance_factmany

vmdk_hourly_performance_fact↑ top

Entity Set(s): vmdk_hourly_performance_fact

FieldTypeNullable
tkPKInt64Yes
timeTkFK
time_dimension.tk
Int32Yes
dateTkFK
date_dimension.tk
Int32Yes
vmdkTkFK
vmdk_dimension.tk
Int32Yes
dataStoreTkFK
datastore_dimension.tk
Int32Yes
vmTkFK
vm_dimension.tk
Int32Yes
hostTkFK
host_dimension.tk
Int32Yes
tierTkFK
tier_dimension.tk
Int32Yes
serviceLevelTkFK
service_level_dimension.tk
Int32Yes
storageTkFK
storage_dimension.tk
Int32Yes
readIopsDoubleYes
writeIopsDoubleYes
totalIopsDoubleYes
totalIopsMaxDoubleYes
readThroughputDoubleYes
writeThroughputDoubleYes
totalThroughputDoubleYes
totalThroughputMaxDoubleYes
readResponseTimeDoubleYes
writeResponseTimeDoubleYes
totalResponseTimeDoubleYes
totalResponseTimeMaxDoubleYes
timestampPKInt64Yes

Navigation Properties (Joins)

Nav PropertyRelated EntityCardinality / Join
service_level_dimensionservice_level_dimensionone
JOIN: serviceLevelTk = service_level_dimension.tk
storage_dimensionstorage_dimensionone
JOIN: storageTk = storage_dimension.tk
tier_dimensiontier_dimensionone
JOIN: tierTk = tier_dimension.tk
time_dimensiontime_dimensionone
JOIN: timeTk = time_dimension.tk
datastore_dimensiondatastore_dimensionone
JOIN: dataStoreTk = datastore_dimension.tk
host_dimensionhost_dimensionone
JOIN: hostTk = host_dimension.tk
vm_dimensionvm_dimensionone
JOIN: vmTk = vm_dimension.tk
vmdk_dimensionvmdk_dimensionone
JOIN: vmdkTk = vmdk_dimension.tk
date_dimensiondate_dimensionone
JOIN: dateTk = date_dimension.tk

vmware_host_daily_metrics_fact↑ top

Entity Set(s): vmware_host_daily_metrics_fact

FieldTypeNullable
tkPKInt64Yes
dateTkInt32Yes
vmwareHostTkInt32Yes
powerAvgDoubleYes
powerCapAvgDoubleYes
energyAvgDoubleYes
timestampPKInt64Yes

vmware_host_dimension↑ top

Entity Set(s): vmware_host_dimension

FieldTypeNullable
tkInt32Yes
identifierStringYes
nameStringYes
numCpuCoresInt64Yes
numCpuPackagesInt64Yes
numCpuThreadsInt64Yes
numNodesInt64Yes
hyperThreadActiveStringYes
hyperThreadAvailableStringYes
hyperThreadConfigStringYes
idInt32Yes
latestStringYes
dateTkInt32Yes

vmware_host_hourly_metrics_fact↑ top

Entity Set(s): vmware_host_hourly_metrics_fact

FieldTypeNullable
tkPKInt64Yes
timeTkInt32Yes
dateTkInt32Yes
vmwareHostTkInt32Yes
powerAvgDoubleYes
powerCapAvgDoubleYes
energyAvgDoubleYes
timestampPKInt64Yes

volume_daily_performance_fact↑ top

Entity Set(s): volume_daily_performance_fact

FieldTypeNullable
tkPKInt32Yes
dateTkFK
date_dimension.tk
Int32Yes
volumeTkFK
volume_dimension.tk
Int32Yes
storageTkFK
storage_dimension.tk
Int32Yes
virtualStorageTkInt32Yes
storageNodeTkFK
storage_node_dimension.tk
Int32Yes
storagePoolTkFK
storage_pool_dimension.tk
Int32Yes
applicationTkFK
application_dimension.tk
Int32Yes
applicationGroupTkFK
application_group_dimension.tk
Int32Yes
hostTkFK
host_dimension.tk
Int32Yes
hostGroupTkFK
host_group_dimension.tk
Int32Yes
tierTkFK
tier_dimension.tk
Int32Yes
serviceLevelTkFK
service_level_dimension.tk
Int32Yes
businessEntityTkFK
business_entity_dimension.tk
Int32Yes
k8sNamespaceTkFK
k8s_namespace_dimension.tk
Int32Yes
k8sNamespaceGroupTkFK
k8s_namespace_group_dimension.tk
Int32Yes
readResponseTimeDoubleYes
writeResponseTimeDoubleYes
totalResponseTimeDoubleYes
totalResponseTimeMaxDoubleYes
readThroughputDoubleYes
writeThroughputDoubleYes
totalThroughputDoubleYes
totalThroughputMaxDoubleYes
readIopsDoubleYes
writeIopsDoubleYes
totalIopsDoubleYes
totalIopsMaxDoubleYes
readCacheHitRatioDoubleYes
writeCacheHitRatioDoubleYes
totalCacheHitRatioDoubleYes
totalCacheHitRatioMaxDoubleYes
writePendingInt64Yes
readIoDensityDoubleYes
writeIoDensityDoubleYes
totalIoDensityDoubleYes
totalIoDensityMaxDoubleYes
compressionSavingsPercentDoubleYes
compressionSavingsSpaceDoubleYes
totalTimeToFullDoubleYes
confidenceIntervalTimeToFullDoubleYes
accessedInt32Yes
frontendStringYes
backendStringYes
timestampPKInt64Yes

Navigation Properties (Joins)

Nav PropertyRelated EntityCardinality / Join
storage_node_dimensionstorage_node_dimensionone
JOIN: storageNodeTk = storage_node_dimension.tk
storage_dimensionstorage_dimensionone
JOIN: storageTk = storage_dimension.tk
business_entity_dimensionbusiness_entity_dimensionone
JOIN: businessEntityTk = business_entity_dimension.tk
host_group_dimensionhost_group_dimensionone
JOIN: hostGroupTk = host_group_dimension.tk
k8s_namespace_group_dimensionk8s_namespace_group_dimensionone
JOIN: k8sNamespaceGroupTk = k8s_namespace_group_dimension.tk
application_group_dimensionapplication_group_dimensionone
JOIN: applicationGroupTk = application_group_dimension.tk
k8s_namespace_dimensionk8s_namespace_dimensionone
JOIN: k8sNamespaceTk = k8s_namespace_dimension.tk
service_level_dimensionservice_level_dimensionone
JOIN: serviceLevelTk = service_level_dimension.tk
tier_dimensiontier_dimensionone
JOIN: tierTk = tier_dimension.tk
application_dimensionapplication_dimensionone
JOIN: applicationTk = application_dimension.tk
storage_pool_dimensionstorage_pool_dimensionone
JOIN: storagePoolTk = storage_pool_dimension.tk
host_dimensionhost_dimensionone
JOIN: hostTk = host_dimension.tk
date_dimensiondate_dimensionone
JOIN: dateTk = date_dimension.tk
volume_dimensionvolume_dimensionone
JOIN: volumeTk = volume_dimension.tk

volume_dimension↑ top

Entity Set(s): volume_dimension

FieldTypeNullable
tkInt32Yes
storageIdentifierStringYes
nameStringYes
labelStringYes
thinProvisionedStringYes
typeStringYes
isVirtualStringYes
metaStringYes
snapshotStringYes
technologyTypeStringYes
uuidStringYes
isMainframeStringYes
urlStringYes
idInt32Yes
latestStringYes
dateTkInt32Yes

Navigation Properties (Joins)

Nav PropertyRelated EntityCardinality / Join
volume_hourly_performance_factvolume_hourly_performance_factmany
volume_daily_performance_factvolume_daily_performance_factmany

volume_hourly_performance_fact↑ top

Entity Set(s): volume_hourly_performance_fact

FieldTypeNullable
tkPKInt64Yes
timeTkFK
time_dimension.tk
Int32Yes
dateTkFK
date_dimension.tk
Int32Yes
volumeTkFK
volume_dimension.tk
Int32Yes
storageTkFK
storage_dimension.tk
Int32Yes
virtualStorageTkInt32Yes
storageNodeTkFK
storage_node_dimension.tk
Int32Yes
storagePoolTkFK
storage_pool_dimension.tk
Int32Yes
applicationTkFK
application_dimension.tk
Int32Yes
applicationGroupTkFK
application_group_dimension.tk
Int32Yes
hostTkFK
host_dimension.tk
Int32Yes
hostGroupTkFK
host_group_dimension.tk
Int32Yes
tierTkFK
tier_dimension.tk
Int32Yes
serviceLevelTkFK
service_level_dimension.tk
Int32Yes
businessEntityTkFK
business_entity_dimension.tk
Int32Yes
k8sNamespaceTkFK
k8s_namespace_dimension.tk
Int32Yes
k8sNamespaceGroupTkFK
k8s_namespace_group_dimension.tk
Int32Yes
readResponseTimeDoubleYes
writeResponseTimeDoubleYes
totalResponseTimeDoubleYes
totalResponseTimeMaxDoubleYes
readThroughputDoubleYes
writeThroughputDoubleYes
totalThroughputDoubleYes
totalThroughputMaxDoubleYes
readIopsDoubleYes
writeIopsDoubleYes
totalIopsDoubleYes
totalIopsMaxDoubleYes
readCacheHitRatioDoubleYes
writeCacheHitRatioDoubleYes
totalCacheHitRatioDoubleYes
totalCacheHitRatioMaxDoubleYes
writePendingInt64Yes
readIoDensityDoubleYes
writeIoDensityDoubleYes
totalIoDensityDoubleYes
totalIoDensityMaxDoubleYes
compressionSavingsPercentDoubleYes
compressionSavingsSpaceDoubleYes
totalTimeToFullDoubleYes
confidenceIntervalTimeToFullDoubleYes
accessedInt32Yes
frontendStringYes
backendStringYes
timestampPKInt64Yes

Navigation Properties (Joins)

Nav PropertyRelated EntityCardinality / Join
storage_node_dimensionstorage_node_dimensionone
JOIN: storageNodeTk = storage_node_dimension.tk
storage_dimensionstorage_dimensionone
JOIN: storageTk = storage_dimension.tk
business_entity_dimensionbusiness_entity_dimensionone
JOIN: businessEntityTk = business_entity_dimension.tk
host_group_dimensionhost_group_dimensionone
JOIN: hostGroupTk = host_group_dimension.tk
k8s_namespace_group_dimensionk8s_namespace_group_dimensionone
JOIN: k8sNamespaceGroupTk = k8s_namespace_group_dimension.tk
application_group_dimensionapplication_group_dimensionone
JOIN: applicationGroupTk = application_group_dimension.tk
k8s_namespace_dimensionk8s_namespace_dimensionone
JOIN: k8sNamespaceTk = k8s_namespace_dimension.tk
service_level_dimensionservice_level_dimensionone
JOIN: serviceLevelTk = service_level_dimension.tk
tier_dimensiontier_dimensionone
JOIN: tierTk = tier_dimension.tk
application_dimensionapplication_dimensionone
JOIN: applicationTk = application_dimension.tk
time_dimensiontime_dimensionone
JOIN: timeTk = time_dimension.tk
storage_pool_dimensionstorage_pool_dimensionone
JOIN: storagePoolTk = storage_pool_dimension.tk
host_dimensionhost_dimensionone
JOIN: hostTk = host_dimension.tk
date_dimensiondate_dimensionone
JOIN: dateTk = date_dimension.tk
volume_dimensionvolume_dimensionone
JOIN: volumeTk = volume_dimension.tk