{}

המותגים שלנו

Impact-Company-Logo-English Black-01-177x54

ברוכים הבאים לאתר האינטרנט של שניידר אלקטריק

ברוכים הבאים לאתר שלנו.
שאלות נפוצות
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.
TABLE:[ApplicationModules].[Time].[Period]
PeriodIdNameFormulaChange Formula to This
1Last Hourlast hourlast hour
2This Hourfrom this hour to startof (next hour)from this hour to startof (next hour)
3Last 2 Hoursfrom last hour to startof (next hour)from last hour to startof (next hour)
4Last 4 Hoursfrom 3 hours ago to startof (next hour)from 3 hours ago to startof (next hour)
5Last 8 Hoursfrom 7 hours ago to startof (next hour)from 7 hours ago to startof (next hour)
6Last 12 Hoursfrom 11 hours ago to startof (next hour)from 11 hours ago to startof (next hour)
7Last 16 Hoursfrom 15 hours ago to startof (next hour)from 15 hours ago to startof (next hour)
8Last 24 Hoursfrom 23 hours ago to startof (next hour)from 23 hours ago to startof (next hour)
9Yesterdayyesterdayfrom first hour=8 in yesterday to startof(first hour=8 in today)
10Todayfrom startof (today) to nowfrom first hour=8 in today to now
11Last 7 Daysfrom six days ago to nowfrom first hour=8 in six days ago to now
12Last 14 Daysfrom 13 days ago to nowfrom first hour=8 in 13 days ago to now
13Last 30 Daysfrom 29 days ago to nowfrom first hour=8 in 29 days ago to now
14Last Weeklast weekfrom first hour=8 in last week to startof(first hour=8 in this week)
15This Week (=Week to Date)from this week to nowfrom first hour=8 in this week to now
16Last 2 Weeksfrom last week to nowfrom first hour=8 in last week to now
17Last Monthlast monthfrom first hour=8 in last month to startof(first hour=8 in this month)
18This Month (=Month to Date)from this month to nowfrom first hour=8 in this month to now
19Last 2 Monthsfrom last month to nowfrom first hour=8 in last month to now
20Last Yearlast yearfrom first hour=8 in last year to startof(first hour=8 in this year)
21This Year (=Year to Date)from this year to nowfrom first hour=8 in this year to now
22Last 2 Yearsfrom last year to nowfrom first hour=8 in last year to now

CAVEAT: These changes are not guaranteed to survive a software upgrade.

שניידר אלקטריק ישראל

גלה עוד
טווח:
מאמרים שעשויים להיות מועילים
גלה עוד
טווח: