Register an Excel Worksheet File from Business Analytics Hub

Appendix : Legacy Presto components : Mashables and Mashups : Mashables : Connect Information Sources as Mashables : Register Spreadsheets as Mashables : Register an Excel Worksheet File from Business Analytics Hub

Use this procedure for Excel spreadsheets that are located on your computer or a network drive.

1. Select Connect > Excel File in the Business Analytics Hub main menu.

2. Enter a unique Name for the mashable for this spreadsheet.. MashZone NextGen uses this name to assign a unique ID. For more information, see What are valid artifact names and IDs?.

3. Set Upload File as the location of the spreadsheet.

4. Click Browse and find the Excel spreadsheet you want to use.

5. 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".

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

7. Add metadata for this mashable, such as a description or category. For more information, see Descriptions, Providers, Categories and Tags for Artifacts external.

8. Click Register.

Business Analytics uploads a snapshot of the spreadsheet data, 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.

Find Users and Groups for Permissions or Choose Business Analytics Built-In Groups for Permissions.

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.

Note:

Some groups or users may already be listed as Principals with permissions. These users and groups have been defined by a Business Analytics administrator to grant permission automatically.

Contact Support | Community | Feedback