Schema Documentation

Referenced (parent) table	FK column	Parent PK
application_dimension	applicationTk	tk
application_group_dimension	applicationGroupTk	tk
business_entity_dimension	businessEntityTk	tk
date_dimension	dateTk	tk
host_dimension	hostTk	tk
host_group_dimension	hostGroupTk	tk
internal_volume_dimension	internalVolumeTk	tk
k8s_namespace_dimension	k8sNamespaceTk	tk
k8s_namespace_group_dimension	k8sNamespaceGroupTk	tk
qtree_dimension	qtreeTk	tk
service_level_dimension	serviceLevelTk	tk
storage_dimension	storageTk	tk
storage_pool_dimension	storagePoolTk	tk
tier_dimension	tierTk	tk

Referenced (parent) table	FK column	Parent PK
date_dimension	dateTk	tk
disk_group_dimension	diskGroupTk	tk
storage_dimension	storageTk	tk
storage_pool_dimension	storagePoolTk	tk

Referenced (parent) table	FK column	Parent PK
date_dimension	dateTk	tk
disk_group_dimension	diskGroupTk	tk
storage_dimension	storageTk	tk
storage_pool_dimension	storagePoolTk	tk

Referenced (parent) table	FK column	Parent PK
application_dimension	applicationTk	tk
application_group_dimension	applicationGroupTk	tk
business_entity_dimension	businessEntityTk	tk
date_dimension	dateTk	tk
internal_volume_dimension	internalVolumeTk	tk
k8s_namespace_dimension	k8sNamespaceTk	tk
k8s_namespace_group_dimension	k8sNamespaceGroupTk	tk
service_level_dimension	serviceLevelTk	tk
storage_dimension	storageTk	tk
storage_pool_dimension	storagePoolTk	tk
tier_dimension	tierTk	tk

Referenced (parent) table	FK column	Parent PK
date_dimension	dateTk	tk
k8s_cluster_dimension	clusterTk	tk
k8s_namespace_dimension	namespaceTk	tk
k8s_pv_dimension	pvTk	tk
k8s_pvc_dimension	pvcTk	tk

Referenced (parent) table	FK column	Parent PK
application_dimension	applicationTk	tk
application_group_dimension	applicationGroupTk	tk
business_entity_dimension	businessEntityTk	tk
date_dimension	dateTk	tk
internal_volume_dimension	internalVolumeTk	tk
k8s_namespace_dimension	k8sNamespaceTk	tk
k8s_namespace_group_dimension	k8sNamespaceGroupTk	tk
qtree_dimension	qtreeTk	tk
service_level_dimension	serviceLevelTk	tk
storage_dimension	storageTk	tk
storage_pool_dimension	storagePoolTk	tk
tier_dimension	tierTk	tk

Referenced (parent) table	FK column	Parent PK
storage_and_storage_pool_capacity_fact	saspFactTk	tk

Referenced (parent) table	FK column	Parent PK
date_dimension	dateTk	tk
storage_dimension	storageTk	tk
storage_pool_dimension	storagePoolTk	tk
tier_dimension	tierTk	tk

Referenced (parent) table	FK column	Parent PK
date_dimension	dateTk	tk
storage_dimension	storageTk	tk
storage_pool_dimension	storagePoolTk	tk
tier_dimension	tierTk	tk

Referenced (parent) table	FK column	Parent PK
date_dimension	dateTk	tk
storage_dimension	storageTk	tk
storage_node_dimension	storageNodeTk	tk
tier_dimension	tierTk	tk

Referenced (parent) table	FK column	Parent PK
application_dimension	applicationTk	tk
application_group_dimension	applicationGroupTk	tk
business_entity_dimension	businessEntityTk	tk
capacity_type	capacityType	type
datastore_dimension	dataStoreTk	tk
date_dimension	dateTk	tk
host_dimension	hostTk	tk
host_group_dimension	hostGroupTk	tk
internal_volume_dimension	internalVolumeTk	tk
k8s_node_dimension	k8sNodeTk	tk
qtree_dimension	qtreeTk	tk
service_level_dimension	serviceLevelTk	tk
storage_dimension	storageTk	tk
tier_dimension	tierTk	tk
vm_dimension	vmTk	tk

Referenced (parent) table	FK column	Parent PK
chargeback_fact	chargebackFactTk	tk

Referenced (parent) table	FK column	Parent PK
chargeback_fact	chargebackFactTk	tk
date_dimension	dateTk	tk
host_dimension	hostTk	tk
host_group_dimension	hostGroupTk	tk
internal_volume_dimension	internalVolumeTk	tk
k8s_namespace_group_dimension	k8sNamespaceGroupTk	tk
qtree_dimension	qtreeTk	tk
service_level_dimension	serviceLevelTk	tk
storage_and_storage_pool_capacity_fact	storageAndSpFactTk	tk
storage_dimension	storageTk	tk
storage_pool_dimension	storagePoolTk	tk
tier_dimension	tierTk	tk
volume_dimension	volumeTk	tk

Field	Type	Nullable
appGroupTk	Int32	Yes
appTk	Int32	Yes
isRep	String	Yes

Field	Type	Nullable
typePK	String	Yes
used	String	Yes
vmSpecific	String	Yes
replicationSpecific	String	Yes
description	String	Yes

Field	Type	Nullable
digit	Int32	Yes

chargeback_fact↑ top

Entity Set(s): chargeback_fact

Field	Type	Nullable
tkPK	Int32	Yes
dateTkFK → date_dimension.tk	Int32	Yes
storageTkFK → storage_dimension.tk	Int32	Yes
storagePoolTkFK → storage_pool_dimension.tk	Int32	Yes
internalVolumeTkFK → internal_volume_dimension.tk	Int32	Yes
qtreeTkFK → qtree_dimension.tk	Int32	Yes
hostTkFK → host_dimension.tk	Int32	Yes
hostGroupTkFK → host_group_dimension.tk	Int32	Yes
applicationTkFK → application_dimension.tk	Int32	Yes
applicationGroupTkFK → application_group_dimension.tk	Int32	Yes
tierTkFK → tier_dimension.tk	Int32	Yes
serviceLevelTkFK → service_level_dimension.tk	Int32	Yes
businessUnit	String	Yes
businessEntityTkFK → business_entity_dimension.tk	Int32	Yes
k8sNamespaceTkFK → k8s_namespace_dimension.tk	Int32	Yes
k8sNamespaceGroupTkFK → k8s_namespace_group_dimension.tk	Int32	Yes
protectionType	String	Yes
storageAccessType	String	Yes
resourceName	String	Yes
resourceType	String	Yes
mappedByVM	String	Yes
virtualStorage	String	Yes
provisionedCapacityMB	Int64	Yes
usedCapacityMB	Int64	Yes

