Source: dwh_capacity_efficiency OData endpoint — Cloud Insights
Tables found: 3 | Associations: 2
| Referenced (parent) table | FK column | Parent PK |
|---|---|---|
| date_dimension | dateTk | tk |
| storage_dimension | storageTk | tk |
PK Primary Key FK Foreign Key NOT NULL Required field
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 |
| Nav Property | Related Entity | Cardinality / Join |
|---|---|---|
| efficiency_fact | efficiency_fact | many |
Entity Set(s): efficiency_fact
| Field | Type | Nullable |
|---|---|---|
| tkPK | Int32 | Yes |
| dateTkFK → date_dimension.tk | Int32 | Yes |
| storageTkFK → storage_dimension.tk | Int32 | Yes |
| rawCapacityMB | Int64 | Yes |
| backendCapacityMB | Int64 | Yes |
| storageTechnology | String | Yes |
| gainMB | Int64 | Yes |
| lossMB | Int64 | Yes |
| potentialGainMB | Int64 | Yes |
| potentialLossMB | Int64 | Yes |
| Nav Property | Related Entity | Cardinality / Join |
|---|---|---|
| storage_dimension | storage_dimension | one JOIN: storageTk = storage_dimension.tk |
| date_dimension | date_dimension | one JOIN: dateTk = date_dimension.tk |
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 |
| Nav Property | Related Entity | Cardinality / Join |
|---|---|---|
| efficiency_fact | efficiency_fact | many |