Appendix : Legacy Presto components : Mashables and Mashups : Mashables : Connect Information Sources as Mashables : Register Spreadsheets as Mashables
Register Spreadsheets as Mashables
 
Register an Excel Worksheet File from Business Analytics Hub
Register an Excel Worksheet With a URL from Business Analytics Hub
You can use Excel spreadsheets as mashable information sources in Business Analytics.
Important:  
How Business Analytics accesses spreadsheets determines whether the data from the spreadsheet is a simple snapshot or is dynamic.
If the spreadsheet is located on your computer or on a network drive, Business Analytics takes a snapshot of the data when you register the spreadsheet. Updates to your spreadsheet are not automatically visible in Business Analytics. You must re-register the spreadsheet to update the data in Business Analytics in this case.
If the spreadsheet is hosted in a content management system, such as SharePoint, or is simply accessible with a URL using HTTP, Business Analytics links to the spreadsheet rather than copying data. Each time users use the spreadsheet mashable in Business Analytics, Business Analytics retrieves the current data from the spreadsheet dynamically.
You have two ways that you can register worksheets in Business Analytics:
*From the Connect menu in Business Analytics Hub. See Register an Excel Worksheet File from Business Analytics Hub and Register an Excel Worksheet With a URL from Business Analytics Hub for instructions.
*With the Business Analytics Add-On for Excel.
Copyright © 2013-2017 Software AG, Darmstadt, Germany. (Innovation Release)

Product LogoContact Support   |   Community   |   Feedback