Navigation Properties (Joins)

Nav Property	Related Entity	Cardinality / Join
internal_volume_dimension	internal_volume_dimension	one JOIN: `internalVolumeTk` = internal_volume_dimension.`tk`
storage_dimension	storage_dimension	one JOIN: `storageTk` = storage_dimension.`tk`
business_entity_dimension	business_entity_dimension	one JOIN: `businessEntityTk` = business_entity_dimension.`tk`
host_group_dimension	host_group_dimension	one JOIN: `hostGroupTk` = host_group_dimension.`tk`
k8s_namespace_group_dimension	k8s_namespace_group_dimension	one JOIN: `k8sNamespaceGroupTk` = k8s_namespace_group_dimension.`tk`
application_group_dimension	application_group_dimension	one JOIN: `applicationGroupTk` = application_group_dimension.`tk`
k8s_namespace_dimension	k8s_namespace_dimension	one JOIN: `k8sNamespaceTk` = k8s_namespace_dimension.`tk`
service_level_dimension	service_level_dimension	one JOIN: `serviceLevelTk` = service_level_dimension.`tk`
tier_dimension	tier_dimension	one JOIN: `tierTk` = tier_dimension.`tk`
application_dimension	application_dimension	one JOIN: `applicationTk` = application_dimension.`tk`
qtree_dimension	qtree_dimension	one JOIN: `qtreeTk` = qtree_dimension.`tk`
storage_pool_dimension	storage_pool_dimension	one JOIN: `storagePoolTk` = storage_pool_dimension.`tk`
host_dimension	host_dimension	one JOIN: `hostTk` = host_dimension.`tk`
date_dimension	date_dimension	one JOIN: `dateTk` = date_dimension.`tk`
volume_fact_current	volume_fact_current	many
volume_history_capacity_fact	volume_history_capacity_fact	many

datastore_dimension↑ top

Entity Set(s): datastore_dimension

Field	Type	Nullable
tk	Int32	Yes
naturalKey	String	Yes
name	String	Yes
moid	String	Yes
virtualCenterIp	String	Yes
url	String	Yes
id	Int32	Yes
latest	String	Yes
dateTk	Int32	Yes

Navigation Properties (Joins)

Nav Property	Related Entity	Cardinality / Join
vm_capacity_fact	vm_capacity_fact	many

date_dimension↑ top

Entity Set(s): date_dimension

Field	Type	Nullable
tk	Int32	Yes
fullDate	DateTimeOffset	Yes
dayInMonth	Byte	Yes
dayInYear	Int32	Yes
dateYear	Int32	Yes
yearLabel	String	Yes
monthNum	Byte	Yes
monthLabel	String	Yes
dayInWeekNum	Byte	Yes
quarter	Byte	Yes
quarterLabel	String	Yes
dayInQuarter	Int32	Yes
repQuarter	Byte	Yes
repMonth	Byte	Yes
repWeek	Byte	Yes
repDay	Byte	Yes
repMonthOrLatest	Byte	Yes
sspFlag	Byte	Yes
latest	String	Yes
future	String	Yes

Navigation Properties (Joins)

Nav Property	Related Entity	Cardinality / Join
internal_volume_capacity_fact	internal_volume_capacity_fact	many
chargeback_fact	chargeback_fact	many
disk_group_capacity_fact	disk_group_capacity_fact	many
vm_capacity_fact	vm_capacity_fact	many
disk_group_capacity_future_fact	disk_group_capacity_future_fact	many
qtree_capacity_fact	qtree_capacity_fact	many
k8s_pvc_capacity_fact	k8s_pvc_capacity_fact	many
storage_and_storage_pool_capacity_fact	storage_and_storage_pool_capacity_fact	many
volume_history_capacity_fact	volume_history_capacity_fact	many
storage_and_storage_pool_capacity_future_fact	storage_and_storage_pool_capacity_future_fact	many
storage_node_capacity_fact	storage_node_capacity_fact	many

disk_group_capacity_fact↑ top

Entity Set(s): disk_group_capacity_fact

Field	Type	Nullable
tkPK	Int32	Yes
dateTkFK → date_dimension.tk	Int32	Yes
storageTkFK → storage_dimension.tk	Int32	Yes
storagePoolTkFK → storage_pool_dimension.tk	Int32	Yes
diskGroupTkFK → disk_group_dimension.tk	Int32	Yes
capacityMB	Int64	Yes
usedCapacityMB	Int64	Yes
physicalDiskCapacityMB	Int64	Yes

Navigation Properties (Joins)

Nav Property	Related Entity	Cardinality / Join
disk_group_dimension	disk_group_dimension	one JOIN: `diskGroupTk` = disk_group_dimension.`tk`
storage_dimension	storage_dimension	one JOIN: `storageTk` = storage_dimension.`tk`
storage_pool_dimension	storage_pool_dimension	one JOIN: `storagePoolTk` = storage_pool_dimension.`tk`
date_dimension	date_dimension	one JOIN: `dateTk` = date_dimension.`tk`

disk_group_capacity_future_fact↑ top

Entity Set(s): disk_group_capacity_future_fact

Field	Type	Nullable
tkPK	Int32	Yes
dateTkFK → date_dimension.tk	Int32	Yes
storageTkFK → storage_dimension.tk	Int32	Yes
storagePoolTkFK → storage_pool_dimension.tk	Int32	Yes
diskGroupTkFK → disk_group_dimension.tk	Int32	Yes
capacityMB	Int64	Yes
usedCapacityMB	Int64	Yes

Navigation Properties (Joins)

Nav Property	Related Entity	Cardinality / Join
disk_group_dimension	disk_group_dimension	one JOIN: `diskGroupTk` = disk_group_dimension.`tk`
storage_dimension	storage_dimension	one JOIN: `storageTk` = storage_dimension.`tk`
storage_pool_dimension	storage_pool_dimension	one JOIN: `storagePoolTk` = storage_pool_dimension.`tk`
date_dimension	date_dimension	one JOIN: `dateTk` = date_dimension.`tk`

