Dimension Tables

Last modified: Jul 17, 2018 @ 10:42

This page gives information on the Dimension Table data fields.

Dim Date

The Dim Date displays information such as month, year, or week.

Connection: No Connections

Example of a Dim Date table:

Property Name Data Type Example Value
DateId integer 20170913
Date datetime 2017-09-13
Year integer 2017
YearMonth string 201709
Quarter integer 3
QuarterName string Third
Month integer 9
MonthName string September
Week integer 37
WeekName string Week 37
WeekYear string Week 37, 2017
WeekOfMonth integer 3
Day integer 256
DayOfMonth integer 13
DayOfWeek integer 3
MonthYear string Sep, 2017
QuarterInCalendar string Q3 2017
WeekDay string Wednesday
WeekEnding datetime 2017-09-16
IsWeekend string NO
DaysLeftMonth integer 17
DaysLeftYear integer 110
FirstDayOfMonth datetime 2017-09-01
LastDayOfMonth datetime 2017-09-30
FirstDayOfQuarter datetime 2017-07-01
LastDayOfQuarter datetime 2017-10-01
FirstDayOfYear datetime 2017-01-01
LastDayOfYear datetime 2017-12-31
FirstDayOfNextMonth datetime 2017-10-01
FirstDayOfNextYear datetime 2018-01-01
IsLastMonth string NO
IsCurrentWeek string YES
IsCurrentMonth string YES
IsCurrentQuarter string YES
IsLastQuarter string NO
IsLastWeek string NO
IsLastYear string NO
IsYearToDate string YES
IsToday string YES
IsYesterday string NO
IsLast7Days string YES
IsApprovedPeriod string NO
  • Dim Device

The Dim Device shows information about the devices, such as the device name, contact lost, is positioned (on floor plan), and a custom note.

Connection: Dim Device Type, Dim Device Location, Dim Device Network

Example of a Dim Device table:

Property Name Data Type Example Value
DeviceId uniqueidentifier/guid 11112222-3333-4444-5555-666677778888
DeviceTypeId uniqueidentifier/guid 11112222-3333-4444-5555-666677778888
LocationId uniqueidentifier/guid 11112222-3333-4444-5555-666677778888
DeviceNetworkId uniqueidentifier/guid 11112222-3333-4444-5555-666677778888
DeviceName string Device 1
DeviceIdentifier string deviceone
ContactLost string NO
ContactLostTime datetime NULL
LastSeen datetime 20170914
IsPositioned string YES
  • Dim Device GPS Position

The Dim Device GPS Position shows information about longitude and latitude for a certain Device.

Connection: Dim Device, Dim Device Network

Example of a Dim Device GPS Position table:

Property Name Data Type Example Value
PositionId uniqueidentifier/guid 11112222-3333-4444-5555-666677778888
DeviceId uniqueidentifier/guid 11112222-3333-4444-5555-666677778888
DeviceNetworkId uniqueidentifier/guid 11112222-3333-4444-5555-666677778888
Longitude float 13.049797662915
Latitude float 55.624072654908
Label string 2nd Floor
  • Dim Device Location

The Dim Device Location shows the location hierarchy from AppIoT. The Location field shows the entire tree, such as “Location 1 -> Location 2 -> Location 3”. The different levels show each level of the tree. There is a limit of six levels in the current Power BI content pack.

Connection: Dim Device, Dim Device Network

Example of a Dim Device Location Table:

Property Name Data Type Example Value
LocationId uniqueidentifier/guid 11112222-3333-4444-5555-666677778888
DeviceNetworkId uniqueidentifier/guid 11112222-3333-4444-5555-666677778888
Location string Office Ground Floor
LocationLevel1 string Office 2nd Floor
LocationLevel2 string Office 3rd Floor
LocationLevel3 string Office 4th Floor
LocationLevel4 string NULL
LocationLevel5 string NULL
LocationLevel6 string NULL
  • Dim Device Location Tags

The Dim Device Location Tag shows information about a tag name for a specific location.

Connection: Dim Device Location, Dim Device Network

Example of a Dim Device Location Tags Table:

Property Name Data Type Example Value
LocationId uniqueidentifier/guid 11112222-3333-4444-5555-666677778888
DeviceNetworkId uniqueidentifier/guid 11112222-3333-4444-5555-666677778888
LocationTagName string Conference Room
  • Dim Device Network

The Dim Device Network shows information about the current Device Network that the user is on.

Connection: No Connections

Example of a Dim Device Network Table:

Property Name Data Type Example Value
DeviceNetworkId uniqueidentifier/guid 11112222-3333-4444-5555-666677778888
DeviceNetworkName string Office Stockholm
  • Dim Device Position

The Dim Device Position shows data associated with floor plans.

Connection: Dim Device, Dim Device Network

Example of a Dim Device Position Table:

