Can we change the definition of start and end hours for a day in Dashboards?
Issue
Currently, a day is defined in PME dashboards as starting at 00:00 and ending at 23:59.
Product Line
Power Monitoring Expert 7.2.x
Power Monitoring Expert 8.x
Power Monitoring Expert 9.x
Environment
Power Monitoring Expert Software Configuration
Cause
In some circumstances, it is possible days are defined differently than the standard where the day starts at 0:00 and ends at 23:59. In such cases, it would be pertinent to be able to modify the start and end hours for a day in dashboards.
Resolution
*Warning: Irreparable database damage can occur. This procedure should only be performed by users familiar with SQL Server Management Studio. Databases should be backed up prior to performing this procedure.*
For dashboards, the date ranges are specified in the database using a domain language. It is natural language based and relatively intuitive. The database table in the ApplicationModules database called Time.Period contains details for the dashboard web application time range. To change the "start of day" from the default (midnight) to some other value, right click the table and select "Edit Top 200 Rows". Change the formula column to match your needs.
Below is an example that would specify 8:00AM as the "start of day". I'm showing the original table contents in the two left columns; edit the contents of the "Formula" column to match that in rightmost column. Note that the first 8 rows are not changed as the date range doesn't involve a natural day boundary.
CAVEAT: These changes are not guaranteed to survive a software upgrade.
Currently, a day is defined in PME dashboards as starting at 00:00 and ending at 23:59.
Product Line
Power Monitoring Expert 7.2.x
Power Monitoring Expert 8.x
Power Monitoring Expert 9.x
Environment
Power Monitoring Expert Software Configuration
Cause
In some circumstances, it is possible days are defined differently than the standard where the day starts at 0:00 and ends at 23:59. In such cases, it would be pertinent to be able to modify the start and end hours for a day in dashboards.
Resolution
*Warning: Irreparable database damage can occur. This procedure should only be performed by users familiar with SQL Server Management Studio. Databases should be backed up prior to performing this procedure.*
For dashboards, the date ranges are specified in the database using a domain language. It is natural language based and relatively intuitive. The database table in the ApplicationModules database called Time.Period contains details for the dashboard web application time range. To change the "start of day" from the default (midnight) to some other value, right click the table and select "Edit Top 200 Rows". Change the formula column to match your needs.
Below is an example that would specify 8:00AM as the "start of day". I'm showing the original table contents in the two left columns; edit the contents of the "Formula" column to match that in rightmost column. Note that the first 8 rows are not changed as the date range doesn't involve a natural day boundary.
| TABLE: | [ApplicationModules].[Time].[Period] | ||
| PeriodId | Name | Formula | Change Formula to This |
| 1 | Last Hour | last hour | last hour |
| 2 | This Hour | from this hour to startof (next hour) | from this hour to startof (next hour) |
| 3 | Last 2 Hours | from last hour to startof (next hour) | from last hour to startof (next hour) |
| 4 | Last 4 Hours | from 3 hours ago to startof (next hour) | from 3 hours ago to startof (next hour) |
| 5 | Last 8 Hours | from 7 hours ago to startof (next hour) | from 7 hours ago to startof (next hour) |
| 6 | Last 12 Hours | from 11 hours ago to startof (next hour) | from 11 hours ago to startof (next hour) |
| 7 | Last 16 Hours | from 15 hours ago to startof (next hour) | from 15 hours ago to startof (next hour) |
| 8 | Last 24 Hours | from 23 hours ago to startof (next hour) | from 23 hours ago to startof (next hour) |
| 9 | Yesterday | yesterday | from first hour=8 in yesterday to startof(first hour=8 in today) |
| 10 | Today | from startof (today) to now | from first hour=8 in today to now |
| 11 | Last 7 Days | from six days ago to now | from first hour=8 in six days ago to now |
| 12 | Last 14 Days | from 13 days ago to now | from first hour=8 in 13 days ago to now |
| 13 | Last 30 Days | from 29 days ago to now | from first hour=8 in 29 days ago to now |
| 14 | Last Week | last week | from first hour=8 in last week to startof(first hour=8 in this week) |
| 15 | This Week (=Week to Date) | from this week to now | from first hour=8 in this week to now |
| 16 | Last 2 Weeks | from last week to now | from first hour=8 in last week to now |
| 17 | Last Month | last month | from first hour=8 in last month to startof(first hour=8 in this month) |
| 18 | This Month (=Month to Date) | from this month to now | from first hour=8 in this month to now |
| 19 | Last 2 Months | from last month to now | from first hour=8 in last month to now |
| 20 | Last Year | last year | from first hour=8 in last year to startof(first hour=8 in this year) |
| 21 | This Year (=Year to Date) | from this year to now | from first hour=8 in this year to now |
| 22 | Last 2 Years | from last year to now | from first hour=8 in last year to now |
CAVEAT: These changes are not guaranteed to survive a software upgrade.
게시 대상: 슈나이더 일렉트릭 Korea
도움이 필요하신가요?
제품 선택기
애플리케이션에 적합한 제품과 액세서리를 빠르고 쉽게 찾을 수 있습니다.
견적 받기
영업 관련하여 온라인으로 문의하시면 전문가가 연락드립니다.
구매처
해당 지역의 가장 가까운 슈나이더 일렉트릭 대리점을 쉽게 찾을 수 있습니다.
지원 센터
한 곳에서 모든 요구 사항에 대한 지원 리소스를 찾아보십시오.