disk_group_dimension↑ top

Entity Set(s): disk_group_dimension

Field	Type	Nullable
tk	Int32	Yes
name	String	Yes
identifier	String	Yes
vendorDiskGroupType	String	Yes
diskType	String	Yes
status	String	Yes
redundancy	String	Yes
isVirtual	String	Yes
vendorTier	String	Yes
id	Int32	Yes
latest	String	Yes
dateTk	Int32	Yes

Navigation Properties (Joins)

Nav Property	Related Entity	Cardinality / Join
disk_group_capacity_fact	disk_group_capacity_fact	many
disk_group_capacity_future_fact	disk_group_capacity_future_fact	many

host_dimension↑ top

Entity Set(s): host_dimension

Field	Type	Nullable
tk	Int32	Yes
name	String	Yes
identifier	String	Yes
ip	String	Yes
os	String	Yes
model	String	Yes
manufacturer	String	Yes
url	String	Yes
id	Int32	Yes
latest	String	Yes
dateTk	Int32	Yes
dataCenter	String	Yes

Navigation Properties (Joins)

Nav Property	Related Entity	Cardinality / Join
chargeback_fact	chargeback_fact	many
vm_capacity_fact	vm_capacity_fact	many
volume_history_capacity_fact	volume_history_capacity_fact	many

host_group_bridge↑ top

Entity Set(s): host_group_bridge

Field	Type	Nullable
hostGroupTk	Int32	Yes
hostTk	Int32	Yes
isRep	String	Yes

host_group_dimension↑ top

Entity Set(s): host_group_dimension

Field	Type	Nullable
tk	Int32	Yes
repHost	String	Yes
repHostTk	Int32	Yes
cardinality	Int32	Yes
dateTk	Int32	Yes

Navigation Properties (Joins)

Nav Property	Related Entity	Cardinality / Join
chargeback_fact	chargeback_fact	many
vm_capacity_fact	vm_capacity_fact	many
volume_history_capacity_fact	volume_history_capacity_fact	many

internal_volume_capacity_fact↑ top

Entity Set(s): internal_volume_capacity_fact

Field	Type	Nullable
tkPK	Int32	Yes
dateTkFK → date_dimension.tk	Int32	Yes
storageTkFK → storage_dimension.tk	Int32	Yes
storagePoolTkFK → storage_pool_dimension.tk	Int32	Yes
internalVolumeTkFK → internal_volume_dimension.tk	Int32	Yes
virtualStorageTk	Int32	Yes
tierTkFK → tier_dimension.tk	Int32	Yes
applicationTkFK → application_dimension.tk	Int32	Yes
applicationGroupTkFK → application_group_dimension.tk	Int32	Yes
serviceLevelTkFK → service_level_dimension.tk	Int32	Yes
businessUnit	String	Yes
businessEntityTkFK → business_entity_dimension.tk	Int32	Yes
k8sNamespaceTkFK → k8s_namespace_dimension.tk	Int32	Yes
k8sNamespaceGroupTkFK → k8s_namespace_group_dimension.tk	Int32	Yes
storageAccessType	String	Yes
protectionType	String	Yes
allocatedCapacityMB	Int64	Yes
consumedCapacityMB	Int64	Yes
usedCapacityMB	Int64	Yes
dataUsedCapacityMB	Int64	Yes
dataUnusedCapacityMB	Int64	Yes
snapshotAllocatedCapacityMB	Int64	Yes
snapshotUsedCapacityMB	Int64	Yes
totalCloneSavedCapacityMB	Int64	Yes
dedupeRatio	Double	Yes
dedupeSavingsGB	Int64	Yes
rawToUsableRatio	Double	Yes
snapshotCount	Int32	Yes
lastSnapshotTime	DateTimeOffset	Yes
compressionRatio	Double	Yes
compressionSavingsGB	Int64	Yes
compressionSavingsPercent	Double	Yes
objectStoreUsedSpaceGB	Int64	Yes

Navigation Properties (Joins)

Nav Property	Related Entity	Cardinality / Join
service_level_dimension	service_level_dimension	one JOIN: `serviceLevelTk` = service_level_dimension.`tk`
internal_volume_dimension	internal_volume_dimension	one JOIN: `internalVolumeTk` = internal_volume_dimension.`tk`
storage_dimension	storage_dimension	one JOIN: `storageTk` = storage_dimension.`tk`
tier_dimension	tier_dimension	one JOIN: `tierTk` = tier_dimension.`tk`
business_entity_dimension	business_entity_dimension	one JOIN: `businessEntityTk` = business_entity_dimension.`tk`
application_dimension	application_dimension	one JOIN: `applicationTk` = application_dimension.`tk`
storage_pool_dimension	storage_pool_dimension	one JOIN: `storagePoolTk` = storage_pool_dimension.`tk`
date_dimension	date_dimension	one JOIN: `dateTk` = date_dimension.`tk`
k8s_namespace_group_dimension	k8s_namespace_group_dimension	one JOIN: `k8sNamespaceGroupTk` = k8s_namespace_group_dimension.`tk`
application_group_dimension	application_group_dimension	one JOIN: `applicationGroupTk` = application_group_dimension.`tk`
k8s_namespace_dimension	k8s_namespace_dimension	one JOIN: `k8sNamespaceTk` = k8s_namespace_dimension.`tk`

internal_volume_dimension↑ top

Entity Set(s): internal_volume_dimension

Field	Type	Nullable
tk	Int32	Yes
name	String	Yes
identifier	String	Yes
storagePoolIdentifier	String	Yes
storageName	String	Yes
storageIP	String	Yes
type	String	Yes
virtualStorage	String	Yes
spaceGuarantee	String	Yes
thinProvisioningSupported	String	Yes
thinProvisioned	String	Yes
uuid	String	Yes
flexGroupIdentifier	String	Yes
url	String	Yes
id	Int32	Yes
latest	String	Yes
dateTk	Int32	Yes

Navigation Properties (Joins)

Nav Property	Related Entity	Cardinality / Join
internal_volume_capacity_fact	internal_volume_capacity_fact	many
chargeback_fact	chargeback_fact	many
vm_capacity_fact	vm_capacity_fact	many
qtree_capacity_fact	qtree_capacity_fact	many
volume_history_capacity_fact	volume_history_capacity_fact	many