PropertyName Data Type Example Value
PositionId uniqueidentifier/guid 11112222-3333-4444-5555-666677778888
DeviceNetworkId uniqueidentifier/guid 11112222-3333-4444-5555-666677778888
Xpercentage decimal 0.840101522843
Xpercentage decimal 0.323809523810
Xpercentage decimal 0.000000000000
Xpixels decimal 2100.253807106599
Ypixels decimal 676.190476190000
Zpixels decimal 0.000000000000
Drawing string https://blobstorageurl/locationresources/locationresourceid.jpg
DrawingSVG string https://blobstorageurl/locationresources/locationresourceid/Floor_2.svg
Label string Floor 2
Xstart integer 0
Xend integer 2500
Ystart integer 0
Yend integer 1000
  • Dim Device Tag

The Dim Device Tag shows all tags set for the devices.

Connection: Dim Device, Dim Device Network

Example of a Dim Device Tag Table:

PropertyName Data Type Example Value
DeviceTagKey uniqueidentifier/guid 11112222-3333-4444-5555-666677778888
DeviceId uniqueidentifier/guid 11112222-3333-4444-5555-666677778888
DeviceNetworkId uniqueidentifier/guid 11112222-3333-4444-5555-666677778888
DeviceTag string Device 3, Floor 2
  • Dim Device Type

The Dim Device Type shows the type for each device, and indicates whether the device is virtual or not.

Connection: Dim Device, Dim Device Network

Example of a Dim Device Type Table:

Property Name Data Type Example Value
DeviceTypeId uniqueidentifier/guid 11112222-3333-4444-5555-666677778888
DeviceNetworkId uniqueidentifier/guid 11112222-3333-4444-5555-666677778888
DeviceType string AppIot Internal
IsVirtual string YES
  • Dim Event Category

The Dim Event Category shows all the categories set for an event.

Connection: Dim Device Network

Example of a Dim Event Category Table:

PropertyName Data Type Example Value
EventCategoryId uniqueidentifier 11112222-3333-4444-5555-666677778888
DeviceNetworkId uniqueidentifier 11112222-3333-4444-5555-666677778888
EventCategory string Temperature Changed
  • Dim Event Date

The Dim Event Date displays information such as month, year, or week.

Connection: No Connections

Example of a Dim Event Date Table:

Property Name Data Type Example Value
EventDateId integer 20170913
EventDate datetime 2017-09-13
EventYear integer 2017
EventYearMonth string 201709
EventQuarter integer 3
EventQuarterName string Third
EventMonth integer 9
EventMonthName string September
EventWeek integer 37
EventWeekName string Week 37
EventWeekYear string Week 37, 2017
EventWeekOfMonth integer 3
EventDay integer 256
EventDayOfMonth integer 13
EventDayOfWeek integer 3
EventMonthYear string Sep, 2017
EventQuarterInCalendar string Q3 2017
EventWeekDay string Wednesday
EventWeekEnding datetime 2017-09-16
EventIsWeekend string NO
EventDaysLeftMonth integer 17
EventDaysLeftYear integer 110
EventFirstDayOfMonth datetime 2017-09-01
EventLastDayOfMonth datetime 2017-09-30
EventFirstDayOfQuarter datetime 2017-07-01
EventLastDayOfQuarter datetime 2017-10-01
EventFirstDayOfYear datetime 2017-01-01
EventLastDayOfYear datetime 2017-12-31
EventFirstDayOfNextMonth datetime 2017-10-01
EventFirstDayOfNextYear datetime 2018-01-01
EventIsLastMonth string NO
EventIsCurrentWeek string YES
EventIsCurrentMonth string YES
EventIsCurrentQuarter string YES
EventIsLastQuarter string NO
EventIsLastWeek string NO
EventIsLastYear string NO
EventIsYearToDate string YES
EventIsToday string YES
EventIsYesterday string NO
EventIsLast7Days string YES
EventIsApprovedPeriod string NO
  • Dim Event Rules

The Dim Event Rules shows information about the event rules in AppIoT, such as the rule name, severity level, and many other information fields.

Connection: No Connections

Example of a Dim Event Rules Table:

Property Name Data Type Example Value
RuleId uniqueidentifier/guid 11112222-3333-4444-5555-666677778888
DeviceNetworkId uniqueidentifier/guid 11112222-3333-4444-5555-666677778888
RuleName string Temperature  Rule
Message string NULL
Condition integer 0
Description string Triggered every time temperature exceeds 35 degreed celcius
SeverityLevel integer 3
IsDeactivated boolean FALSE
TriggerResetMethod integer 1
ThresholdAggregationType integer 0
TriggerType integer 1
TriggerByDevice boolean FALSE
TriggerBySmartObject boolean TRUE
  • Dim Event Time

The Dim Event Time shows measurements from different viewpoints, such as Event Time of day, Event Working hours, or Event Time Actual.

Connection: No Connections

Example of a Dim Event Time Table:

