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

rm-edr-img01

  • 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

zaelsia

▼ Global Menu

  • Company Overview
  • Reference
  • Partnership
  • Question
  • Product : Longview
  • Product : Paxata
  • Product : microsoft DW/BI
  • Product : RM-SERIES
    • RM-Studio for SAP
    • RM-Dashboard
    • RM-EIS
    • RM-EDR
    • RM-Conference

CONTACT US

● CONTACT
Tel. (+82) 02-544-5150
Fax. (+82) 02-544-4662
info@zalesia.com

● ADDRESS
Hwa-ryun Bldg 5th floor, 230, Dongjak-daero, Seocho-gu, Seoul, Republic of Korea

● OFFICE HOURS
Mon-Fri: 9:00 – 18:00
(Closed Weekend/Holiday)

Scroll to top