k8s_cluster_dimension↑ top

Entity Set(s): k8s_cluster_dimension

Field	Type	Nullable
tk	Int32	Yes
identifier	String	Yes
name	String	Yes
id	Int32	Yes
latest	String	Yes
dateTk	Int32	Yes

Navigation Properties (Joins)

Nav Property	Related Entity	Cardinality / Join
k8s_pvc_capacity_fact	k8s_pvc_capacity_fact	many

k8s_namespace_dimension↑ top

Entity Set(s): k8s_namespace_dimension

Field	Type	Nullable
tk	Int32	Yes
identifier	String	Yes
name	String	Yes
clusterName	String	Yes
id	Int32	Yes
latest	String	Yes
dateTk	Int32	Yes

Navigation Properties (Joins)

Nav Property	Related Entity	Cardinality / Join
internal_volume_capacity_fact	internal_volume_capacity_fact	many
chargeback_fact	chargeback_fact	many
qtree_capacity_fact	qtree_capacity_fact	many
k8s_pvc_capacity_fact	k8s_pvc_capacity_fact	many

k8s_namespace_group_bridge↑ top

Entity Set(s): k8s_namespace_group_bridge

Field	Type	Nullable
k8sNamespaceGroupTk	Int32	Yes
k8sNamespaceTk	Int32	Yes
isRep	String	Yes

k8s_namespace_group_dimension↑ top

Entity Set(s): k8s_namespace_group_dimension

Field	Type	Nullable
tk	Int32	Yes
repK8sNamespace	String	Yes
repK8sNamespaceTk	Int32	Yes
cardinality	Int32	Yes
dateTk	Int32	Yes

Navigation Properties (Joins)

Nav Property	Related Entity	Cardinality / Join
internal_volume_capacity_fact	internal_volume_capacity_fact	many
chargeback_fact	chargeback_fact	many
qtree_capacity_fact	qtree_capacity_fact	many
volume_history_capacity_fact	volume_history_capacity_fact	many

k8s_node_dimension↑ top

Entity Set(s): k8s_node_dimension

Field	Type	Nullable
tk	Int32	Yes
identifier	String	Yes
name	String	Yes
clusterName	String	Yes
internalIp	String	Yes
osImage	String	Yes
id	Int32	Yes
latest	String	Yes
dateTk	Int32	Yes

Navigation Properties (Joins)

Nav Property	Related Entity	Cardinality / Join
vm_capacity_fact	vm_capacity_fact	many

k8s_pv_dimension↑ top

Entity Set(s): k8s_pv_dimension

Field	Type	Nullable
tk	Int32	Yes
identifier	String	Yes
name	String	Yes
clusterName	String	Yes
phase	String	Yes
pvcName	String	Yes
storageClass	String	Yes
id	Int32	Yes
latest	String	Yes
dateTk	Int32	Yes

Navigation Properties (Joins)

Nav Property	Related Entity	Cardinality / Join
k8s_pvc_capacity_fact	k8s_pvc_capacity_fact	many

k8s_pvc_capacity_fact↑ top

Entity Set(s): k8s_pvc_capacity_fact

Field	Type	Nullable
tkPK	Int32	Yes
dateTkFK → date_dimension.tk	Int32	Yes
pvcTkFK → k8s_pvc_dimension.tk	Int32	Yes
clusterTkFK → k8s_cluster_dimension.tk	Int32	Yes
namespaceTkFK → k8s_namespace_dimension.tk	Int32	Yes
pvTkFK → k8s_pv_dimension.tk	Int32	Yes
pvSizeBytes	Double	Yes
pvcSizeBytes	Double	Yes

Navigation Properties (Joins)

Nav Property	Related Entity	Cardinality / Join
k8s_pvc_dimension	k8s_pvc_dimension	one JOIN: `pvcTk` = k8s_pvc_dimension.`tk`
k8s_cluster_dimension	k8s_cluster_dimension	one JOIN: `clusterTk` = k8s_cluster_dimension.`tk`
k8s_namespace_dimension	k8s_namespace_dimension	one JOIN: `namespaceTk` = k8s_namespace_dimension.`tk`
date_dimension	date_dimension	one JOIN: `dateTk` = date_dimension.`tk`
k8s_pv_dimension	k8s_pv_dimension	one JOIN: `pvTk` = k8s_pv_dimension.`tk`

k8s_pvc_dimension↑ top

Entity Set(s): k8s_pvc_dimension

Field	Type	Nullable
tk	Int32	Yes
identifier	String	Yes
name	String	Yes
clusterName	String	Yes
namespaceName	String	Yes
pvName	String	Yes
phase	String	Yes
id	Int32	Yes
latest	String	Yes
dateTk	Int32	Yes

Navigation Properties (Joins)

Nav Property	Related Entity	Cardinality / Join
k8s_pvc_capacity_fact	k8s_pvc_capacity_fact	many

k8s_workload_dimension↑ top

Entity Set(s): k8s_workload_dimension

Field	Type	Nullable
tk	Int32	Yes
identifier	String	Yes
name	String	Yes
clusterName	String	Yes
namespaceName	String	Yes
type	String	Yes
id	Int32	Yes
latest	String	Yes
dateTk	Int32	Yes

qtree_capacity_fact↑ top

Entity Set(s): qtree_capacity_fact

Field	Type	Nullable
tkPK	Int32	Yes
dateTkFK → date_dimension.tk	Int32	Yes
storageTkFK → storage_dimension.tk	Int32	Yes
storagePoolTkFK → storage_pool_dimension.tk	Int32	Yes
internalVolumeTkFK → internal_volume_dimension.tk	Int32	Yes
qtreeTkFK → qtree_dimension.tk	Int32	Yes
virtualStorageTk	Int32	Yes
tierTkFK → tier_dimension.tk	Int32	Yes
serviceLevelTkFK → service_level_dimension.tk	Int32	Yes
applicationTkFK → application_dimension.tk	Int32	Yes
applicationGroupTkFK → application_group_dimension.tk	Int32	Yes
businessUnit	String	Yes
businessEntityTkFK → business_entity_dimension.tk	Int32	Yes
k8sNamespaceTkFK → k8s_namespace_dimension.tk	Int32	Yes
k8sNamespaceGroupTkFK → k8s_namespace_group_dimension.tk	Int32	Yes
storageAccessType	String	Yes
protectionType	String	Yes
hardLimitCapacityMB	Int64	Yes
softLimitCapacityMB	Int64	Yes
usedCapacityMB	Int64	Yes
rawToUsableRatio	Double	Yes
missingQuotaLimits	String	Yes