PropertyName Data Type Example Value
EventTimeId integer 1337
EventTime time 13:37:00.0000000
EventHourOfDay24 integer 13
EventHourOfDay12 integer 1
EventMeridiem string PM
EventMinuteOfHour integer 37
EventHalfHour integer 2
EventHalfHourOfDay integer 28
EventQuarterHour integer 3
EventQuarterHourOfDay integer 55
EventTimeString24 string 13:37
EventTimeString12 string 01:37
EventCurrentNextHour24 string 13.00 – 14.00
EventCurrentNextHour12 string 1PM – 2PM
  • Dim Resource

The Dim Event Trigger Tag shows all the defined tags for the triggers.

Connection: Dim Resource Type, Dim Smart Object, Dim Device Network

Example of a Dim Resource Table:

Property Name Data Type Example Value
ResourceId uniqueidentifier/guid 11112222-3333-4444-5555-666677778888
ResourceTypeId uniqueidentifier/guid 11112222-3333-4444-5555-666677778888
DeviceNetworkId uniqueidentifier/guid 11112222-3333-4444-5555-666677778888
Url string resourceurl
IsUnavailable boolean FALSE
IsRequestObserve boolean TRUE
IsVirtual boolean TRUE
SmartObjectId uniqueidentifier/guid 11112222-3333-4444-5555-666677778888
  • Dim Resource Tag

The Dim Event Trigger Tag shows all the defined tags for the triggers.

Connection: Dim Resource, Dim Device Network

Example of a Dim Resource Tag Table:

Property Name Data Type Example Value
ResourceTagKey uniqueidentifier/guid 11112222-3333-4444-5555-666677778888
ResourceId uniqueidentifier/guid 11112222-3333-4444-5555-666677778888
DeviceNetworkId uniqueidentifier/guid 11112222-3333-4444-5555-666677778888
ResourceTag string Dimmer 2
  • Dim Resource Type

The Dim Event Trigger Tag shows all the defined tags for the triggers.

Connection: Dim Device Network

Example of a Dim Resource Type Table:

Property Name Data Type Example Value
ResourceTypeId uniqueidentifier/guid 11112222-3333-4444-5555-666677778888
DeviceNetworkId uniqueidentifier/guid 11112222-3333-4444-5555-666677778888
ResourceTypeName string Battery Level
AccessType integer 1
Mandatory boolean TRUE
MultipleInstances boolean FALSE
DataType integer 2
Range string 0-100
Units string percent
Description string Contains the current battery level as a percentage (with a range from 0 to 100). This value is only valid when the value of Available Power Sources Resource is 1.
IsReusable boolean FALSE
  • Dim Smart Objects

The Dim Event Trigger Tag shows all the defined tags for the triggers.

Connection: Dim Device, Dim Smart Object Type, Dim Device Network

Example of a Dim Smart Objects Table:

Property Name Data Type Example Value
SmartObjectId uniqueidentifier/guid 11112222-3333-4444-5555-666677778888
DeviceId uniqueidentifier/guid 11112222-3333-4444-5555-666677778888
SmartObjectTypeId uniqueidentifier/guid 11112222-3333-4444-5555-666677778888
SmartObjectLabel string Humidity
DeviceNetworkId uniqueidentifier/guid 11112222-3333-4444-5555-666677778888
  • Dim Smart Object Tags

The Dim Event Trigger Tag shows all the defined tags for the triggers.

Connection: Dim Event Trigger, Dim Device Network

Example of a Dim Smart Object Tags Table:

Property Name Data Type Example Value
SmartObjectId uniqueidentifier/guid 11112222-3333-4444-5555-666677778888
SmartObjectTag string Humidity
DeviceNetworkId uniqueidentifier/guid 11112222-3333-4444-5555-666677778888
  • Dim Smart Object Types

The Dim Event Trigger Tag shows all the defined tags for the triggers.

Connection: Dim Event Trigger, Dim Device Network

Example of a Dim Smart Object Types Table:

Property Name Data Type Example Value
SmartObjectTypeId uniqueidentifier/guid 11112222-3333-4444-5555-666677778888
SmartObjectType string Dimmer
DeviceNetworkId uniqueidentifier/guid 11112222-3333-4444-5555-666677778888
SmartObjectDescription uniqueidentifier/guid 11112222-3333-4444-5555-666677778888
  • Dim Time

The Dim Time shows measurements from different viewpoints, such as Time of day, Working hours or Time actual.

Connection: No Connections

Example of a Dim Time Table:

PropertyName Data Type Example Value
TimeId integer 1337
Time time 13:37:00.0000000
HourOfDay24 integer 13
HourOfDay12 integer 1
Meridiem string PM
MinuteOfHour integer 37
HalfHour integer 2
HalfHourOfDay integer 28
QuarterHour integer 3
QuarterHourOfDay integer 55
TimeString24 string 13:37
TimeString12 string 01:37
CurrentNextHour24 string 13.00 – 14.00
CurrentNextHour12 string 1PM – 2PM