Mashables and Mashups : Mashables : Types of Mashable Information Sources : Spreadsheet Mashables
Spreadsheet Mashables
 
Valid Labels and Values for Spreadsheet/CSV Mashables
You can use Excel spreadsheets as a mashable information source in Business Analytics by registering cell ranges as:
*A snapshot of data for Excel spreadsheets on your local computer or any accessible network drive. With local spreadsheets, you must reregister to update the spreadsheet mashable in Business Analytics if you update spreadsheet data and want that information to be accessible in Business Analytics.
*A dynamic source of data for Excel spreadsheets that are accessible remotely via HTTP. Remote access allows Business Analytics to retrieve current data whenever the mashable information source is used.For example, spreadsheets hosted in SharePoint can be registered remotely.
Note:  
Remote spreadsheet mashables are handled as REST mashables in Business Analytics. With remote spreadsheet mashables, Business Analytics administrators can also control HTTP response headers and timeouts for connections.
See Register an Excel Worksheet File from Business Analytics Hub for more information about registering spreadsheets. See Valid Labels and Values for Spreadsheet/CSV Mashables also.
Copyright © 2013-2016 Software AG, Darmstadt, Germany.

Product LogoContact Support   |   Community   |   Feedback