Register an Excel Worksheet With a URL from Business Analytics Hub
Use this procedure for Excel spreadsheets that are accessible with a URL using HTTP, such as through a content management system.
1. Select Connect > Excel File in the Business Analytics Hub main menu.
3. Set Link to URL as the location of the spreadsheet.
4. Enter the full URL to this Excel spreadsheet.
5. If this spreadsheet requires authentication information when you run it, choose the Security Profile to use for authentication and complete the fields for this profile. See Mashable Authentication with Security Profiles for details. 6. Enter the name or tab number for the Worksheet that contains the data you want to use in Business Analytics.
For example:
3 identifies the worksheet in the third tab of this spreadsheet.
RawData identifies the worksheet with the name "RawData".
7. Enter the Cell Range for the data that you want to use in this mashable in the form: top-left-cell:bottom-right-cell.
For example, A1:G88.
9. Click Register.
Business Analytics validates the URL, registers the mashable and turns this mashable information source on (by default). Then, either:
Grant permissions to run this mashable to other users and groups:
Choose the mashble-wide
Service >> mashable name permissions section to grant run permissions to all operations. Or expand a specific
Operation >> operation name section to grant run permissions for just that operation.
Click on a user or group in the
Search result list to add them to the list of
Principals with permissions.
Save the permissions once the list is complete.
Or skip permissions for now and click
Finish.
To allow other users to work with this mashable, you must grant run permissions at a later time.
