Table formulas in SAP Analytics Cloud are specifically designed to perform cell-based calculations directly within a table widget in a story. This feature allows users to add new rows or columns and then define custom, spreadsheet-like formulas for individual cells. These formulas can reference other cells or ranges within the table, enabling highly specific, localized calculations that are not part of the underlying data model. This directly addresses the requirement for "cell-based calculations."

A. Calculated measures: These are defined in the model or story builder and apply a consistent formula to an entire measure (column), not to specific, individual cells within a table's display.

B. Dimension formulas: This is not a standard term for a calculation feature in SAP Analytics Cloud. While formulas can be used to create calculated dimensions, this is not for cell-based numeric calculations.

C. Restricted measures: This feature is used to filter a measure based on dimension members (e.g., Revenue for a specific region). It restricts data rather than performing a calculation on cells.

1. SAP Help Portal

SAP Analytics Cloud

"Adding Formulas to Tables": This document explicitly states

"You can add formulas to tables to perform calculations on table cells... You can add a formula to a cell

a row

or a column." This confirms the cell-based nature of table formulas.

2. SAP Help Portal

SAP Analytics Cloud

"Calculated Measures": This source describes calculated measures as being created in the Builder panel and based on other measures and members. The calculation is applied universally to the measure

not on a cell-by-cell basis within a table visualization.

3. SAP Help Portal

SAP Analytics Cloud

"Restricted Measures": This documentation details how to create a restricted measure by selecting a measure and then choosing one or more dimension members to filter it by. This confirms its function as a filtering tool

not a calculation tool.