Navigation Properties (Joins)

Nav Property	Related Entity	Cardinality / Join
internal_volume_dimension	internal_volume_dimension	one JOIN: `internalVolumeTk` = internal_volume_dimension.`tk`
storage_dimension	storage_dimension	one JOIN: `storageTk` = storage_dimension.`tk`
business_entity_dimension	business_entity_dimension	one JOIN: `businessEntityTk` = business_entity_dimension.`tk`
k8s_namespace_group_dimension	k8s_namespace_group_dimension	one JOIN: `k8sNamespaceGroupTk` = k8s_namespace_group_dimension.`tk`
application_group_dimension	application_group_dimension	one JOIN: `applicationGroupTk` = application_group_dimension.`tk`
k8s_namespace_dimension	k8s_namespace_dimension	one JOIN: `k8sNamespaceTk` = k8s_namespace_dimension.`tk`
service_level_dimension	service_level_dimension	one JOIN: `serviceLevelTk` = service_level_dimension.`tk`
tier_dimension	tier_dimension	one JOIN: `tierTk` = tier_dimension.`tk`
application_dimension	application_dimension	one JOIN: `applicationTk` = application_dimension.`tk`
qtree_dimension	qtree_dimension	one JOIN: `qtreeTk` = qtree_dimension.`tk`
storage_pool_dimension	storage_pool_dimension	one JOIN: `storagePoolTk` = storage_pool_dimension.`tk`
date_dimension	date_dimension	one JOIN: `dateTk` = date_dimension.`tk`

qtree_dimension↑ top

Entity Set(s): qtree_dimension

Field	Type	Nullable
tk	Int32	Yes
name	String	Yes
identifier	String	Yes
storageIdentifier	String	Yes
type	String	Yes
url	String	Yes
id	Int32	Yes
latest	String	Yes
dateTk	Int32	Yes

Navigation Properties (Joins)

Nav Property	Related Entity	Cardinality / Join
chargeback_fact	chargeback_fact	many
vm_capacity_fact	vm_capacity_fact	many
qtree_capacity_fact	qtree_capacity_fact	many
volume_history_capacity_fact	volume_history_capacity_fact	many

service_level_dimension↑ top

Entity Set(s): service_level_dimension

Field	Type	Nullable
tk	Int32	Yes
name	String	Yes
sequence	Int32	Yes
cost	Double	Yes
id	Int32	Yes
latest	String	Yes
dateTk	Int32	Yes

Navigation Properties (Joins)

Nav Property	Related Entity	Cardinality / Join
internal_volume_capacity_fact	internal_volume_capacity_fact	many
chargeback_fact	chargeback_fact	many
vm_capacity_fact	vm_capacity_fact	many
qtree_capacity_fact	qtree_capacity_fact	many
volume_history_capacity_fact	volume_history_capacity_fact	many

sp_time_to_fill↑ top

Entity Set(s): sp_time_to_fill

Field	Type	Nullable
saspFactTkPK	Int32	Yes
daysToStoragePoolFull	Int32	Yes
dateAtStoragePoolFull	DateTimeOffset	Yes

Navigation Properties (Joins)

Nav Property	Related Entity	Cardinality / Join
storage_and_storage_pool_capacity_fact	storage_and_storage_pool_capacity_fact	one JOIN: `saspFactTk` = storage_and_storage_pool_capacity_fact.`tk`

storage_and_storage_pool_capacity_fact↑ top

Entity Set(s): storage_and_storage_pool_capacity_fact

Field	Type	Nullable
tkPK	Int32	Yes
dateTkFK → date_dimension.tk	Int32	Yes
storagePoolTkFK → storage_pool_dimension.tk	Int32	Yes
storageTkFK → storage_dimension.tk	Int32	Yes
tierTkFK → tier_dimension.tk	Int32	Yes
backend	String	Yes
isVirtual	String	Yes
capacityMB	Int64	Yes
rawCapacityMB	Int64	Yes
usedCapacityMB	Int64	Yes
usedRawCapacityMB	Int64	Yes
snapshotUsedCapacityMB	Int64	Yes
snapshotUsedRawCapacityMB	Int64	Yes
softLimitCapacityMB	Int64	Yes
unconfiguredRawCapacityMB	Int64	Yes
spareRawCapacityMB	Int64	Yes
failedRawCapacityMB	Int64	Yes
volumeCapacityMB	Int64	Yes
unusedVolumeCapacityMB	Int64	Yes
volumeConsumedCapacityMB	Int64	Yes
mappedVolumeCapacityMB	Int64	Yes
maskedVolumeCapacityMB	Int64	Yes
internalVolumeAllocatedCapacityMB	Int64	Yes
internalVolumeUsedCapacityMB	Int64	Yes
internalVolumeConsumedCapacityMB	Int64	Yes
dedupeRatio	Double	Yes
dedupeSavingsGB	Int64	Yes
compressionRatio	Double	Yes
compressionSavingsGB	Int64	Yes
compressionSavingsPercent	Double	Yes
compactionRatio	Double	Yes
compactionSavingsGB	Int64	Yes
objectStoreUsedSpaceGB	Int64	Yes

Navigation Properties (Joins)

Nav Property	Related Entity	Cardinality / Join
storage_dimension	storage_dimension	one JOIN: `storageTk` = storage_dimension.`tk`
tier_dimension	tier_dimension	one JOIN: `tierTk` = tier_dimension.`tk`
storage_pool_dimension	storage_pool_dimension	one JOIN: `storagePoolTk` = storage_pool_dimension.`tk`
date_dimension	date_dimension	one JOIN: `dateTk` = date_dimension.`tk`
sp_time_to_fill	sp_time_to_fill	many
volume_history_capacity_fact	volume_history_capacity_fact	many

storage_and_storage_pool_capacity_future_fact↑ top

Entity Set(s): storage_and_storage_pool_capacity_future_fact

