Spreadsheet 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. |