date_dimension

dateTk

tk

storage_dimension

storageTk

tk

tk

Int32

Yes

TK of the date object.

fullDate

DateTimeOffset

Yes

Date of the date object.

dayInMonth

Byte

Yes

Day of the month for the date object. The first day of the month has value 1.

dayInYear

Int32

Yes

Day in year of the date object. The first day of the year has value 1.

dateYear

Int32

Yes

Year of the date object.

yearLabel

String

Yes

Year formatted as String

monthNum

Byte

Yes

Month of the date object. January has value 1.

monthLabel

String

Yes

Month formatted as String

dayInWeekNum

Byte

Yes

Day of the week for the date object. Sunday has value 1.

quarter

Byte

Yes

Quarter of the date object. First quarter has value 1.

quarterLabel

String

Yes

Quarter formatted as String

dayInQuarter

Int32

Yes

Day in quarter of the date object. First day of the quarter has value 1.

repQuarter

Byte

Yes

Indicates whether this date is the first date available for its quarter.

repMonth

Byte

Yes

Indicates whether this date is the first date available for its month.

repWeek

Byte

Yes

Indicates whether this date is the first date available for its week.

repDay

Byte

Yes

Indicates whether this date is the first date available for its day.

repMonthOrLatest

Byte

Yes

Indicates whether this date is the repmonth or the latest. This flag is used by Datamarts which works on monthly reps. Only difference being for the current month it is the latest

sspFlag

Byte

Yes

Indicates whether this date is used in Storage and Storage Pool Datamart. It is true for month representatives and for the last number of days as defined in configuration.

latest

String

Yes

Indicates whether this date is the last date available in the table.

future

String

Yes

Indicates whether this date is a future date (projection) or regular one.

tk [PK]

Int32

Yes

TK of the fact.

dateTk [FK] →date_dimension.tk

Int32

Yes

TK of the date.

storageTk [FK] →storage_dimension.tk

Int32

Yes

TK of the storage where the capacity resides.

rawCapacityMB

Int64

Yes

Storage raw capacity in MB. 0 when technology is specified (not NULL).

backendCapacityMB

Int64

Yes

Total capacity of backend LUNs in a virtual array, in MB. 0 when technology is specified (not NULL).

storageTechnology

String

Yes

Storage efficiency and protection technology such as Dedupe, Thin Provisioning, Snapshot and RAID. NULL when representing raw and backend capacity of the storage (one row per storage) .

gainMB

Int64

Yes

Capacity gained by using the technology. 0 when technology is not specified (NULL).

lossMB

Int64

Yes

Capacity lost by using the technology. 0 when technology is not specified (NULL).

potentialGainMB

Int64

Yes

Potential capacity to gain by using the technology to the full extent. 0 when technology is not specified (NULL).

potentialLossMB

Int64

Yes

Potential capacity to loss by using the technology to the full extent. 0 when technology is not specified (NULL).

tk

Int32

Yes

TK of this storage array row.

name

String

Yes

Name of the storage array.

identifier

String

Yes

Identifier of the device.

ip

String

Yes

IP address of the storage array.

model

String

Yes

Model of the storage array.

manufacturer

String

Yes

Manufacturer of the storage array.

serialNumber

String

Yes

Serial number for the storage array.

microcodeVersion

String

Yes

Version of the firmware running on the storage array.

family

String

Yes

Family name of the storage array (e.g. Clariion, Symmetrix etc).

url

String

Yes

Url to this storage in Insight Server.

id

Int64

Yes

GUID of the storage array in dwh_inventory.storage.

latest

String

Yes

Indicates whether this row is the latest one for this storage.

dateTk

Int32

Yes

TK of the date in which this stroage array row was created.

dataCenter

String

Yes

dataCenter annotation value assigned to dwh_dimensions.storage_dimension