Field	Type	Nullable
tkPK	Int32	Yes
dateTkFK → date_dimension.tk	Int32	Yes
storagePoolTkFK → storage_pool_dimension.tk	Int32	Yes
storageTkFK → storage_dimension.tk	Int32	Yes
tierTkFK → tier_dimension.tk	Int32	Yes
backend	String	Yes
isVirtual	String	Yes
capacityMB	Int64	Yes
rawCapacityMB	Int64	Yes
usedCapacityMB	Int64	Yes
usedRawCapacityMB	Int64	Yes

Navigation Properties (Joins)

Nav Property	Related Entity	Cardinality / Join
storage_dimension	storage_dimension	one JOIN: `storageTk` = storage_dimension.`tk`
tier_dimension	tier_dimension	one JOIN: `tierTk` = tier_dimension.`tk`
storage_pool_dimension	storage_pool_dimension	one JOIN: `storagePoolTk` = storage_pool_dimension.`tk`
date_dimension	date_dimension	one JOIN: `dateTk` = date_dimension.`tk`

storage_dimension↑ top

Entity Set(s): storage_dimension

Field	Type	Nullable
tk	Int32	Yes
name	String	Yes
identifier	String	Yes
ip	String	Yes
model	String	Yes
manufacturer	String	Yes
serialNumber	String	Yes
microcodeVersion	String	Yes
family	String	Yes
url	String	Yes
id	Int32	Yes
latest	String	Yes
dateTk	Int32	Yes
dataCenter	String	Yes

Navigation Properties (Joins)

Nav Property	Related Entity	Cardinality / Join
internal_volume_capacity_fact	internal_volume_capacity_fact	many
chargeback_fact	chargeback_fact	many
disk_group_capacity_fact	disk_group_capacity_fact	many
vm_capacity_fact	vm_capacity_fact	many
disk_group_capacity_future_fact	disk_group_capacity_future_fact	many
qtree_capacity_fact	qtree_capacity_fact	many
storage_and_storage_pool_capacity_fact	storage_and_storage_pool_capacity_fact	many
volume_history_capacity_fact	volume_history_capacity_fact	many
storage_and_storage_pool_capacity_future_fact	storage_and_storage_pool_capacity_future_fact	many
storage_node_capacity_fact	storage_node_capacity_fact	many

storage_node_capacity_fact↑ top

Entity Set(s): storage_node_capacity_fact

Field	Type	Nullable
tkPK	Int32	Yes
dateTkFK → date_dimension.tk	Int32	Yes
storageTkFK → storage_dimension.tk	Int32	Yes
storageNodeTkFK → storage_node_dimension.tk	Int32	Yes
tierTkFK → tier_dimension.tk	Int32	Yes
totalNodeCapacityUtilizationMB	Int64	Yes
usableNodeCapacityUtilizationMB	Int64	Yes
usedNodeCapacityUtilizationMB	Int64	Yes
usedMetaDataNodeCapacityUtilizationMB	Int64	Yes
allowedMetaDataNodeCapacityUtilizationMB	Int64	Yes

Navigation Properties (Joins)

Nav Property	Related Entity	Cardinality / Join
storage_node_dimension	storage_node_dimension	one JOIN: `storageNodeTk` = storage_node_dimension.`tk`
storage_dimension	storage_dimension	one JOIN: `storageTk` = storage_dimension.`tk`
tier_dimension	tier_dimension	one JOIN: `tierTk` = tier_dimension.`tk`
date_dimension	date_dimension	one JOIN: `dateTk` = date_dimension.`tk`

storage_node_dimension↑ top

Entity Set(s): storage_node_dimension

Field	Type	Nullable
tk	Int32	Yes
name	String	Yes
identifier	String	Yes
version	String	Yes
model	String	Yes
serialNumber	String	Yes
siteName	String	Yes
url	String	Yes
id	Int32	Yes
latest	String	Yes
dateTk	Int32	Yes

Navigation Properties (Joins)

Nav Property	Related Entity	Cardinality / Join
storage_node_capacity_fact	storage_node_capacity_fact	many

storage_pool_dimension↑ top

Entity Set(s): storage_pool_dimension

Field	Type	Nullable
tk	Int32	Yes
identifier	String	Yes
name	String	Yes
storageName	String	Yes
storageIP	String	Yes
type	String	Yes
redundancy	String	Yes
thinProvisioningSupported	String	Yes
isVirtual	String	Yes
usesFlashPools	String	Yes
url	String	Yes
id	Int32	Yes
latest	String	Yes
dateTk	Int32	Yes

Navigation Properties (Joins)

Nav Property	Related Entity	Cardinality / Join
internal_volume_capacity_fact	internal_volume_capacity_fact	many
chargeback_fact	chargeback_fact	many
disk_group_capacity_fact	disk_group_capacity_fact	many
disk_group_capacity_future_fact	disk_group_capacity_future_fact	many
qtree_capacity_fact	qtree_capacity_fact	many
storage_and_storage_pool_capacity_fact	storage_and_storage_pool_capacity_fact	many
volume_history_capacity_fact	volume_history_capacity_fact	many
storage_and_storage_pool_capacity_future_fact	storage_and_storage_pool_capacity_future_fact	many

tier_dimension↑ top

Entity Set(s): tier_dimension

Field	Type	Nullable
tk	Int32	Yes
name	String	Yes
sequence	Int32	Yes
cost	Double	Yes
id	Int32	Yes
latest	String	Yes
dateTk	Int32	Yes

Navigation Properties (Joins)

Nav Property	Related Entity	Cardinality / Join
internal_volume_capacity_fact	internal_volume_capacity_fact	many
chargeback_fact	chargeback_fact	many
vm_capacity_fact	vm_capacity_fact	many
qtree_capacity_fact	qtree_capacity_fact	many
storage_and_storage_pool_capacity_fact	storage_and_storage_pool_capacity_fact	many
volume_history_capacity_fact	volume_history_capacity_fact	many
storage_and_storage_pool_capacity_future_fact	storage_and_storage_pool_capacity_future_fact	many
storage_node_capacity_fact	storage_node_capacity_fact	many

vm_capacity_fact↑ top

Entity Set(s): vm_capacity_fact

