Designing Workbooks: Preferences, Styling and Components

Objective

After completing this lesson, you will be able to set preferences for the SAP Analytics Cloud, add-in for Microsoft Excel.

Workbook Panel

Workbook-level preferences and styling options are managed in the Workbook panel. To open it, choose Workbook from the ribbon in the Design group.

The Workbook panel contains three tabs: Preferences, Styling, and Components.

Workbook Preferences

The Preferences tab is where you define the workbook's behavior. Key settings include:

  1. Workbook Refresh: defines whether the workbook should be refreshed automatically when signing in. When you open a saved workbook, the tables show the last saved state. Use this setting to control whether data is loaded automatically when the app opens.
  2. Workbook Permissions: depending on assigned permissions, a user can either update or view workbooks. You can choose between:
    • Use SAP Analytics Cloud permissions (default): the add-in validates the permissions assigned to the user in SAP Analytics Cloud. A user with Designer rights can access all add-in features. A user with Viewer rights has limited options for changing report layouts.
    • All users have Designer rights: overrides permission checks.

    Additional information can be found in the SAP Help Portal Permissions for the add-in.

  3. Optimize Data Retrieval: enabling this preference improves the performance of SAP.GETDATA and SAP.SETDATA formula-based workbooks by optimizing how data is fetched from the backend.
Workbook Preferences dialog with three options described above.

Workbook Styling

The Styling tab lets you choose the preferred hierarchy styling, such as a level-based indentation style. These settings control the visual appearance of hierarchy members in your tables.

Workbook styling tab is accessed from the Workbook button

Workbook Components

Managing Workbook Objects

All add-in objects in your workbook, such as tables and data sources for formulas, can be managed from the Components tab in the Workbook Design group. You can group objects by sheet or by data source to get an overview of your workbook.

workbook components are visible by clicking Design Workbook

If named ranges associated with add-in objects are missing (for example, because a sheet was deleted while offline), the affected objects are listed in the Components tab. You can choose to restore or permanently delete each missing object at any time.

Summary

You should now be able to work with the Workbook design feature for the SAP Analytics Cloud, add-in for Microsoft Excel.