RM-EDR
01. What is RM-EDR ?
RM-EDR is an expanded solution about a refreshing function of Microsoft PowerPivot data which is a BI function of SharePoint. Generally, the Microsoft PowerPivot data was refreshed on a day to day basis but RM-EDR is an upgraded solution for the refreshing basis at least of 10 minutes unit and one-hour unit.
02. Architecture for refreshing Microsoft PowerPivot data
- SQL Server Analysis Service (Original external data of SharePoint Server Farm)
- SharePoint User make a reservation for refreshing via data refreshing UI
- Proceeding meta data management for data refreshing via scheduling information of PowerPivot System Service
- Through Excel Calculation Service, rendering data to web part of Excel Web Access
- Data access control to Secure Store Service account or Effective Username via designated verifying qualification
- Transmit alert to refresh Timerjob’s data in SharePoint when it comes scheduled time
03. Refreshing data in Microsoft PowerPivot vs RM-EDR 2.0
| Features | RM-EDR | Microsoft |
|---|---|---|
| Data refreshing by the day | O | O |
| Data refreshing by the day for specific day of the week | O | O |
| Data refreshing by the week | O | O |
| Data refreshing by the week for specific day of the week | O | O |
| Data refreshing by the month | O | O |
| Implement immediately | O | O |
| Data refreshing after office hour | O | O |
| Data refreshing by the minute | O | X |
| Data refreshing by the hour | O | X |
| After overwriting Excel report and not necessary to re-enter the schedule | O | X |
| Refreshing Excel report which is library unit (Beta) in a batch | O | X |
| Mailing with refreshed documents | O | X |
04. Refreshing data in Microsoft PowerPivot vs RM-EDR 2.0