Field	Type	Nullable
tkPK	Int32	Yes
dateTkFK → date_dimension.tk	Int32	Yes
hostTkFK → host_dimension.tk	Int32	Yes
storageTkFK → storage_dimension.tk	Int32	Yes
virtualStorageTk	Int32	Yes
internalVolumeTkFK → internal_volume_dimension.tk	Int32	Yes
qtreeTkFK → qtree_dimension.tk	Int32	Yes
hostGroupTkFK → host_group_dimension.tk	Int32	Yes
applicationTkFK → application_dimension.tk	Int32	Yes
applicationGroupTkFK → application_group_dimension.tk	Int32	Yes
tierTkFK → tier_dimension.tk	Int32	Yes
serviceLevelTkFK → service_level_dimension.tk	Int32	Yes
vmTkFK → vm_dimension.tk	Int32	Yes
dataStoreTkFK → datastore_dimension.tk	Int32	Yes
dataStoreName	String	Yes
dataStoreId	Int32	Yes
virtualCenterIp	String	Yes
businessUnit	String	Yes
businessEntityTkFK → business_entity_dimension.tk	Int32	Yes
k8sNodeTkFK → k8s_node_dimension.tk	Int32	Yes
storageAccessType	String	Yes
capacityTypeFK → capacity_type.type	String	Yes
actualMB	Int64	Yes
provisionedMB	Int64	Yes

Navigation Properties (Joins)

Nav Property	Related Entity	Cardinality / Join
internal_volume_dimension	internal_volume_dimension	one JOIN: `internalVolumeTk` = internal_volume_dimension.`tk`
storage_dimension	storage_dimension	one JOIN: `storageTk` = storage_dimension.`tk`
business_entity_dimension	business_entity_dimension	one JOIN: `businessEntityTk` = business_entity_dimension.`tk`
k8s_node_dimension	k8s_node_dimension	one JOIN: `k8sNodeTk` = k8s_node_dimension.`tk`
host_group_dimension	host_group_dimension	one JOIN: `hostGroupTk` = host_group_dimension.`tk`
vm_dimension	vm_dimension	one JOIN: `vmTk` = vm_dimension.`tk`
application_group_dimension	application_group_dimension	one JOIN: `applicationGroupTk` = application_group_dimension.`tk`
service_level_dimension	service_level_dimension	one JOIN: `serviceLevelTk` = service_level_dimension.`tk`
capacity_type	capacity_type	one JOIN: `capacityType` = capacity_type.`type`
tier_dimension	tier_dimension	one JOIN: `tierTk` = tier_dimension.`tk`
application_dimension	application_dimension	one JOIN: `applicationTk` = application_dimension.`tk`
datastore_dimension	datastore_dimension	one JOIN: `dataStoreTk` = datastore_dimension.`tk`
qtree_dimension	qtree_dimension	one JOIN: `qtreeTk` = qtree_dimension.`tk`
host_dimension	host_dimension	one JOIN: `hostTk` = host_dimension.`tk`
date_dimension	date_dimension	one JOIN: `dateTk` = date_dimension.`tk`

vm_dimension↑ top

Entity Set(s): vm_dimension

Field	Type	Nullable
tk	Int32	Yes
name	String	Yes
naturalKey	String	Yes
os	String	Yes
virtualCenterIp	String	Yes
ips	String	Yes
url	String	Yes
id	Int32	Yes
latest	String	Yes
dateTk	Int32	Yes

Navigation Properties (Joins)

Nav Property	Related Entity	Cardinality / Join
vm_capacity_fact	vm_capacity_fact	many

volume_capacity_fact↑ top

Entity Set(s): volume_capacity_fact

Field	Type	Nullable
volumeTk	Int32	Yes
chargebackFactTk	Int32	Yes
storageAndSpFactTk	Int32	Yes
hostTk	Int32	Yes
storageTk	Int32	Yes
hostGroupTk	Int32	Yes
tierTk	Int32	Yes
serviceLevelTk	Int32	Yes
storagePoolTk	Int32	Yes
internalVolumeTk	Int32	Yes
qtreeTk	Int32	Yes
k8sNamespaceTk	Int32	Yes
k8sNamespaceGroupTk	Int32	Yes
isVirtual	String	Yes
isBackend	String	Yes
protectionType	String	Yes
isAccessed	String	Yes
isOrphaned	String	Yes
isProtection	String	Yes
isUnused	String	Yes
provisionedCapacityMB	Int64	Yes
accessedCapacityMB	Int64	Yes
orphanedCapacityMB	Int64	Yes
protectionCapacityMB	Int64	Yes
unusedCapacityMB	Int64	Yes
daysSinceLastAccessed	Int32	Yes

volume_dimension↑ top

Entity Set(s): volume_dimension

Field	Type	Nullable
tk	Int32	Yes
storageIdentifier	String	Yes
name	String	Yes
label	String	Yes
thinProvisioned	String	Yes
type	String	Yes
isVirtual	String	Yes
meta	String	Yes
snapshot	String	Yes
technologyType	String	Yes
uuid	String	Yes
isMainframe	String	Yes
url	String	Yes
id	Int32	Yes
latest	String	Yes
dateTk	Int32	Yes

Navigation Properties (Joins)

Nav Property	Related Entity	Cardinality / Join
volume_history_capacity_fact	volume_history_capacity_fact	many

volume_fact_current↑ top

Entity Set(s): volume_fact_current

Field	Type	Nullable
chargebackFactTkFK → chargeback_fact.tk	Int32	Yes
volumeIdPK	Int32	Yes
storageId	Int32	Yes
volumeName	String	Yes
volumeType	String	Yes
thinProvisioned	String	Yes
isVirtual	String	Yes
snapshot	String	Yes
technologyType	String	Yes
physicalUsableMB	Int64	Yes
physicalRawMB	Int64	Yes
provisionedUsableMB	Int64	Yes
provisionedRawMB	Int64	Yes

Navigation Properties (Joins)

Nav Property	Related Entity	Cardinality / Join
chargeback_fact	chargeback_fact	one JOIN: `chargebackFactTk` = chargeback_fact.`tk`

volume_history_capacity_fact↑ top

Entity Set(s): volume_history_capacity_fact

Field	Type	Nullable
tkPK	Int32	Yes
dateTkPK	Int32	Yes
volumeTkFK → volume_dimension.tk	Int32	Yes
chargebackFactTkFK → chargeback_fact.tk	Int32	Yes
storageAndSpFactTkFK → storage_and_storage_pool_capacity_fact.tk	Int32	Yes
hostTkFK → host_dimension.tk	Int32	Yes
storageTkFK → storage_dimension.tk	Int32	Yes
hostGroupTkFK → host_group_dimension.tk	Int32	Yes
tierTkFK → tier_dimension.tk	Int32	Yes
serviceLevelTkFK → service_level_dimension.tk	Int32	Yes
storagePoolTkFK → storage_pool_dimension.tk	Int32	Yes
internalVolumeTkFK → internal_volume_dimension.tk	Int32	Yes
qtreeTkFK → qtree_dimension.tk	Int32	Yes
k8sNamespaceTk	Int32	Yes
k8sNamespaceGroupTkFK → k8s_namespace_group_dimension.tk	Int32	Yes
isVirtual	String	Yes
isBackend	String	Yes
protectionType	String	Yes
isAccessed	String	Yes
isOrphaned	String	Yes
isProtection	String	Yes
isUnused	String	Yes
isMasked	String	Yes
isMapped	String	Yes
provisionedCapacityMB	Int64	Yes
accessedCapacityMB	Int64	Yes
orphanedCapacityMB	Int64	Yes
protectionCapacityMB	Int64	Yes
unusedCapacityMB	Int64	Yes
consumedCapacityMB	Int64	Yes
daysSinceLastAccessed	Int32	Yes

Navigation Properties (Joins)

Nav Property	Related Entity	Cardinality / Join
chargeback_fact	chargeback_fact	one JOIN: `chargebackFactTk` = chargeback_fact.`tk`
internal_volume_dimension	internal_volume_dimension	one JOIN: `internalVolumeTk` = internal_volume_dimension.`tk`
storage_dimension	storage_dimension	one JOIN: `storageTk` = storage_dimension.`tk`
storage_and_storage_pool_capacity_fact	storage_and_storage_pool_capacity_fact	one JOIN: `storageAndSpFactTk` = storage_and_storage_pool_capacity_fact.`tk`
host_group_dimension	host_group_dimension	one JOIN: `hostGroupTk` = host_group_dimension.`tk`
k8s_namespace_group_dimension	k8s_namespace_group_dimension	one JOIN: `k8sNamespaceGroupTk` = k8s_namespace_group_dimension.`tk`
service_level_dimension	service_level_dimension	one JOIN: `serviceLevelTk` = service_level_dimension.`tk`
tier_dimension	tier_dimension	one JOIN: `tierTk` = tier_dimension.`tk`
storage_pool_dimension	storage_pool_dimension	one JOIN: `storagePoolTk` = storage_pool_dimension.`tk`
qtree_dimension	qtree_dimension	one JOIN: `qtreeTk` = qtree_dimension.`tk`
host_dimension	host_dimension	one JOIN: `hostTk` = host_dimension.`tk`
date_dimension	date_dimension	one JOIN: `dateTk` = date_dimension.`tk`
volume_dimension	volume_dimension	one JOIN: `volumeTk` = volume_dimension.`tk`

Field	Type	Nullable
tk	Int32	Yes
repApp	String	Yes
repAppTk	Int32	Yes
cardinality	Int32	Yes
dateTk	Int32	Yes

Field	Type	Nullable
tk	Int32	Yes
fullname	String	Yes
tenant	String	Yes
lob	String	Yes
businessUnit	String	Yes
project	String	Yes
id	Int32	Yes
latest	String	Yes
dateTk	Int32	Yes

Field	Type	Nullable
volumeId	Int32	Yes
volumeNamePK	String	Yes
storageIdentifierPK	String	Yes
lastAccessed	DateTimeOffset	Yes

Table of Contents

Key Relationships Between Tables

Tables & Fields

application_dimension↑ top

Navigation Properties (Joins)

application_group_bridge↑ top

application_group_dimension↑ top

Navigation Properties (Joins)

business_entity_dimension↑ top

Navigation Properties (Joins)

capacity_type↑ top

Navigation Properties (Joins)

cardinals↑ top

chargeback_fact↑ top

Navigation Properties (Joins)

datastore_dimension↑ top

Navigation Properties (Joins)

date_dimension↑ top

Navigation Properties (Joins)

disk_group_capacity_fact↑ top

Navigation Properties (Joins)

disk_group_capacity_future_fact↑ top

Navigation Properties (Joins)

disk_group_dimension↑ top

Navigation Properties (Joins)

host_dimension↑ top

Navigation Properties (Joins)

host_group_bridge↑ top

host_group_dimension↑ top

Navigation Properties (Joins)

internal_volume_capacity_fact↑ top

Navigation Properties (Joins)

internal_volume_dimension↑ top

Navigation Properties (Joins)

k8s_cluster_dimension↑ top

Navigation Properties (Joins)

k8s_namespace_dimension↑ top

Navigation Properties (Joins)

k8s_namespace_group_bridge↑ top

k8s_namespace_group_dimension↑ top

Navigation Properties (Joins)

k8s_node_dimension↑ top

Navigation Properties (Joins)

k8s_pv_dimension↑ top

Navigation Properties (Joins)

k8s_pvc_capacity_fact↑ top

Navigation Properties (Joins)

k8s_pvc_dimension↑ top

Navigation Properties (Joins)

k8s_workload_dimension↑ top

qtree_capacity_fact↑ top

Navigation Properties (Joins)

qtree_dimension↑ top

Navigation Properties (Joins)

service_level_dimension↑ top

Navigation Properties (Joins)

sp_time_to_fill↑ top

Navigation Properties (Joins)

storage_and_storage_pool_capacity_fact↑ top

Navigation Properties (Joins)

storage_and_storage_pool_capacity_future_fact↑ top

Navigation Properties (Joins)

storage_dimension↑ top

Navigation Properties (Joins)

storage_node_capacity_fact↑ top

Navigation Properties (Joins)

storage_node_dimension↑ top

Navigation Properties (Joins)

storage_pool_dimension↑ top

Navigation Properties (Joins)

tier_dimension↑ top

Navigation Properties (Joins)

vm_capacity_fact↑ top

Navigation Properties (Joins)

vm_dimension↑ top

Navigation Properties (Joins)

volume_capacity_fact↑ top

volume_dimension↑ top

Navigation Properties (Joins)